public static string UpdateTable(string FID,string strName,string strEndTime,datetime strStartTime)
{
if (!string.IsNullOrEmpty(strEndTime)&&(strStartTime>Convert.ToDateTime(strEndTime)))
{
throw new CustMessage("开始时间不能大于结束时间!");
}
StringBuilder str = new StringBuilder();
str.AppendLine("update tItabel set name=@strName,date1=@strStartTime,date2=@strEndTime where fID=@fID");
SqlConnection con = new SqlConnection(DBConnString);
SqlTransaction tran = null;
try
{
con.Open();
tran = con.BeginTransaction();
SqlCommand cmdc = new SqlCommand(chongfu.ToString(), con, tran);
SC.SetParameter(cmdc, "@strName", strName);
SC.SetParameter(cmdc, "@fID", FID);
string aa = DataHelper.GetString(cmdc);
if (!string.IsNullOrEmpty(aa))
{
throw new CustMessage("名称重复!");
}
SC.SetParameter(cmd, "@fID", FID);
SC.SetParameter(cmd, "@name", strName);
SC.SetParameter(cmd, "@strStartTime", strStartTime);
SC.SetParameter(cmd, "@strEndTime",strEndTime);
return "";
}
catch (CustMessage ex)
{
tran.Rollback();
throw ex;
}
catch (SqlException)
{
tran.Rollback();
throw new Exception("应用服务器没法连接,请与系统管理员联系。");
catch (Exception)
{
tran.Rollback();
throw new Exception("系统异常!");
}
finally
{
con.Close();
tran.Dispose();
}
}
public class CustMessage : Exception
{
public CustMessage(string str)
: base(str)
{
}
}