public bool DeleteCloseAddressConfig(CloseAddressConfig obj) { try { ComDbOpen.DbOpen(_DBSession); //清空参数 _DBSession.ClearParam(); string query = @"delete from CloseAddressConfig where id = @id"; // 设置SQL参数 _DBSession.SetInParam("@id", obj.Id); _DBSession.ExecuteNonQuery(query); _DBSession.Close(); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }
public bool AddCloseAddressConfig(CloseAddressConfig obj) { try { ComDbOpen.DbOpen(_DBSession); //清空参数 _DBSession.ClearParam(); string query = @"insert into CloseAddressConfig(sellerNick,receiverName,phone,status,createDate) values(@sellerNick,@receiverName,@phone,@status,getdate())"; // 设置SQL参数 _DBSession.SetInParam("@sellerNick", obj.SellerNick); _DBSession.SetInParam("@receiverName", obj.ReceiverName); _DBSession.SetInParam("@phone", obj.Phone); _DBSession.SetInParam("@status", obj.Status); _DBSession.ExecuteNonQuery(query); _DBSession.Close(); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }
public static bool DeleteCloseAddressConfig(CloseAddressConfig obj) { ShieldRulesDAL objDal = new ShieldRulesDAL(); return(objDal.DeleteCloseAddressConfig(obj)); }