/// <summary> /// 删除告警触发事件 /// </summary> /// <param name="Id"></param> /// <returns></returns> public int DeleteAlarmEventById(int Id) { var cmd = new DataCommand("deleteAlarmEventById", new SqlCustomDbCommand()); cmd.SetParameterValue("@Id", Id); return cmd.ExecuteNonQuery(); }
public void MaintainCountdownStatus(CountdownInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("MaintainCountdownStatus"); command.SetParameterValue("@SysNo", entity.SysNo); command.SetParameterValue("@Status", entity.Status); command.SetParameterValue("@CompanyCode", entity.CompanyCode); command.SetParameterValueAsCurrentUserAcct("@EditUser"); command.ExecuteNonQuery(); }
/// <summary> /// 删除阶梯数据 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool DeleteStepByID(int id) { var cmd = new DataCommand("deleteStepByID", new SqlCustomDbCommand()); cmd.SetParameterValue("@ID", id); int result = cmd.ExecuteNonQuery(); if (result > 0) return true; else return false; }
public void InsertVendorUser_VendorExForUpdate(VendorUserMapping entity) { DataCommand dc = DataCommandManager.GetDataCommand("External_InsertVendorUser_VendorExForUpdate"); dc.SetParameterValue("@UserSysNo", entity.UserSysNo); dc.SetParameterValue("@ManufacturerSysNo", entity.ManufacturerSysNo); dc.SetParameterValue("@IsAuto", entity.IsAuto); dc.ExecuteNonQuery(); }
public static void CloseRequestWithOutAdjustInventory(VirtualRequestEntity request) { DataCommand command = DataCommandManager.GetDataCommand("CloseRequestWithOutAdjustInventory"); command.SetParameterValue("@ProductSysNo", request.ProductSysNo); command.SetParameterValue("@StockSysNo", request.StockSysNo); command.SetParameterValue("@CompanyCode", request.CompanyCode); command.ExecuteNonQuery(); }
public static void UpdateExtendPOInfo(int sysNO, string companyCode, int productSysNo) { DataCommand cmd = DataCommandManager.GetDataCommand("UpdateExtendPOInfo"); cmd.SetParameterValue("@SysNo", sysNO); cmd.SetParameterValue("@Companycode", companyCode); cmd.SetParameterValue("@ProductSysNo", productSysNo); cmd.ExecuteNonQuery(); }
public static void UpdateLocalWHMark(int soSysNo, string localWH, int targetStatus) { DataCommand command = DataCommandManager.GetDataCommand("UpdateLocalWHMark"); command.SetParameterValue("@SOSysNo", soSysNo); command.SetParameterValue("@LocalWH", localWH); command.SetParameterValue("@TargetStatus", targetStatus); command.ExecuteNonQuery(); }
public static int ChangeGroupBuySettlement(int groupBuyingSysNo, string isSettlement, string companyCode) { DataCommand command = DataCommandManager.GetDataCommand("ChangeGroupBuySettlement"); command.SetParameterValue("@GroupBuyingSysNo", groupBuyingSysNo); command.SetParameterValue("@IsSettlement", isSettlement); command.SetParameterValue("@CompanyCode", companyCode); return(command.ExecuteNonQuery()); }
public CustomerContactInfo Insert(CustomerContactInfo entity) { DataCommand insertCommand = DataCommandManager.GetDataCommand("InsertCustomerContact"); insertCommand.SetParameterValue <CustomerContactInfo>(entity); insertCommand.ExecuteNonQuery(); entity.SysNo = (int)insertCommand.GetParameterValue("@SysNo"); return(entity); }
/// <summary> /// 审核补偿退款单 /// </summary> /// <param name="SysNo"></param> /// <param name="Status"></param> /// <param name="RefundUserSysNo"></param> /// <returns></returns> public bool AuditRefundAdjust(int SysNo, RefundAdjustStatus Status, int?RefundUserSysNo, DateTime?AuditTime) { DataCommand cmd = DataCommandManager.GetDataCommand("Customer_Audit_RequestAdjust"); cmd.SetParameterValue("@Status", (int)Status); cmd.SetParameterValue("@SysNo", SysNo); cmd.SetParameterValue("@RefundUserSysNo", RefundUserSysNo); cmd.SetParameterValue("@RefundTime", AuditTime); return(cmd.ExecuteNonQuery() > 0 ? true : false); }
public override object OnDelete(ProductDetail request) { ResultEntity <int> result = new ResultEntity <int> { Result = ResultStatic.ResultString.ERROR, ResultCode = ResultStatic.ResultCode.PARAMERROR }; try { List <string> split = new List <string>(); int affectRow = 0; dataCommand = DataCommandManager.GetDataCommand("DeleteProduct_Amber"); if (request.SplitArr != null) { split = new SplitString().bySplit(request.SplitArr, ','); foreach (string i in split) { affectRow = dataCommand.ExecuteNonQuery(new[] { new{ ProductID = i } }); } } else { affectRow = dataCommand.ExecuteNonQuery(new[] { new{ ProductID = request.ProductID } }); } result.Result = ResultStatic.ResultString.SUCCESS; result.ResultCode = ResultStatic.ResultCode.OK; result.ResultContent = affectRow; return(result); } catch (Exception ex) { result.Result = ResultStatic.ResultString.SERVERERROR; result.ResultCode = ResultStatic.ResultCode.SERVERERROR; result.Error = ex.Message; return(result); //throw; } }
public int InsertQuotaLog(Model.TS_Quota_Log quotaLogData) { var cmd = new DataCommand("InsertQuotaLog", new SqlCustomDbCommand()); cmd.SetParameterValue("@QuotaId", quotaLogData.QuotaId); cmd.SetParameterValue("@LogTime", quotaLogData.LogTime); cmd.SetParameterValue("@UserName", quotaLogData.UserName); cmd.SetParameterValue("@QuotaValue", quotaLogData.QuotaValue); cmd.SetParameterValue("@Reserved", quotaLogData.Reserved); return cmd.ExecuteNonQuery(); }
/// <summary> /// 咨询回复之批准拒绝 /// </summary> /// <param name="item"></param> public int RejectProductConsultRelease(ProductConsultReply item) { DataCommand dc = DataCommandManager.GetDataCommand("ProductConsult_UpdateFactoryRefuseStatus"); dc.SetParameterValue("@SysNo", item.SysNo.Value); dc.SetParameterValue("@CompanyCode", item.CompanyCode); dc.ExecuteNonQuery(); return(Convert.ToInt32(dc.GetParameterValue("@IsSuccess"))); }
public void InsertCategoryTemplate(CategoryTemplateInfo info) { DataCommand dc = DataCommandManager.GetDataCommand("InsertCategoryTemplate"); dc.SetParameterValue("@C3SysNo", info.TargetSysNo); dc.SetParameterValue("@LastEditUserSysNo", info.User.SysNo); dc.SetParameterValue("@TemplateType", info.TemplateType); dc.SetParameterValue("@Description", info.Templates); dc.ExecuteNonQuery(); }
public static void UpdateGiftIsGlobal(int promotionSysNo, bool isGlobal, string userName) { DataCommand cmd = DataCommandManager.GetDataCommand("SaleGift_UpdateGiftIsGlobal"); cmd.SetParameterValue("@PromotionSysNo", promotionSysNo); cmd.SetParameterValue("@IsGlobal", isGlobal ? "Y" : "N"); cmd.SetParameterValue("@EditUser", userName); cmd.ExecuteNonQuery(); }
public RefundInfo InsertMaster(RefundInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("InsertRefundMaster"); command.SetParameterValue <RefundInfo>(entity); command.ExecuteNonQuery(); return(entity); }
public static int UpdateStatus(SettingCustomerEntity entity) { DataCommand command = DataCommandManager.GetDataCommand("Promotion_SetSettingCustomerStatus"); command.SetParameterValue("EditUser", ConstValues.EditUser); command.SetParameterValue("Status", entity.Status); command.SetParameterValue("SysNo", entity.SysNo); command.SetParameterValue("CompanyCode", ConstValues.CompanyCode); return(command.ExecuteNonQuery()); }
public void CreateGiftRules(ProductItemInfo productItem, BatchCreateGiftRuleInfo ruleInfo) { DataCommand dataCommand = DataCommandManager.GetDataCommand("SaleGift_CreateGiftRules"); dataCommand.SetParameterValue("@PromotionSysNo", ruleInfo.PromotionSysNo); dataCommand.SetParameterValue("@ProductSysNo", productItem.ProductSysNo); dataCommand.SetParameterValue("@Count", productItem.HandselQty); dataCommand.SetParameterValue("@Priority", productItem.Priority); dataCommand.ExecuteNonQuery(); }
public void UpdateGiftIsGlobal(int promotionSysNo, string isGlobal, string companyCode, string user) { DataCommand dataCommand = DataCommandManager.GetDataCommand("BatchCreateSaleGift_UpdateGiftIsGlobal"); dataCommand.SetParameterValue("@PromotionSysNo", promotionSysNo); dataCommand.SetParameterValue("@IsGlobal", isGlobal); dataCommand.SetParameterValue("@CompanyCode", companyCode); dataCommand.SetParameterValue("@EditUser", user); dataCommand.ExecuteNonQuery(); }
/// <summary> /// 删除模板 /// </summary> /// <param name="entity"></param> /// <returns></returns> public ProductProfileTemplateInfo DeleteProductProfileTemplate(ProductProfileTemplateInfo entity) { DataCommand cmd = DataCommandManager.GetDataCommand("DeleteProductProfileTemplate"); cmd.SetParameterValue("@TemplateName", entity.TemplateName); cmd.SetParameterValue("@TemplateType", entity.TemplateType); cmd.SetParameterValue("@UserId", entity.UserId); cmd.ExecuteNonQuery(); return(entity); }
/// <summary> /// 更新承运商信息 /// </summary> /// <param name="order"></param> /// <returns></returns> public int UpdateOrderCarrier(OrderInfo order) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(OrderStatement.UpdateOrderCarrier, "Text")); command.AddInputParameter("@CarrierID", DbType.Int32, order.CarrierID); command.AddInputParameter("@PlanID", DbType.Int32, order.PlanID); command.AddInputParameter("@DeliveryStatus", DbType.String, order.DeliveryStatus);//是否安排物流计划 T是/F否 command.AddInputParameter("@OrderID", DbType.Int32, order.OrderID); return(command.ExecuteNonQuery()); }
/// <summary> /// 将该位置系统之前添加的数据标记为待删除 /// </summary> /// <param name="pagetype"></param> /// <param name="positionid"></param> /// <param name="pageID"></param> public static void UpdateInvalidData(int pagetype, int positionid, int pageID) { DataCommand command = DataCommandManager.GetDataCommand("UpdateInvalidData"); command.ReplaceParameterValue("@PageType", pagetype.ToString()); command.ReplaceParameterValue("@PageID", pageID.ToString()); command.ReplaceParameterValue("@PositionID", positionid.ToString()); command.ReplaceParameterValue("@CompanyCode", CompanyCode); command.ExecuteNonQuery(); }
/// <summary> /// 删除作废已标记数据 /// </summary> /// <param name="pagetype"></param> /// <param name="positionid"></param> /// <param name="pageID"></param> public static void DeleteOnlineListItem(int pagetype, int positionid, int pageID) { DataCommand command = DataCommandManager.GetDataCommand("DeleteOnlineListSystem"); command.ReplaceParameterValue("@PageType", pagetype.ToString()); command.ReplaceParameterValue("@PageID", pageID.ToString()); command.ReplaceParameterValue("@PositionID", positionid.ToString()); command.ReplaceParameterValue("@CompanyCode", CompanyCode); command.ExecuteNonQuery(); }
public int InsertUser(Model.User user) { var cmd = new DataCommand("InsertUser", new SqlCustomDbCommand()); cmd.SetParameterValue("@ID", user.Id); cmd.SetParameterValue("@Name", user.UserName); cmd.SetParameterValue("@PassWord", user.PassWord); cmd.SetParameterValue("@Status", user.Status); cmd.SetParameterValue("@GroupId", user.GroupId); return cmd.ExecuteNonQuery(); }
/// <summary> /// 添加商家订单出库日志 /// </summary> /// <param name="soSysNo">订单系统编号</param> /// <param name="inUserSysNo"></param> /// <param name="metShipViaCode"></param> /// <param name="metPackpageNumber"></param> public void InsertMerchantShippingLog(int soSysNo, int inUserSysNo, string metShipViaCode, string metPackpageNumber) { DataCommand command = DataCommandManager.GetDataCommand("SO_Insert_MerchantShippingLog"); command.SetParameterValue("@SOSysNo", soSysNo); command.SetParameterValue("@METShipViaCode", metShipViaCode); command.SetParameterValue("@METPackageNumber", metPackpageNumber); command.SetParameterValue("@InUser", inUserSysNo); command.ExecuteNonQuery(); }
public static void UpdateGiftItemCount(int promotionSysNo, SaleGiftGiftItemType giftComboType, int?itemGiftCount, string userName) { DataCommand cmd = DataCommandManager.GetDataCommand("SaleGift_UpdateGiftItemCount"); cmd.SetParameterValue("@PromotionSysNo", promotionSysNo); cmd.SetParameterValue("@GiftComboType", giftComboType == SaleGiftGiftItemType.AssignGift ? "A" : "O"); cmd.SetParameterValue("@ItemGiftCount", itemGiftCount); cmd.SetParameterValue("@InUser", userName); cmd.ExecuteNonQuery(); }
/// <summary> /// 审核 /// </summary> /// <param name="info"></param> public void ActiveCategoryRequest(CategoryRequestApprovalInfo info) { DataCommand dc = DataCommandManager.GetDataCommand("ActiveCategoryRequest"); dc.SetParameterValue("@SysNo", info.SysNo); dc.SetParameterValue("@Status", info.Status); dc.SetParameterValue("@AuditUserSysNo", ServiceContext.Current.UserSysNo); dc.SetParameterValue("@CategorySysNo", info.CategorySysNo); dc.ExecuteNonQuery(); }
public void UpdateRefundPayTypeAndReason(int sysNo, int refundPayType, int refundReason) { DataCommand command = DataCommandManager.GetDataCommand("UpdateRefundPayTypeAndReason"); command.SetParameterValue("@SysNo", sysNo); command.SetParameterValue("@RefundPayType", refundPayType); command.SetParameterValue("@RefundReason", refundReason); command.ExecuteNonQuery(); }
public void UpdateInventory(int wareshouseSysNo, int productSysNo, bool isRecv, string companyCode) { DataCommand cmd = DataCommandManager.GetDataCommand("UpdateInventory"); cmd.SetParameterValue("@WHSysNo", wareshouseSysNo); cmd.SetParameterValue("@ProductSysNo", productSysNo); cmd.SetParameterValue("@IsRecv", isRecv ? 1 : 0); cmd.SetParameterValue("@CompanyCode", companyCode); cmd.ExecuteNonQuery(); }
public VendorStoreInfo Update(VendorStoreInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("UpdateVendorStore"); command.SetParameterValue(entity); command.ExecuteNonQuery(); return(Load(entity.SysNo.Value)); }
public bool SaveAlloctionAndLog(string sql) { var cmd = new DataCommand("saveAlloctionAndLog", new SqlCustomDbCommand()); cmd.ReplaceParameterValue("#sql#", sql); int result = cmd.ExecuteNonQuery(); if (result > 0) return true; else return false; }
/// <summary> /// 创建品牌报备 /// </summary> public int InsertStoreBrandFiling(StoreBrandFilingInfo entity) { DataCommand cmd = DataCommandManager.GetDataCommand("InsertStoreBrandFiling"); cmd.SetParameterValue <StoreBrandFilingInfo>(entity); cmd.ExecuteNonQuery(); int sysNo = (int)cmd.GetParameterValue("@SysNo"); return(sysNo); }
/// <summary> /// 设置付款单凭证号 /// </summary> /// <param name="entity"></param> /// <returns></returns> public PayItemInfo SetReferenceID(int sysNo, string referenceID) { DataCommand command = DataCommandManager.GetDataCommand("UpdatePayItemReferenceID"); command.SetParameterValue("@SysNo", sysNo); command.SetParameterValue("@ReferenceID", referenceID); command.ExecuteNonQuery(); return(Load(sysNo)); }
public void LockProductCostInList(List <ProductCostIn> list) { foreach (var item in list) { DataCommand cmd = DataCommandManager.GetDataCommand("Inventory_LockProductCostInList"); cmd.SetParameterValue("@SysNo", item.SysNo); cmd.SetParameterValue("@LockQuantity", item.LockQuantity); cmd.ExecuteNonQuery(); } }
public static int WriteProcessLog(int sysNumber, string type, string memo) { DataCommand command = DataCommandManager.GetDataCommand("WriteProcessLog"); command.SetParameterValue("@Number", sysNumber); command.SetParameterValue("@Type", type); command.SetParameterValue("@Memo", memo); return(command.ExecuteNonQuery()); }
public bool AddCommPrice(Model.TB_Price_CommBill model) { var cmd = new DataCommand("addCommPrice", new SqlCustomDbCommand()); cmd.SetParameterValue("@EnergyCode", model.EnergyCode); cmd.SetParameterValue("@Price", model.Price); int result = cmd.ExecuteNonQuery(); if (result > 0) return true; else return false; }
public int SaveQuotaAlarm(Model.QuotaAlarmDataContact quotaAlarmData) { var cmd = new DataCommand("SaveQuotaAlarmData", new SqlCustomDbCommand()); cmd.SetParameterValue("@AlarmType", quotaAlarmData.AlarmType); cmd.SetParameterValue("@ObjectDesc", quotaAlarmData.ObjectDesc); cmd.SetParameterValue("@ObjectType", quotaAlarmData.ObjectType); cmd.SetParameterValue("@ObjectId", quotaAlarmData.ObjectId); cmd.SetParameterValue("@QuotaType", quotaAlarmData.QuotaType); cmd.SetParameterValue("@ItemCode", quotaAlarmData.ItemCode); cmd.SetParameterValue("@Percent", quotaAlarmData.Percent); return cmd.ExecuteNonQuery(); }
public int SetBussinessLog(BussinessLogModel bussinessLog) { // add something to database DataCommand command = new DataCommand("InsertSystemLog", new SqlCustomDbCommand()); command.SetParameterValue("@modelname", bussinessLog.ModelName); command.SetParameterValue("@logtime", bussinessLog.OperatorTime); command.SetParameterValue("@logcontent", string.IsNullOrEmpty(bussinessLog.OperatorContent) ? (bussinessLog.ModelName + "执行了操作。") : bussinessLog.OperatorContent); command.SetParameterValue("@optype", bussinessLog.ModelType); command.SetParameterValue("@username", bussinessLog.UserName); command.ExecuteNonQuery(); return 0; }
public int SaveImportEneryValue(ImportTemp import) { var cmd = new DataCommand("ImportData", new SqlCustomDbCommand()); cmd.SetParameterValue("@ObjectID", import.ObjectId); cmd.SetParameterValue("@IsArea", import.IsArea); cmd.SetParameterValue("@StartTime", import.StartTime); cmd.SetParameterValue("@EndTime", import.EndTime); cmd.SetParameterValue("@ItemCode", import.ItemCode); cmd.SetParameterValue("@ImportValue", import.ImportValue); cmd.SetParameterValue("@MonthType", import.MonthType); cmd.SetParameterValue("@ExcelId", import.ExcelId); return cmd.ExecuteNonQuery(); }
public bool AddParValue(Model.TB_PAR_VALUE_SET model) { var cmd = new DataCommand("addParValue", new SqlCustomDbCommand()); cmd.SetParameterValue("@CNAME", model.CNAME); cmd.SetParameterValue("@DATE", model.DATE); cmd.SetParameterValue("@PRICE", model.PRICE); cmd.SetParameterValue("@TYPEID", model.TYPEID); int result = cmd.ExecuteNonQuery(); if (result > 0) return true; else return false; }
public int InsertQuota(Model.TB_Quota quotaData, Model.TS_Quota_Log quotaLogData) { var cmd = new DataCommand("InsertQuota", new SqlCustomDbCommand()); cmd.SetParameterValue("@QuotaId", quotaData.QuotaId); cmd.SetParameterValue("@ObjectDesc", quotaData.ObjectDesc); cmd.SetParameterValue("@ObjectType", quotaData.ObjectType); cmd.SetParameterValue("@ObjectId", quotaData.ObjectId); cmd.SetParameterValue("@QuotaTime", quotaData.QuotaTime); cmd.SetParameterValue("@QuotaValue", quotaData.QuotaValue); cmd.SetParameterValue("@Reserved", quotaData.Reserved); cmd.SetParameterValue("@QuotaType", quotaData.QuotaType); cmd.SetParameterValue("@ItemCode", quotaData.ItemCode); cmd.SetParameterValue("@LogTime", quotaLogData.LogTime); cmd.SetParameterValue("@UserName", quotaLogData.UserName); return cmd.ExecuteNonQuery(); }
public ResultExcelImport SaveImportExcel(int monthType, int isArea, string excelPath) { try { var cmd = new DataCommand("SaveImportExcel", new SqlCustomDbCommand()); cmd.SetParameterValue("@monthType", monthType); cmd.SetParameterValue("@isArea", isArea); cmd.SetParameterValue("@excelPath", excelPath); cmd.ExecuteNonQuery(); return new ResultExcelImport() {Success = true,MsgContent = "文件批量上传成功,后台系统在努力处理,根据您上传的数据量,可能会花费几分钟或几个小时。"}; } catch (Exception e) { return new ResultExcelImport() {Success = false, MsgContent = e.Message}; } }
/// <summary> /// 更新设备属性 /// </summary> /// <param name="areaId"></param> /// <param name="itemCodeId"></param> /// <param name="areaType"></param> /// <param name="deviceIds"></param> /// <returns></returns> public int UpdateDeviceProp(int areaId, int itemCodeId, int areaType, List<int> deviceIds) { string sql = string.Empty; string columName = "areaid1"; if (areaType == 2) { columName = "areaid2"; } // sql = string.Format("update tb_device_property set {0}=null where device_itemcode in (select ID from dbo.GetAllChildren({1})) or device_itemcode={2} ", columName, itemCodeId, itemCodeId); foreach (var item in deviceIds) { sql += string.Format(" update tb_device_property set {0}={1} where id= {2} ", columName, areaId, item); } if (string.IsNullOrEmpty(sql)) { return 0; } var cmd = new DataCommand("updateDeviceProp", new SqlCustomDbCommand()); cmd.ReplaceParameterValue("#sql#", sql); int result = cmd.ExecuteNonQuery(); return result; }
/// <summary> /// 更新设备itemCode /// </summary> /// <param name="itemCodeId"></param> /// <param name="deviceIds"></param> /// <returns></returns> public int UpdateDeviceProp(int itemCodeId, List<int> deviceIds, string columnName) { string sql = string.Empty; foreach (var item in deviceIds) { sql += string.Format(" update tb_device_property set {0}={1} where id= {2} ", columnName, itemCodeId, item); } if (string.IsNullOrEmpty(sql)) { return 0; } var cmd = new DataCommand("updateDeviceProp", new SqlCustomDbCommand()); cmd.ReplaceParameterValue("#sql#", sql); return cmd.ExecuteNonQuery(); }
/// <summary> /// 阶梯模式保存 (新增、修改) /// </summary> /// <param name="sql"></param> /// <returns></returns> public bool SaveRatePrice(string sql) { var cmd = new DataCommand("addRatePrice", new SqlCustomDbCommand()); //cmd.SetParameterValue("@sql", sql); cmd.ReplaceParameterValue("#sql#", sql); int result = cmd.ExecuteNonQuery(); if (result > 0) return true; else return false; }
public bool InsertAlarmScale(int alarmType, int scale) { var cmd = new DataCommand("insertAlarmScale", new SqlCustomDbCommand()); cmd.SetParameterValue("@alarmType", alarmType); cmd.SetParameterValue("@scale", scale); int result = cmd.ExecuteNonQuery(); if (result > 0) return true; else return false; }
/// <summary> /// 更新告警类型等级 /// </summary> /// <param name="levelId">告警等级Id</param> /// <param name="Id">告警类型Id</param> /// <returns></returns> public int UpdateAlarmTypeLevelById(int levelId, int Id) { var cmd = new DataCommand("updateAlarmTypeLevelById", new SqlCustomDbCommand()); cmd.SetParameterValue("@alarmLevelId", levelId); cmd.SetParameterValue("@Id", Id); return cmd.ExecuteNonQuery(); }
public int UpdateAlarmEventByID(Model.QueryFile.QueryAlarmEvent alarmEvent) { var cmd = new DataCommand("updateAlarmEventByID", new SqlCustomDbCommand()); cmd.SetParameterValue("@TrigMode", alarmEvent.TrigMode); cmd.SetParameterValue("@RunMode", alarmEvent.RunMode); cmd.SetParameterValue("@RunCount", alarmEvent.RunCount); cmd.SetParameterValue("@RunTime", alarmEvent.RunTime); cmd.SetParameterValue("@Options", alarmEvent.Options); cmd.SetParameterValue("@Id", alarmEvent.ID); return cmd.ExecuteNonQuery(); }
public bool UpdateAlarmScaleByID(int id, int scale) { var cmd = new DataCommand("updateAlarmScaleByID", new SqlCustomDbCommand()); cmd.SetParameterValue("@id", id); cmd.SetParameterValue("@scale", scale); int result = cmd.ExecuteNonQuery(); if (result > 0) return true; else return false; }
/// <summary> /// 更新告警触发事件表 /// </summary> /// <param name="alarmEvent"></param> /// <returns></returns> public int UpdateAlarmEvent(Model.QueryFile.QueryAlarmEvent alarmEvent) { var aeEntity = this.GetAlarmEventById(alarmEvent.ID); if (aeEntity == null) {//insert var cmd = new DataCommand("insertAlarmEvent", new SqlCustomDbCommand()); cmd.SetParameterValue("@AlarmTypeId", alarmEvent.AlarmTypeId); cmd.SetParameterValue("@PlugIn", alarmEvent.PlugIn); cmd.SetParameterValue("@TrigMode", alarmEvent.TrigMode); cmd.SetParameterValue("@RunMode", alarmEvent.RunMode); cmd.SetParameterValue("@RunCount", alarmEvent.RunCount); cmd.SetParameterValue("@RunTime", alarmEvent.RunTime); cmd.SetParameterValue("@Options", alarmEvent.Options); cmd.SetParameterValue("@PROJECTID", alarmEvent.PROJECTID); cmd.SetParameterValue("@SYSTEMID", alarmEvent.SYSTEMID); return cmd.ExecuteNonQuery(); } else {//update aeEntity.AlarmTypeId = (aeEntity.AlarmTypeId != alarmEvent.AlarmTypeId) ? alarmEvent.AlarmTypeId : aeEntity.AlarmTypeId; aeEntity.PlugIn = string.IsNullOrEmpty(alarmEvent.PlugIn) ? aeEntity.PlugIn : alarmEvent.PlugIn; aeEntity.TrigMode = (aeEntity.TrigMode != alarmEvent.TrigMode) ? alarmEvent.TrigMode : aeEntity.TrigMode; aeEntity.RunMode = (aeEntity.RunMode != alarmEvent.RunMode) ? alarmEvent.RunMode : aeEntity.RunMode; aeEntity.RunCount = (aeEntity.RunCount != alarmEvent.RunCount) ? alarmEvent.RunCount : aeEntity.RunCount; aeEntity.RunTime = (aeEntity.RunTime != alarmEvent.RunTime) ? alarmEvent.RunTime : aeEntity.RunTime; aeEntity.Options = string.IsNullOrEmpty(alarmEvent.Options) ? aeEntity.Options : alarmEvent.Options; aeEntity.ProjectId = (aeEntity.ProjectId != alarmEvent.PROJECTID) ? alarmEvent.PROJECTID : aeEntity.ProjectId; aeEntity.SystemId = (aeEntity.SystemId != alarmEvent.SYSTEMID) ? alarmEvent.SYSTEMID : aeEntity.SystemId; var cmd = new DataCommand("updateAlarmEvent", new SqlCustomDbCommand()); cmd.SetParameterValue("@AlarmTypeId", aeEntity.AlarmTypeId); cmd.SetParameterValue("@PlugIn", aeEntity.PlugIn); cmd.SetParameterValue("@TrigMode", aeEntity.TrigMode); cmd.SetParameterValue("@RunMode", aeEntity.RunMode); cmd.SetParameterValue("@RunCount", aeEntity.RunCount); cmd.SetParameterValue("@RunTime", aeEntity.RunTime); cmd.SetParameterValue("@Options", aeEntity.Options); cmd.SetParameterValue("@PROJECTID", aeEntity.ProjectId); cmd.SetParameterValue("@SYSTEMID", aeEntity.SystemId); cmd.SetParameterValue("@Id", aeEntity.ID); return cmd.ExecuteNonQuery(); } }
public int UpdateQuota(Model.TB_Quota quotaData, Model.TS_Quota_Log quotaLogData) { var cmd = new DataCommand("UpdateQuota", new SqlCustomDbCommand()); cmd.SetParameterValue("@QuotaId", quotaData.QuotaId); cmd.SetParameterValue("@QuotaTime", quotaData.QuotaTime); cmd.SetParameterValue("@QuotaValue", quotaData.QuotaValue); cmd.SetParameterValue("@Reserved", quotaData.Reserved); cmd.SetParameterValue("@QuotaType", quotaData.QuotaType); cmd.SetParameterValue("@LogTime", quotaLogData.LogTime); cmd.SetParameterValue("@UserName", quotaLogData.UserName); return cmd.ExecuteNonQuery(); }
public int DeleteUser(int id) { var cmd = new DataCommand("DeleteUser", new SqlCustomDbCommand()); cmd.SetParameterValue("@Id", id); return cmd.ExecuteNonQuery(); }
public int DeleteUserGroup(int userGroupId) { var cmd = new DataCommand("DeleteUserGroup", new SqlCustomDbCommand()); cmd.SetParameterValue("@UserGroupId", userGroupId); return cmd.ExecuteNonQuery(); }
public int SaveUserGroupInfo(Model.UserGroup userGroup, string menuIds, string objectIds, string objectTypes) { var cmd = new DataCommand("SaveUserGroupInfo", new SqlCustomDbCommand()); cmd.SetParameterValue("@Id", userGroup.Id); cmd.SetParameterValue("@Name", userGroup.Name); cmd.SetParameterValue("@Description", userGroup.Description); cmd.SetParameterValue("@Groups", string.Empty); cmd.SetParameterValue("@MenuRightIds", menuIds); cmd.SetParameterValue("@ObjectRightIds", objectIds); cmd.SetParameterValue("@ObjectTypes", objectTypes); var result = cmd.ExecuteNonQuery(); return result; }