C#自己写的报错机制

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("名称重复!");
                }

                SqlCommand cmd = new SqlCommand(str.ToString(), con, tran);
                SC.SetParameter(cmd, "@fID", FID);
                SC.SetParameter(cmd, "@name", strName);
                SC.SetParameter(cmd, "@strStartTime", strStartTime);
                SC.SetParameter(cmd, "@strEndTime",strEndTime);
                cmd.ExecuteNonQuery();
                tran.Commit();
                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)
        {
        }
    }


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值