/// <summary> /// 修改卖家差评防御配置 /// </summary> /// <param name="obj"></param> /// <returns></returns> public bool UpdateCloseOrderConfig(CloseOrderConfig obj) { try { ComDbOpen.DbOpen(_DBSession); //清空参数 _DBSession.ClearParam(); string query = @" update CloseOrderConfig set buyerRegDays = @buyerRegDays, buyerCreditFen = @buyerCreditFen, totalBadRateCount = @totalBadRateCount, totalTuiKuanCount = @totalTuiKuanCount, unCertify = @unCertify, cellPhoneClose = @cellPhoneClose, unpayMinutesClose = @unpayMinutesClose, payQuikAddMemo = @payQuikAddMemo, closeStartDate = @closeStartDate, closeEndDate = @closeEndDate, orderGreaterThan = @orderGreaterThan, closeReason = @closeReason, dangerBuyerCloseAndMemo = @dangerBuyerCloseAndMemo, dangerBuyerNotCloseAddMemo = @dangerBuyerNotCloseAddMemo, memoQiZhi = @memoQiZhi, memoContent = @memoContent, updateDate = getdate() where sellerNick = @sellerNick"; // 设置SQL参数 _DBSession.SetInParam("@sellerNick", obj.SellerNick); _DBSession.SetInParam("@buyerRegDays", obj.BuyerRegDays); _DBSession.SetInParam("@buyerCreditFen", obj.BuyerCreditFen); _DBSession.SetInParam("@totalBadRateCount", obj.TotalBadRateCount); _DBSession.SetInParam("@totalTuiKuanCount", obj.TotalTuiKuanCount); _DBSession.SetInParam("@unCertify", obj.UnCertify); _DBSession.SetInParam("@cellPhoneClose", obj.CellPhoneClose); _DBSession.SetInParam("@unpayMinutesClose", obj.UnpayMinutesClose); _DBSession.SetInParam("@payQuikAddMemo", obj.PayQuikAddMemo); _DBSession.SetInParam("@closeStartDate", string.IsNullOrEmpty(obj.CloseStartDate) ? "NULL" : obj.CloseStartDate); _DBSession.SetInParam("@closeEndDate", string.IsNullOrEmpty(obj.CloseEndDate) ? "NULL" : obj.CloseEndDate); _DBSession.SetInParam("@orderGreaterThan", obj.OrderGreaterThan); _DBSession.SetInParam("@closeReason", obj.CloseReason); _DBSession.SetInParam("@dangerBuyerCloseAndMemo", obj.DangerBuyerCloseAndMemo); _DBSession.SetInParam("@dangerBuyerNotCloseAddMemo", obj.DangerBuyerNotCloseAddMemo); _DBSession.SetInParam("@memoQiZhi", obj.MemoQiZhi); _DBSession.SetInParam("@memoContent", obj.MemoContent); _DBSession.ExecuteNonQuery(query); _DBSession.Close(); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }
public static bool UpdateCloseOrderConfig(CloseOrderConfig obj3) { ShieldRulesDAL objDal = new ShieldRulesDAL(); return(objDal.UpdateCloseOrderConfig(obj3)); }
public static bool AddCloseOrderConfig(CloseOrderConfig obj) { ShieldRulesDAL obj2 = new ShieldRulesDAL(); return(obj2.AddCloseOrderConfig(obj)); }