public List<AlarmDiagnoseModel> GetAlarmDiagnose(QueryAlarm query) { try { var cmd = new DataCommand("getAlarmDiagnose", new SqlCustomDbCommand()); IList<string> objectIds = new AlarmAccess().GetAlarmListAreaId(query.ObjectId, query.ObjType); StringBuilder sb = new StringBuilder(); foreach (string s in objectIds) { sb.Append(s); sb.Append(","); } sb.Remove(sb.Length - 1, 1); cmd.ReplaceParameterValue("#ObjectId#", sb.ToString()); cmd.SetParameterValue("@StartTime", query.StartTime); cmd.SetParameterValue("@EndTime", query.EndTime); return cmd.ExecuteEntityList<AlarmDiagnoseModel>(); } catch(Exception ee) { throw ee; //return null; } }
public List<CostQueryModel> GetCostQuery(QueryCost query) { try { var cmd = new DataCommand("getCostQuery", new SqlCustomDbCommand()); string table = ""; switch (query.Particle) { case Particle.Month: table = string.Format("TS_FEE_DAY_{0}", query.StartTime.Year); break; case Particle.Year: table = string.Format("TS_FEE_MONTH_{0}", query.StartTime.Year); break; default: table = string.Format("TS_FEE_DAY_{0}", query.StartTime.Year); break; } cmd.ReplaceParameterValue("#TableName#", table); cmd.SetParameterValue("@OBJECTID", query.ObjectId.ToString()); cmd.SetParameterValue("@ITEMCODE", query.ItemCode); cmd.SetParameterValue("@StartTime", query.StartTime); cmd.SetParameterValue("@EndTime", query.EndTime); return cmd.ExecuteEntityList<CostQueryModel>(); } catch (Exception ee) { throw ee; } }
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(); }
public int UpdateUser(Model.User user) { var cmd = new DataCommand("UpDateUser", 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(); }
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; }
/// <summary> /// 获取表的基础数据集 /// </summary> /// <param name="model"></param> /// <returns></returns> public static DataTable GetBaseData(BaseDataModel model) { var dtold = new DataTable(); var tcount = new List<string>(); var cmdName = string.Empty; tcount = GetTcountNames(model, tcount); switch (model.Unit) { case ChartUnit.unit_hour: cmdName = "getBaseDataByHour"; break; case ChartUnit.unit_day: cmdName = "getBaseDataByDate"; break; case ChartUnit.unit_month: cmdName = "getBaseDataByMonth"; break; default: cmdName = "getBaseDataByMonth"; break; } //var cmd = new DataCommand(cmdName, new SqlCustomDbCommand()); //cmd.SetParameterValue("@countid", model.ObjectId); //cmd.SetParameterValue("@itemcode", model.ItemCode); for (var i = 0; i < tcount.Count; i++) { var cmd = new DataCommand(cmdName, new SqlCustomDbCommand()); cmd.SetParameterValue("@countid", model.ObjectId); cmd.SetParameterValue("@itemcode", model.ItemCode); cmd.ReplaceParameterValue("#TableName#", tcount[i]); //cmd.SetParameterValue("#TableName#", tcount[i]); //object param = cmd.GetParameterValue("#TableName#"); //cmd.SetParameterValue("@tname", tcount[i]); DataTable dts; if (model.Unit == ChartUnit.unit_hour) { cmd.SetParameterValue("@cdate", model.Starttime.ToString("yyyy-MM-dd")); } try { dts = cmd.ExecuteDataSet().Tables[0]; dtold = i.Equals(0) ? dts.Clone() : dtold; dtold = UniteDataTable(dtold, dts.Copy()); } catch (Exception e) { //throw new Exception(e.Message); } } return MakerData(dtold, model); }
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 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; }
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 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; }
/// <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(); }
/// <summary> /// 获取告警触发事件 /// </summary> /// <param name="Id"></param> /// <returns></returns> public Model.TB_AlarmEvent GetAlarmEventById(int Id) { var cmd = new DataCommand("getAlarmEventById", new SqlCustomDbCommand()); cmd.SetParameterValue("@Id", Id); return cmd.ExecuteEntity<Model.TB_AlarmEvent>(); }
public List<TB_Alloction_Config> GetAlloctionConfig(Queryfeeapportion feeApport) { try { var cmd = new DataCommand("GetAlloctionConfig", new SqlCustomDbCommand()); cmd.SetParameterValue("@OBJECTID", feeApport.ObjectId); cmd.SetParameterValue("@ITEMCODE", feeApport.ItemCode); cmd.SetParameterValue("@YEAR", feeApport.StartTime.Year); cmd.SetParameterValue("@MONTH", feeApport.StartTime.Month); return cmd.ExecuteEntityList<TB_Alloction_Config>(); } catch (Exception ee) { throw ee; } }
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}; } }
public List<CostQueryModel> GetCostQuery(Queryfeeapportion query, DateTime dtBegin, DateTime dtEnd) { try { var cmd = new DataCommand("getCostQuery2", new SqlCustomDbCommand()); string table = "TS_FEE_DAY_" + query.StartTime.Year; cmd.ReplaceParameterValue("#TableName#", table); cmd.SetParameterValue("@OBJECTID", query.ObjectId.ToString()); cmd.SetParameterValue("@ITEMCODE", query.ItemCode); cmd.SetParameterValue("@StartTime", dtBegin); cmd.SetParameterValue("@EndTime", dtEnd); return cmd.ExecuteEntityList<CostQueryModel>(); } catch (Exception ee) { throw ee; } }
/// <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 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 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; }
public TB_AreaInfo GetAreaInfo(int areaId) { try { var cmd = new DataCommand("GetAreaInfo", new SqlCustomDbCommand()); cmd.SetParameterValue("@ID", areaId); return cmd.ExecuteEntity<TB_AreaInfo>(); } catch (Exception ee) { throw ee; } }
public int GetUserGroupID(string username) { try { var cmd = new DataCommand("GetUserGroupID", new SqlCustomDbCommand()); cmd.SetParameterValue("@cname", username); return int.Parse(cmd.ExecuteScalar().ToString()); } catch (Exception ee) { throw ee; } }
public List<StepSettingModel> GetStepSetting(string itemcode) { try { var cmd = new DataCommand("getStepSetting", new SqlCustomDbCommand()); cmd.SetParameterValue("@ITEMCODE", itemcode); return cmd.ExecuteEntityList<StepSettingModel>(); } catch (Exception ee) { throw ee; } }
public Model.TB_BECM_COUNTTYPE GetCountType(string energyId) { try { var cmd = new DataCommand("getCountType", new SqlCustomDbCommand()); cmd.SetParameterValue("@energyId", energyId); return cmd.ExecuteEntity<Model.TB_BECM_COUNTTYPE>(); } catch (Exception ex) { throw; } }
public string GetUserGroupName(int userGroupId) { try { var cmd = new DataCommand("GetUserGroupName", new SqlCustomDbCommand()); cmd.SetParameterValue("@Id", userGroupId); return cmd.ExecuteScalar().ToString(); } catch (Exception) { return string.Empty; } }
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 DataTable GetMenuTree(string username) // { // try // { // string SQL = string.Format(@"select A.ID MenuID,A.MenuName,A.LinkName,A.IconClass,A.ParentID from dbo.TB_MENU A //JOIN TB_USERGROUPMENURIGHT B ON A.ID=B.MENUID //JOIN TB_USER C ON B.USERGROUPID=C.GROUPS //WHERE C.CNAME='{0}' //order by A.ID", username); // return SqlHelper.Query(SQL).Tables[0]; // } // catch (Exception ex) // { // throw new Exception(ex.Message); // } // } public List<MenuModel> GetMenus(string username) { try { var cmd = new DataCommand("getMenus", new SqlCustomDbCommand()); cmd.SetParameterValue("@CNAME", username); return cmd.ExecuteEntityList<MenuModel>(); } catch (Exception ee) { throw ee; } }
public List<TB_AreaInfo> GetAreaList(List<int> areaId ) { try { string strArea = listToString(areaId); var cmd = new DataCommand("GetAreaList", new SqlCustomDbCommand()); cmd.SetParameterValue("@AREAID", strArea); return cmd.ExecuteEntityList<TB_AreaInfo>(); } catch (Exception ee) { throw ee; } }
public HistoryImport GetResultImportList(HistoryQuery import, int action) { var result = new HistoryImport { HistoryItem = new List<ResultImport>(), PageInfo = new PageInfo() }; var cmd = new DataCommand("SearchImportData", new SqlCustomDbCommand()); var whereStr = new StringBuilder(); if (import.DeviceId == null || import.DeviceId==0) { if (!string.IsNullOrEmpty(import.ObjectId.ToString())) { whereStr.Append(string.Format(" and import.ObjectID={0}", import.ObjectId)); } } else { whereStr.Append(string.Format(" and import.ObjectID={0}", import.DeviceId)); } if (!string.IsNullOrEmpty(import.Starttime.ToString())) { whereStr.Append(string.Format(" and import.Starttime>='{0}'", import.Starttime)); } if (!string.IsNullOrEmpty(import.Endtime.ToString())) { whereStr.Append(string.Format(" and import.Starttime<='{0}'", import.Endtime)); } if (!string.IsNullOrEmpty(import.ItemCode)) { whereStr.Append(string.Format(" and import.ItemCode='{0}'", import.ItemCode)); } if (!string.IsNullOrEmpty(import.DateUnit.ToString(CultureInfo.InvariantCulture))) { whereStr.Append(string.Format(" and import.MonthType={0}", import.DateUnit)); } cmd.SetParameterValue("@action", action); cmd.ReplaceParameterValue("#whereStr#", whereStr.ToString()); cmd.ReplaceParameterValue("#pagesize#",import.PaddingInfo.PageSize.ToString(CultureInfo.InvariantCulture)); cmd.ReplaceParameterValue("#pagenums#", ((import.PaddingInfo.Page - 1) * import.PaddingInfo.PageSize).ToString(CultureInfo.InvariantCulture)); result.HistoryItem = cmd.ExecuteEntityList<ResultImport>(); foreach (var item in result.HistoryItem) { item.ObjectName = GetObjectName(item.IsArea, item.ObjectId); } result.PageInfo.Total = (int)cmd.GetParameterValue("@Count"); return result; }
public decimal GetFeePrice(string itemcode) { try { var cmd = new DataCommand("GetFeePrice", new SqlCustomDbCommand()); cmd.SetParameterValue("@itemcode", itemcode); object result = cmd.ExecuteScalar(); if (result != null) { return Convert.ToDecimal(result); } throw new Exception("该分项未设置费率"); } catch (Exception ee) { throw ee; } }
/// <summary> /// 提交审核 /// </summary> /// <param name="info"></param> public void InsertBrandRequest(BrandRequestInfo info) { DataCommand cmd = DataCommandManager.GetDataCommand("InsertBrandRequest"); cmd.SetParameterValue("@ManufacturerSysno", info.Manufacturer.SysNo); cmd.SetParameterValue("@BrandName_Ch", info.BrandNameLocal.Content); cmd.SetParameterValue("@BrandName_En", info.BrandNameGlobal); cmd.SetParameterValue("@Reason", info.Reason); cmd.SetParameterValue("@Status", info.ReustStatus); cmd.SetParameterValue("@InUser", info.User.UserName); cmd.SetParameterValue("@EditUser", info.User.UserName); cmd.SetParameterValue("@CompanyCode", info.CompanyCode); cmd.SetParameterValue("@LanguageCode", info.LanguageCode); cmd.SetParameterValue("@ProductLine", info.ProductLine); cmd.SetParameterValue("@BrandCode", info.BrandCode); cmd.ExecuteNonQuery(); }
/// <summary> /// 根据能源类型获取平价信息 /// </summary> /// <param name="energyType"></param> /// <returns></returns> public Model.TB_Price_CommBill GetCommPriceByEnergyCode(string energyCode) { var cmd = new DataCommand("getCommPriceByEnergyCode", new SqlCustomDbCommand()); cmd.SetParameterValue("@EnergyCode", energyCode); return cmd.ExecuteEntity<Model.TB_Price_CommBill>(); }
/// <summary> /// 根据CategoryType 更新 /// </summary> /// <param name="type"></param> /// <param name="entity"></param> public void UpdateCategoryByType(CategoryType type, CategoryInfo entity) { DataCommand cmd = null; switch (type) { case CategoryType.CategoryType1: cmd = DataCommandManager.GetDataCommand("UpdateCategory1"); cmd.SetParameterValue("@SysNo", entity.SysNo); cmd.SetParameterValue("@C1Name", entity.CategoryName.Content); cmd.SetParameterValue("@Status", entity.Status); break; case CategoryType.CategoryType2: cmd = DataCommandManager.GetDataCommand("UpdateCategory2"); cmd.SetParameterValue("@SysNo", entity.SysNo); cmd.SetParameterValue("@C2Name", entity.CategoryName.Content); cmd.SetParameterValue("@C1SysNo", entity.ParentSysNumber); cmd.SetParameterValue("@Status", entity.Status); break; case CategoryType.CategoryType3: cmd = DataCommandManager.GetDataCommand("UpdateCategory3"); cmd.SetParameterValue("@SysNo", entity.SysNo); cmd.SetParameterValue("@C3Name", entity.CategoryName.Content); cmd.SetParameterValue("@C2SysNo", entity.ParentSysNumber); cmd.SetParameterValue("@Status", entity.Status); cmd.SetParameterValue("@C3Code", entity.C3Code); break; default: break; } cmd.ExecuteNonQuery(); }
public void Insert(CommissionToCashInfo commissionToCashInfo) { DataCommand cmd = DataCommandManager.GetDataCommand("InsertCommissionToCashInfo"); cmd.SetParameterValue("@UserSysNo", commissionToCashInfo.CPSUserInfo.SysNo); cmd.SetParameterValue("@Status", commissionToCashInfo.Status); cmd.SetParameterValue("@ToCashAmt", commissionToCashInfo.ToCashAmt); cmd.SetParameterValue("@AfterTaxAmt", commissionToCashInfo.AfterTaxAmt); cmd.SetParameterValue("@BankCode", commissionToCashInfo.BankCode); cmd.SetParameterValue("@BankName", commissionToCashInfo.BankName); cmd.SetParameterValue("@BranchBank", commissionToCashInfo.BranchBank); cmd.SetParameterValue("@BankCardNumber", commissionToCashInfo.BankCardNumber); cmd.SetParameterValue("@ReceivableName", commissionToCashInfo.ReceivableName); cmd.SetParameterValue("@IsHasInvoice", commissionToCashInfo.CanProvideInvoice); cmd.SetParameterValue("@InUser", commissionToCashInfo.CPSUserInfo.SysNo); cmd.ExecuteNonQuery(); }
public int UpdateConsignSettlementRulesInfo(ConsignSettlementRulesInfo entity, BizEntity.PO.ConsignSettleRuleActionType actionType) { DataCommand command = DataCommandManager.GetDataCommand("UpdateConsignSettleRule"); if (actionType == BizEntity.PO.ConsignSettleRuleActionType.Audit) { command.SetParameterValue("@ApprovedDate", DateTime.Now); command.SetParameterValue("@ApprovedUser", entity.EditUser); } else { command.SetParameterValue("@ApprovedDate", DBNull.Value); command.SetParameterValue("@ApprovedUser", DBNull.Value); } command.SetParameterValue("@BeginDate", entity.BeginDate); command.SetParameterValue("@CurrencyCode", entity.CurrencyCode); command.SetParameterValue("@EditDate", DateTime.Now); command.SetParameterValue("@EditUser", entity.EditUser); command.SetParameterValue("@EndDate", entity.EndDate); command.SetParameterValue("@LanguageCode", "zh-CN"); command.SetParameterValue("@NewSettlePrice", entity.NewSettlePrice); command.SetParameterValue("@OldSetttlePrice", entity.OldSettlePrice); command.SetParameterValue("@ProductSysNo", entity.ProductSysNo); command.SetParameterValue("@SettleedQuantity", DBNull.Value); command.SetParameterValue("@SettleRuleName", entity.SettleRulesName); command.SetParameterValue("@SettleRuleQuantity", entity.SettleRulesQuantity); command.SetParameterValue("@SettleRulesCode", entity.SettleRulesCode); command.SetParameterValue("@Status", (char)entity.Status); if (actionType == BizEntity.PO.ConsignSettleRuleActionType.Stop) { command.SetParameterValue("@StopDate", DateTime.Now); command.SetParameterValue("@StopUser", entity.EditUser); } else { command.SetParameterValue("@StopDate", DBNull.Value); command.SetParameterValue("@StopUser", DBNull.Value); } command.SetParameterValue("@VendorSysNo", entity.VendorSysNo); command.SetParameterValue("@SysNo", entity.RuleSysNo); return(command.ExecuteNonQuery()); }
/// <summary> /// 创建损益单 /// </summary> /// <param name="entity"></param> /// <returns></returns> public virtual AdjustRequestInfo CreateAdjustRequest(AdjustRequestInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("Inventory_CreateAdjustRequest"); command.SetParameterValue("@RequestSysNo", entity.SysNo.Value); command.SetParameterValue("@RequestID", entity.RequestID); command.SetParameterValue("@StockSysNo", entity.Stock.SysNo); command.SetParameterValue("@CreateDate", entity.CreateDate); command.SetParameterValue("@CreateUserSysNo", entity.CreateUser.SysNo); command.SetParameterValue("@AuditDate", entity.AuditDate); command.SetParameterValue("@AuditUserSysNo", entity.AuditUser.SysNo); command.SetParameterValue("@OutStockDate", entity.OutStockDate); command.SetParameterValue("@OutStockUserSysNo", entity.OutStockUser.SysNo); command.SetParameterValue("@RequestStatus", (int?)entity.RequestStatus); command.SetParameterValue("@AdjustProperty", (int?)entity.AdjustProperty); command.SetParameterValue("@ConsignFlag", (int?)entity.ConsignFlag); command.SetParameterValue("@Note", entity.Note); command.SetParameterValue("@CompanyCode", "8601");//[Mark][Alan.X.Luo 硬编码] command.SetParameterValue("@ProductLineSysno", entity.ProductLineSysno); return(command.ExecuteEntity <AdjustRequestInfo>()); }
public static QueryResult <RMARequestInfo> QueryRMARequest(RMAQueryInfo queryInfo) { if (queryInfo == null) { return(null); } DataCommand dataCommand = DataCommandManager.GetDataCommand("QueryRequests"); dataCommand.SetParameterValue("@CustomerSysNo", queryInfo.CustomerSysNo); dataCommand.SetParameterValue("@SOSysNo", queryInfo.SOSysNo); dataCommand.SetParameterValue("@RequestID", queryInfo.RequestID); dataCommand.SetParameterValue("@SysNo", queryInfo.SysNo); if (!String.IsNullOrEmpty(queryInfo.ProductName)) { queryInfo.ProductName = string.Format("%{0}%", queryInfo.ProductName.Trim()); } dataCommand.SetParameterValue("@PageSize", queryInfo.PagingInfo.PageSize); dataCommand.SetParameterValue("@PageIndex", queryInfo.PagingInfo.PageIndex); DataSet dsResult = dataCommand.ExecuteDataSet(); if (dsResult != null && dsResult.Tables.Count > 1) { DataTable requestTable = dsResult.Tables[0]; DataTable registerTable = dsResult.Tables[1]; int totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); List <RMARequestInfo> requestList = null; List <RMARegisterInfo> registerList = null; if (registerTable.Rows != null && registerTable.Rows.Count > 0) { registerList = DataMapper.GetEntityList <RMARegisterInfo, List <RMARegisterInfo> >(registerTable.Rows); } else { registerList = new List <RMARegisterInfo>(); } if (requestTable.Rows != null && requestTable.Rows.Count > 0) { requestList = DataMapper.GetEntityList <RMARequestInfo, List <RMARequestInfo> >(requestTable.Rows); requestList.ForEach(request => { request.Registers = registerList.FindAll(register => register.RequestSysNo == request.SysNo); //单件拆分到最细粒度 //if (request.Registers != null && request.Registers.Count > 0) //{ // IEnumerable<IGrouping<int?, RMARegisterInfo>> group = request.Registers.GroupBy(item => item.ProductSysNo); // List<RMARegisterInfo> list = new List<RMARegisterInfo>(); // foreach (var item in group) // { // RMARegisterInfo info = item.First(); // if (info != null) // { // info.Quantity = item.Count(); // list.Add(info); // } // } // request.Registers = list; //} }); } else { requestList = new List <RMARequestInfo>(); } int pageIndex = queryInfo.PagingInfo.PageIndex; if ((pageIndex * queryInfo.PagingInfo.PageSize) > totalCount) { if (totalCount != 0 && (totalCount % queryInfo.PagingInfo.PageSize) == 0) { pageIndex = totalCount / queryInfo.PagingInfo.PageSize; } else { pageIndex = totalCount / queryInfo.PagingInfo.PageSize + 1; } } QueryResult <RMARequestInfo> result = new QueryResult <RMARequestInfo>(); result.ResultList = requestList; result.PageInfo = new PageInfo(); result.PageInfo.TotalCount = totalCount; result.PageInfo.PageIndex = pageIndex; result.PageInfo.PageSize = queryInfo.PagingInfo.PageSize; result.PageInfo.SortBy = queryInfo.PagingInfo.SortBy; return(result); } return(new QueryResult <RMARequestInfo>() { ResultList = new List <RMARequestInfo>(), PageInfo = new PageInfo() }); }
/// <summary> /// 保存基本指标信息 /// </summary> /// <param name="categoryBasicInfo"></param> /// <returns></returns> public CategoryBasic UpdateCategoryBasic(CategoryBasic categoryBasicInfo) { DataCommand cmd = DataCommandManager.GetDataCommand("UpdateCategoryBasic"); cmd.SetParameterValue("@SysNo", categoryBasicInfo.CategorySysNo); cmd.SetParameterValue("@IsValuableProduct", categoryBasicInfo.IsValuableProduct); cmd.SetParameterValue("@DMSRate", 0); cmd.SetParameterValue("@IsMemberArea", 0); categoryBasicInfo.VirtualRate = categoryBasicInfo.VirtualRate / 100; cmd.SetParameterValue("@VirtualRate", categoryBasicInfo.VirtualRate); cmd.SetParameterValue("@VirtualCount", categoryBasicInfo.VirtualCount); cmd.SetParameterValue("@CheapenRisk", categoryBasicInfo.CheapenRiskInfo); cmd.SetParameterValue("@OOSQty", categoryBasicInfo.OOSQty); categoryBasicInfo.OOSRate = categoryBasicInfo.OOSRate / 100; cmd.SetParameterValue("@OOSRate", categoryBasicInfo.OOSRate); cmd.SetParameterValue("@PayPeriodType", categoryBasicInfo.PayPeriodTypeInfo); cmd.SetParameterValue("@SafetyInventoryDay", categoryBasicInfo.SafetyInventoryDay); cmd.SetParameterValue("@SafetyInventoryQty", categoryBasicInfo.SafetyInventoryQty); cmd.SetParameterValue("@IsRequired", categoryBasicInfo.IsRequired); cmd.SetParameterValue("@LargeFlag", categoryBasicInfo.IsLargeInfo); cmd.SetParameterValue("@Quota", categoryBasicInfo.Quota); cmd.SetParameterValue("@MinCommission", categoryBasicInfo.MinCommission); cmd.ExecuteNonQuery(); return(categoryBasicInfo); }
/// <summary> /// 更新类别2的基本指标信息 /// </summary> /// <param name="categoryBasicInfo"></param> /// <returns></returns> public void UpdateCategory2Basic(CategoryBasic categoryBasicInfo) { DataCommand cmd = DataCommandManager.GetDataCommand("UpdateCategoryKpi2"); cmd.SetParameterValue("@SysNo", categoryBasicInfo.PropertySysNO); cmd.SetParameterValue("@AvgDailySalesCycle", categoryBasicInfo.AvgDailySalesCycle); cmd.SetParameterValue("@IsValuableProduct", categoryBasicInfo.IsValuableProduct); cmd.SetParameterValue("@CategorySysNo", categoryBasicInfo.Category2SysNo); cmd.SetParameterValue("@InStockDays", categoryBasicInfo.InStockDays); categoryBasicInfo.VirtualRate = categoryBasicInfo.VirtualRate / 100; cmd.SetParameterValue("@VirtualRate", categoryBasicInfo.VirtualRate); cmd.SetParameterValue("@VirtualCount", categoryBasicInfo.VirtualCount); cmd.SetParameterValue("@CheapenRisk", categoryBasicInfo.CheapenRiskInfo); cmd.SetParameterValue("@OOSQty", categoryBasicInfo.OOSQty); categoryBasicInfo.OOSRate = categoryBasicInfo.OOSRate / 100; cmd.SetParameterValue("@OOSRate", categoryBasicInfo.OOSRate); cmd.SetParameterValue("@LogUserName", "IPPSystemAdmin"); cmd.SetParameterValue("@Quota", categoryBasicInfo.Quota); cmd.SetParameterValue("@MinCommission", categoryBasicInfo.MinCommission); cmd.ExecuteNonQuery(); }
/// <summary> /// 创建厂商信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public virtual ManufacturerInfo CreateManufacturer(ManufacturerInfo entity) { DataCommand cmd = DataCommandManager.GetDataCommand("CreateManufacturer"); cmd.SetParameterValue("@ManufacturerName", entity.ManufacturerNameLocal != null ? entity.ManufacturerNameLocal.Content : null); cmd.SetParameterValue("@BriefName", entity.ManufacturerNameGlobal); cmd.SetParameterValue("@Note", entity.ManufacturerDescription != null ? entity.ManufacturerDescription.Content : null); cmd.SetParameterValue("@Status", entity.Status); cmd.SetParameterValue("@ManufacturerWebSite", entity.SupportInfo.ManufacturerUrl); cmd.SetParameterValue("@SupportEmail", entity.SupportInfo.ServiceEmail); cmd.SetParameterValue("@SupportURL", entity.SupportInfo.ServiceUrl); cmd.SetParameterValue("@Type", 0); cmd.SetParameterValue("@CustomerServicePhone", entity.SupportInfo.ServicePhone); cmd.SetParameterValue("@CompanyCode", entity.CompanyCode); cmd.SetParameterValue("@LanguageCode", entity.LanguageCode); cmd.ExecuteNonQuery(); if (entity.SysNo == 0 || entity.SysNo == null) { entity.SysNo = (int)cmd.GetParameterValue("@SysNo"); } return(entity); }
/// <summary> /// 修改厂商信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public virtual ManufacturerInfo UpdateManufacturer(ManufacturerInfo entity) { DataCommand cmd = DataCommandManager.GetDataCommand("UpdateManufacturer"); cmd.SetParameterValue("@SysNo", entity.SysNo); cmd.SetParameterValue("@ManufacturerID", entity.ManufacturerID); cmd.SetParameterValue("@ManufacturerName", entity.ManufacturerNameLocal.Content); cmd.SetParameterValue("@BriefName", entity.ManufacturerNameGlobal); cmd.SetParameterValue("@Note", entity.ManufacturerDescription != null ? entity.ManufacturerDescription.Content : null); cmd.SetParameterValue("@Status", entity.Status); cmd.SetParameterValue("@ManufacturerWebSite", entity.SupportInfo.ManufacturerUrl); cmd.SetParameterValue("@SupportEmail", entity.SupportInfo.ServiceEmail); cmd.SetParameterValue("@SupportURL", entity.SupportInfo.ServiceUrl); cmd.SetParameterValue("@Type", entity.BrandStoreType); cmd.SetParameterValue("@CustomerServicePhone", entity.SupportInfo.ServicePhone); cmd.SetParameterValue("@IsLogo", entity.IsLogo); cmd.SetParameterValue("@IsShowZone", entity.IsShowZone); cmd.SetParameterValue("@AdImage", entity.BrandImage); cmd.SetParameterValue("@NeweggUrl", entity.ShowUrl); cmd.ExecuteNonQuery(); return(entity); }
private void InsertProductCommonInfoStatus(ProductCommonInfo productCommonInfo) { DataCommand cmd = DataCommandManager.GetDataCommand("InsertProductCommonInfoStatus"); cmd.SetParameterValue("@CommonSKUNumber", productCommonInfo.ProductBasicInfo.CommonSkuNumber); cmd.SetParameterValue("@IsChangeStyleWithTemplate", "Y"); cmd.SetParameterValue("@IsExtendWarrantyDisuse", "N"); cmd.SetParameterValue("@IsBasicInformationCorrect", "Y"); cmd.SetParameterValue("@IsAccessoriesShow", productCommonInfo.ProductBasicInfo.IsAccessoryShow); cmd.SetParameterValue("@IsAccessoriesCorrect", "Y"); cmd.SetParameterValue("@IsVirtualPic", productCommonInfo.ProductBasicInfo.IsVirtualPic); cmd.SetParameterValue("@IsPictureCorrect", "Y"); cmd.SetParameterValue("@IsWarrantyCorrect", "Y"); cmd.SetParameterValue("@IsWarrantyShow", productCommonInfo.ProductWarrantyInfo.WarrantyShow); cmd.SetParameterValue("@IsWeightCorrect", "Y"); cmd.ExecuteNonQuery(); }
private void InsertProductCommonInfo(int productGroupSysNo, ProductInfo productCommonInfo) { DataCommand cmd = DataCommandManager.GetDataCommand("InsertProductCommonInfo"); cmd.SetParameterValue("@CommonSKUNumber", productCommonInfo.ProductBasicInfo.CommonSkuNumber); cmd.SetParameterValue("@ProductGroupSysno", productGroupSysNo); cmd.SetParameterValue("@UPCCode", productCommonInfo.ProductBasicInfo.UPCCode); cmd.SetParameterValue("@BMCode", productCommonInfo.ProductBasicInfo.BMCode); cmd.SetParameterValue("@ProductName", productCommonInfo.ProductBasicInfo.ProductTitle.Content); cmd.SetParameterValue("@BriefName", productCommonInfo.ProductBasicInfo.ProductBriefName); cmd.SetParameterValue("@Keywords", productCommonInfo.ProductBasicInfo.Keywords.Content); cmd.SetParameterValue("@PMUserSysNo", productCommonInfo.ProductBasicInfo.ProductManager.SysNo); cmd.SetParameterValue("@ProductModel", productCommonInfo.ProductBasicInfo.ProductModel.Content); cmd.SetParameterValue("@ProductType", productCommonInfo.ProductBasicInfo.ProductType); cmd.SetParameterValue("@IsTakePictures", productCommonInfo.ProductBasicInfo.IsTakePicture); cmd.SetParameterValue("@PackageList", productCommonInfo.ProductBasicInfo.PackageList.Content); cmd.SetParameterValue("@ProductLink", productCommonInfo.ProductBasicInfo.ProductLink); cmd.SetParameterValue("@Attention", productCommonInfo.ProductBasicInfo.Attention.Content); cmd.SetParameterValue("@Note", productCommonInfo.ProductBasicInfo.Note); cmd.SetParameterValue("@CompanyBelongs", "N");//Newegg产品 cmd.SetParameterValue("@OnlyForRank", 0); cmd.SetParameterValue("@PicNumber", 0); cmd.SetParameterValue("@HostWarrantyDay", productCommonInfo.ProductWarrantyInfo.HostWarrantyDay); cmd.SetParameterValue("@PartWarrantyDay", productCommonInfo.ProductWarrantyInfo.PartWarrantyDay); cmd.SetParameterValue("@Warranty", productCommonInfo.ProductWarrantyInfo.Warranty.Content); cmd.SetParameterValue("@ServicePhone", productCommonInfo.ProductWarrantyInfo.ServicePhone); cmd.SetParameterValue("@ServiceInfo", productCommonInfo.ProductWarrantyInfo.ServiceInfo); cmd.SetParameterValue("@IsOfferInvoice", productCommonInfo.ProductWarrantyInfo.OfferVATInvoice); cmd.SetParameterValue("@Weight", productCommonInfo.ProductBasicInfo.ProductDimensionInfo.Weight); cmd.SetParameterValue("@IsLarge", productCommonInfo.ProductBasicInfo.ProductDimensionInfo.LargeFlag); cmd.SetParameterValue("@Length", productCommonInfo.ProductBasicInfo.ProductDimensionInfo.Length); cmd.SetParameterValue("@Width", productCommonInfo.ProductBasicInfo.ProductDimensionInfo.Width); cmd.SetParameterValue("@Height", productCommonInfo.ProductBasicInfo.ProductDimensionInfo.Height); cmd.SetParameterValue("@MinPackNumber", productCommonInfo.ProductPOInfo.MinPackNumber); cmd.SetParameterValue("@InUser", productCommonInfo.OperateUser.UserDisplayName); cmd.SetParameterValue("@CompanyCode", productCommonInfo.CompanyCode); cmd.SetParameterValue("@StoreCompanyCode", productCommonInfo.CompanyCode); cmd.SetParameterValue("@LanguageCode", productCommonInfo.LanguageCode); cmd.SetParameterValue("@ProductDesc", productCommonInfo.ProductBasicInfo.ShortDescription.Content); cmd.ExecuteNonQuery(); productCommonInfo.ProductCommonInfoSysNo = (int)cmd.GetParameterValue("@SysNo"); }
/// <summary> /// 保存毛利率指标信息 /// </summary> /// <param name="categoryBasicInfo"></param> /// <returns></returns> public CategoryMinMargin UpdateCategoryMinMargin(CategoryMinMargin categoryBasicInfo) { DataCommand cmd = DataCommandManager.GetDataCommand("UpdateCategoryMinMargin"); cmd.SetParameterValue("SysNo", categoryBasicInfo.CategorySysNo); cmd.SetParameterValue("@CompanyCode", "8601"); if (categoryBasicInfo.Margin.ContainsKey(MinMarginDays.Thirty)) { cmd.SetParameterValue("@M1", categoryBasicInfo.Margin[MinMarginDays.Thirty].MinMargin / 100); cmd.SetParameterValue("@M1H", categoryBasicInfo.Margin[MinMarginDays.Thirty].MaxMargin / 100); } else { cmd.SetParameterValue("@M1", 0); cmd.SetParameterValue("@M1H", 0); } if (categoryBasicInfo.Margin.ContainsKey(MinMarginDays.Sixty)) { cmd.SetParameterValue("@M2", categoryBasicInfo.Margin[MinMarginDays.Sixty].MinMargin / 100); cmd.SetParameterValue("@M2H", categoryBasicInfo.Margin[MinMarginDays.Sixty].MaxMargin / 100); } else { cmd.SetParameterValue("@M2", 0); cmd.SetParameterValue("@M2H", 0); } if (categoryBasicInfo.Margin.ContainsKey(MinMarginDays.Ninety)) { cmd.SetParameterValue("@M3", categoryBasicInfo.Margin[MinMarginDays.Ninety].MinMargin / 100); cmd.SetParameterValue("@M3H", categoryBasicInfo.Margin[MinMarginDays.Ninety].MaxMargin / 100); } else { cmd.SetParameterValue("@M3", 0); cmd.SetParameterValue("@M3H", 0); } if (categoryBasicInfo.Margin.ContainsKey(MinMarginDays.OneHundredAndTwenty)) { cmd.SetParameterValue("@M4", categoryBasicInfo.Margin[MinMarginDays.OneHundredAndTwenty].MinMargin / 100); cmd.SetParameterValue("@M4H", categoryBasicInfo.Margin[MinMarginDays.OneHundredAndTwenty].MaxMargin / 100); } else { cmd.SetParameterValue("@M4", 0); cmd.SetParameterValue("@M4H", 0); } if (categoryBasicInfo.Margin.ContainsKey(MinMarginDays.OneHundredAndEighty)) { cmd.SetParameterValue("@M5", categoryBasicInfo.Margin[MinMarginDays.OneHundredAndEighty].MinMargin / 100); cmd.SetParameterValue("@M5H", categoryBasicInfo.Margin[MinMarginDays.OneHundredAndEighty].MaxMargin / 100); } else { cmd.SetParameterValue("@M5", 0); cmd.SetParameterValue("@M5H", 0); } if (categoryBasicInfo.Margin.ContainsKey(MinMarginDays.Other)) { cmd.SetParameterValue("@M6", categoryBasicInfo.Margin[MinMarginDays.Other].MinMargin / 100); cmd.SetParameterValue("@M6H", categoryBasicInfo.Margin[MinMarginDays.Other].MaxMargin / 100); } else { cmd.SetParameterValue("@6", 0); cmd.SetParameterValue("@M6H", 0); } cmd.ExecuteNonQuery(); return(categoryBasicInfo); }
/// <summary> /// 更新 订单更近日志 /// </summary> /// <param name="entity"></param> /// <returns></returns> public void UpdateSOInternalMemoInfo(SOInternalMemoInfo info) { DataCommand command = DataCommandManager.GetDataCommand("UpdateSO_InternalMemo"); command.SetParameterValue("@SysNo", info.SysNo); command.SetParameterValue("@SOSysNo", info.SOSysNo); command.SetParameterValue("@Content", info.Content); command.SetParameterValue("@UpdateUserSysNo", info.OperatorSysNo);//处理人 command.SetParameterValue("@Status", info.Status); command.SetParameterValue("@UpdateTime", DateTime.Now); command.SetParameterValue("@RemindTime", info.RemindTime); if (info.Status == SOInternalMemoStatus.Complete) { command.SetParameterValue("@RemindTime", DBNull.Value); command.SetParameterValue("@UpdateTime", DBNull.Value); } command.SetParameterValue("@Note", info.Note); command.SetParameterValue("@CallType", info.CallType); command.SetParameterValue("@ResponsibleDepCode", info.DepartmentCode); command.SetParameterValue("@Importance", info.Importance); command.ExecuteNonQuery(); }
/// <summary> /// 更新APInvoice Master信息 /// </summary> /// <param name="entity"></param> public virtual void UpdateAPInvoiceMaster(APInvoiceInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("UpdateAPInvoiceMaster"); command.SetParameterValue("@WareHouseNo", entity.StockSysNo); command.SetParameterValue("@VendorSysNo", entity.VendorSysNo); command.SetParameterValue("@VendorName", entity.VendorName); command.SetParameterValue("@VendorTaxRate", entity.VendorTaxRate); command.SetParameterValue("@Memo", entity.Memo); if (entity.DiffMemo == null) { entity.DiffMemo = ""; } command.SetParameterValue("@DiffMemo", entity.DiffMemo); command.SetParameterValue("@PoNetAmt", entity.PoNetAmt); command.SetParameterValue("@PoNetTaxAmt", entity.PoNetTaxAmt); command.SetParameterValue("@InvoiceAmt", entity.InvoiceAmt); command.SetParameterValue("@InvoiceTaxAmt", entity.InvoiceTaxAmt); command.SetParameterValue("@DiffTaxAmt", entity.DiffTaxAmt); command.SetParameterValue("@DiffTaxTreatmentType", entity.DiffTaxTreatmentType); command.SetParameterValue("@Status", entity.Status); command.SetParameterValue("@EditDate", DateTime.Now); command.SetParameterValueAsCurrentUserAcct("@EditUser"); command.SetParameterValue("@DocNo", entity.SysNo); command.ExecuteNonQuery(); }
/// <summary> /// 记录日志 /// </summary> /// <param name="log"></param> public void WriteLog(BizEntity.ExternalSYS.VendorPortalLog log) { DataCommand command = DataCommandManager.GetDataCommand("WriteVendorPortalLog"); command.SetParameterValue("@RegionName", log.RegionName); command.SetParameterValue("@CategoryName", log.CategoryName); command.SetParameterValue("@CategoryDescription", log.CategoryDescription); command.SetParameterValue("@InUser", log.LogUserName); command.SetParameterValue("@Content", log.Content); command.SetParameterValue("@LogUserName", log.LogUserName); command.SetParameterValue("@ServerIP", log.ServerIP); command.SetParameterValue("@ServerName", log.ServerName); command.SetParameterValue("@ExtendedProperties", log.ExtendedProperties); command.SetParameterValue("@ReferenceKey", log.ReferenceKey); command.SetParameterValue("@LogType", log.LogType); command.ExecuteNonQuery(); }
public static QueryResultList <ArticleData> GetItems(QueryRequest <ArticleQueryData> query) { var result = new QueryResultList <ArticleData>(); DataCommand cmd = DataCommandManager.GetDataCommand("Article_GetItems"); cmd.SetParameterValue("@ArtStatus", query.Body.ArtStatus); cmd.SetParameterValue("@Publisher", query.Body.Publisher + "%"); cmd.SetParameterValue("@Publisher", query.Body.EndDate); cmd.SetParameterValue("@Title", query.Body.Title + "%"); cmd.SetParameterValue("@ArtType", query.Body.ArtType); cmd.SetParameterValue("@StartDate", query.Body.StartDate); cmd.SetParameterValue("@EndDate", query.Body.EndDate); cmd.SetParameterValue("@PageCurrent", query.PageInfo.PageIndex); cmd.SetParameterValue("@PageSize", query.PageInfo.PageSize); cmd.SetParameterValue("@SortType", query.PageInfo.SortType); cmd.SetParameterValue("@SortField", query.PageInfo.SortField); result.Body = cmd.ExecuteEntityList <ArticleData>(); result.TotalCount = (int)cmd.GetParameterValue("@TotalCount"); return(result); }
/// <summary> /// 添加订单跟进日志 /// </summary> /// <param name="info"></param> /// <param name="companyCode"></param> public void AddSOInternalMemoInfo(SOInternalMemoInfo info, string companyCode) { DataCommand command = DataCommandManager.GetDataCommand("CreateSO_InternalMemo"); command.SetParameterValue("@SOSysNo", info.SOSysNo); command.SetParameterValue("@CreateUserSysNo", ServiceContext.Current.UserSysNo); command.SetParameterValue("@CreateTime", DateTime.Now); command.SetParameterValue("@SourceSysNo", info.SourceSysNo); command.SetParameterValue("@ReasonCodeSysNo", info.ReasonCodeSysNo); command.SetParameterValue("@Content", info.Content); command.SetParameterValue("@UpdateUserSysNo", DBNull.Value); command.SetParameterValue("@UpdateTime", DBNull.Value); command.SetParameterValue("@Status", info.Status); command.SetParameterValue("@RemindTime", info.RemindTime); command.SetParameterValue("@Note", info.Note); command.SetParameterValue("@CallType", DBNull.Value); command.SetParameterValue("@ResponsibleDepCode", DBNull.Value); command.SetParameterValue("@Importance", info.Importance); command.SetParameterValue("@CompanyCode", companyCode); command.ExecuteNonQuery(); }
/// <summary> /// 修改三级延保信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public CategoryExtendWarranty UpdateCategoryExtendWarranty(CategoryExtendWarranty entity) { DataCommand cmd = DataCommandManager.GetDataCommand("UpdateCategoryExtendWarranty"); cmd.SetParameterValue("@BrandSysNo", entity.Brand.SysNo ?? -1); cmd.SetParameterValue("@C3SysNo", entity.CategoryInfo.SysNo); cmd.SetParameterValue("@EditUser", entity.EditUser.UserDisplayName); cmd.SetParameterValue("@ProductCode", entity.ProductCode); cmd.SetParameterValue("@Status", entity.Status); cmd.SetParameterValue("@Years", entity.Years); cmd.SetParameterValue("@MinUnitPrice", entity.MinUnitPrice); cmd.SetParameterValue("@MaxUnitPrice", entity.MaxUnitPrice); cmd.SetParameterValue("@UnitPrice", entity.UnitPrice); cmd.SetParameterValue("@Cost", entity.Cost); cmd.SetParameterValue("@SysNo", entity.SysNo); cmd.SetParameterValue("@CompanyCode", entity.CompanyCode); cmd.SetParameterValue("@IsECSelected", entity.IsECSelected); cmd.ExecuteNonQuery(); return(entity); }
public static DataSet GetJobProductRequest(JobProductRequestEntity entity) { DataSet dsResult = null; DataCommand cmd = DataCommandManager.GetDataCommand("GetJobProductRequest"); cmd.SetParameterValue("@SysNo", entity.SysNo); cmd.SetParameterValue("@ProductName", entity.ProductName); cmd.SetParameterValue("@ProductID", entity.ProductID); cmd.SetParameterValue("@ProductLink", entity.ProductLink); cmd.SetParameterValue("@HostWarrantyDay", entity.HostWarrantyDay); cmd.SetParameterValue("@PartWarrantyDay", entity.PartWarrantyDay); cmd.SetParameterValue("@Warranty", entity.Warranty); cmd.SetParameterValue("@ServicePhone", entity.ServicePhone); cmd.SetParameterValue("@ServiceInfo", entity.ServiceInfo); cmd.SetParameterValue("@Note", entity.Note); cmd.SetParameterValue("@Weight", entity.Weight); cmd.SetParameterValue("@IsLarge", entity.IsLarge); cmd.SetParameterValue("@Length", entity.Length); cmd.SetParameterValue("@Width", entity.Width); cmd.SetParameterValue("@Height", entity.Height); cmd.SetParameterValue("@MinPackNumber", entity.MinPackNumber); cmd.SetParameterValue("@Status", entity.Status); cmd.SetParameterValue("@Type", entity.Type); cmd.SetParameterValue("@PromotionTitle", entity.PromotionTitle); cmd.SetParameterValue("@Auditor", entity.Auditor); cmd.SetParameterValue("@AuditDate", entity.AuditDate); cmd.SetParameterValue("@CompanyCode", entity.CompanyCode); cmd.SetParameterValue("@StoreCompanyCode", entity.StoreCompanyCode); cmd.SetParameterValue("@LanguageCode", entity.LanguageCode); cmd.SetParameterValue("@InDate", entity.InDate); cmd.SetParameterValue("@InUser", entity.InUser); cmd.SetParameterValue("@EditDate", entity.EditDate); cmd.SetParameterValue("@EditUser", entity.EditUser); dsResult = cmd.ExecuteDataSet(); return(dsResult); }
/// <summary> /// 得到商品和条件选项值bing的信息 /// </summary> /// <param name="query"></param> /// <param name="totalCoutn"></param> /// <returns></returns> public DataTable QueryAccessoriesQueryConditionBind(ProductAccessoriesQueryConditionPreViewQueryFilter query, out int totalCount) { DataCommand cmd = DataCommandManager.GetDataCommand("QueryAccessoriesQueryConditionBind"); cmd.SetParameterValue("@MasterSysNo", query.MasterSysNo); cmd.SetParameterValue("@ProductID", query.ProductID); cmd.SetParameterValue("@ConditionValueSysNo1", query.ConditionValueSysNo1); cmd.SetParameterValue("@ConditionValueSysNo2", query.ConditionValueSysNo2); cmd.SetParameterValue("@ConditionValueSysNo3", query.ConditionValueSysNo3); cmd.SetParameterValue("@ConditionValueSysNo4", query.ConditionValueSysNo4); cmd.SetParameterValue("@Category1SysNo", query.Category1SysNo); cmd.SetParameterValue("@Category2SysNo", query.Category2SysNo); cmd.SetParameterValue("@Category3SysNo", query.Category3SysNo); cmd.SetParameterValue("@SortField", query.PagingInfo.SortBy); cmd.SetParameterValue("@PageSize", query.PagingInfo.PageSize); cmd.SetParameterValue("@PageCurrent", query.PagingInfo.PageIndex); DataTable dt = new DataTable(); dt = cmd.ExecuteDataTable(); totalCount = (int)cmd.GetParameterValue("@TotalCount"); return(dt); }
public int CreateConsignSettlementRule(ConsignSettlementRulesInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("InsertConsignSettleRule"); command.SetParameterValue("@ApprovedDate", DBNull.Value); command.SetParameterValue("@ApprovedUser", DBNull.Value); command.SetParameterValue("@BeginDate", entity.BeginDate); command.SetParameterValue("@CompanyCode", entity.CompanyCode); command.SetParameterValue("@CreateDate", DateTime.Now); command.SetParameterValue("@CreateUser", entity.CreateUser); command.SetParameterValue("@CurrencyCode", entity.CurrencyCode); command.SetParameterValue("@EditDate", DateTime.Now); command.SetParameterValue("@EditUser", entity.CreateUser); command.SetParameterValue("@EndDate", entity.EndDate); command.SetParameterValue("@LanguageCode", "zh-CN"); command.SetParameterValue("@NewSettlePrice", entity.NewSettlePrice); command.SetParameterValue("@OldSetttlePrice", entity.OldSettlePrice); command.SetParameterValue("@ProductSysNo", entity.ProductSysNo); command.SetParameterValue("@SettleedQuantity", DBNull.Value); command.SetParameterValue("@SettleRuleName", entity.SettleRulesName); command.SetParameterValue("@SettleRuleQuantity", entity.SettleRulesQuantity); command.SetParameterValue("@SettleRulesCode", entity.SettleRulesCode); command.SetParameterValue("@Status", (char)entity.Status); command.SetParameterValue("@StopDate", DBNull.Value); command.SetParameterValue("@StopUser", DBNull.Value); command.SetParameterValue("@StoreCompanyCode", entity.CompanyCode); command.SetParameterValue("@VendorSysNo", entity.VendorSysNo); int sysNo = Convert.ToInt32(command.ExecuteScalar()); return(sysNo); }
/// <summary> ///根据CategoryType 添加CeateCategory /// </summary> /// <param name="type"></param> /// <param name="entity"></param> public void CeateCategoryByType(CategoryType type, CategoryInfo entity) { DataCommand cmd = null; switch (type) { case CategoryType.CategoryType1: cmd = DataCommandManager.GetDataCommand("CreateCategory1"); cmd.SetParameterValue("@SysNo", entity.SysNo); cmd.SetParameterValue("@C1ID", entity.CategoryID); cmd.SetParameterValue("@C1Name", entity.CategoryName.Content); cmd.SetParameterValue("@Status", entity.Status); cmd.SetParameterValue("@CompanyCode", entity.CompanyCode); cmd.SetParameterValue("@LanguageCode", entity.LanguageCode); break; case CategoryType.CategoryType2: cmd = DataCommandManager.GetDataCommand("CreateCategory2"); cmd.SetParameterValue("@SysNo", entity.SysNo); cmd.SetParameterValue("@C2ID", entity.CategoryID); cmd.SetParameterValue("@C2Name", entity.CategoryName.Content); cmd.SetParameterValue("@C1SysNo", entity.ParentSysNumber); cmd.SetParameterValue("@Status", entity.Status); cmd.SetParameterValue("@CompanyCode", entity.CompanyCode); cmd.SetParameterValue("@LanguageCode", entity.LanguageCode); break; case CategoryType.CategoryType3: cmd = DataCommandManager.GetDataCommand("CreateCategory3"); cmd.SetParameterValue("@SysNo", entity.SysNo); cmd.SetParameterValue("@C3ID", entity.CategoryID); cmd.SetParameterValue("@C3Name", entity.CategoryName.Content); cmd.SetParameterValue("@C2SysNo", entity.ParentSysNumber); cmd.SetParameterValue("@Status", entity.Status); cmd.SetParameterValue("@MinMargin", 0); cmd.SetParameterValue("@MinMarginPMD", 0); cmd.SetParameterValue("@CompanyCode", entity.CompanyCode); cmd.SetParameterValue("@LanguageCode", entity.LanguageCode); cmd.SetParameterValue("@C3Code", entity.C3Code); break; default: cmd = DataCommandManager.GetDataCommand("CreateCategory1"); cmd.SetParameterValue("@SysNo", entity.SysNo); cmd.SetParameterValue("@C1ID", entity.CategoryID); cmd.SetParameterValue("@C1Name", entity.CategoryName.Content); cmd.SetParameterValue("@Status", entity.Status); cmd.SetParameterValue("@CompanyCode", entity.CompanyCode); cmd.SetParameterValue("@LanguageCode", entity.LanguageCode); break; } cmd.ExecuteNonQuery(); }
/// <summary> /// 添加配送方式-产品 /// </summary> /// <param name="ShipTypeProductInfo"></param> /// <returns></returns> public void CreateShipTypeProduct(ShipTypeProductInfo ShipTypeProductInfo) { object obj = null; DataCommand cmd = DataCommandManager.GetDataCommand("ShipTypeProduct_Master_Create"); cmd.SetParameterValue("@StockSysNo", ShipTypeProductInfo.WareHouse); cmd.SetParameterValue("@ShipTypeSysNo", ShipTypeProductInfo.ShippingType); if (!ShipTypeProductInfo.CitySysNo.HasValue && !ShipTypeProductInfo.ProvinceSysNo.HasValue) { cmd.SetParameterValue("@AreaSysNo", null); } if (!ShipTypeProductInfo.CitySysNo.HasValue && ShipTypeProductInfo.ProvinceSysNo.HasValue) { cmd.SetParameterValue("@AreaSysNo", ShipTypeProductInfo.ProvinceSysNo); } if (ShipTypeProductInfo.CitySysNo.HasValue && !ShipTypeProductInfo.DistrictSysNo.HasValue) { cmd.SetParameterValue("@AreaSysNo", ShipTypeProductInfo.CitySysNo); } if (ShipTypeProductInfo.DistrictSysNo.HasValue) { cmd.SetParameterValue("@AreaSysNo", ShipTypeProductInfo.AreaSysNo); } cmd.SetParameterValue("@InUser", ServiceContext.Current.UserSysNo); cmd.SetParameterValue("@EditUser", ServiceContext.Current.UserSysNo); cmd.SetParameterValue("@Status", "A"); cmd.SetParameterValue("@CompanyCode", ShipTypeProductInfo.CompanyCode); cmd.SetParameterValue("@StoreCompanyCode", ShipTypeProductInfo.CompanyCode); cmd.SetParameterValue("@LanguageCode", "zh-CN"); cmd.ExecuteNonQuery(); ShipTypeProductInfo.SysNo = (int)cmd.GetParameterValue("@SysNo"); CustomDataCommand cmd_item = DataCommandManager.CreateCustomDataCommandFromConfig("ShipTypeProduct_Item_Create"); StringBuilder builersql = new StringBuilder();; if (ShipTypeProductInfo.ListProductInfo == null && ShipTypeProductInfo.ListCategoryInfo == null) { return; } if (ShipTypeProductInfo.ListProductInfo != null && ShipTypeProductInfo.ListCategoryInfo == null) { for (int i = 0; i < ShipTypeProductInfo.ListProductInfo.Count; i++) { cmd_item.SetParameterValue("@MasterSysNo", ShipTypeProductInfo.SysNo); cmd_item.SetParameterValue("@CompanyCode", ShipTypeProductInfo.CompanyCode); cmd_item.SetParameterValue("@Status", "A"); cmd_item.SetParameterValue("@Description", ShipTypeProductInfo.Description); if (EnumCodeMapper.TryGetCode(ShipTypeProductInfo.ShipTypeProductType, out obj)) { cmd_item.SetParameterValue("@Type", obj); } if (EnumCodeMapper.TryGetCode(ShipTypeProductInfo.ProductRange, out obj)) { cmd_item.SetParameterValue("@ItemRange", obj); } cmd_item.SetParameterValue("@InUser", ServiceContext.Current.UserSysNo); cmd_item.SetParameterValue("@EditUser", ServiceContext.Current.UserSysNo); cmd_item.SetParameterValue("@StoreCompanyCode", ShipTypeProductInfo.CompanyCode); cmd_item.SetParameterValue("@LanguageCode", "zh-CN"); cmd_item.SetParameterValue("@CompanyCustomer", 0); builersql.Append(cmd_item.CommandText.Replace("#DynamicData#", ShipTypeProductInfo.ListProductInfo[i].SysNo.ToString() + ",'" + ShipTypeProductInfo.ListProductInfo[i].ProductID.ToString() + "'")); } cmd_item.CommandText = builersql.ToString(); cmd_item.ExecuteNonQuery(); } if (ShipTypeProductInfo.ListProductInfo == null && ShipTypeProductInfo.ListCategoryInfo != null) { for (int i = 0; i < ShipTypeProductInfo.ListCategoryInfo.Count; i++) { cmd_item.SetParameterValue("@MasterSysNo", ShipTypeProductInfo.SysNo); cmd_item.SetParameterValue("@CompanyCode", ShipTypeProductInfo.CompanyCode); cmd_item.SetParameterValue("@Status", "A"); cmd_item.SetParameterValue("@Description", ShipTypeProductInfo.Description); if (EnumCodeMapper.TryGetCode(ShipTypeProductInfo.ShipTypeProductType, out obj)) { cmd_item.SetParameterValue("@Type", obj); } if (EnumCodeMapper.TryGetCode(ShipTypeProductInfo.ProductRange, out obj)) { cmd_item.SetParameterValue("@ItemRange", obj); } cmd_item.SetParameterValue("@InUser", ServiceContext.Current.UserSysNo); cmd_item.SetParameterValue("@EditUser", ServiceContext.Current.UserSysNo); cmd_item.SetParameterValue("@StoreCompanyCode", ShipTypeProductInfo.CompanyCode); cmd_item.SetParameterValue("@LanguageCode", "zh-CN"); cmd_item.SetParameterValue("@CompanyCustomer", 0); builersql.Append(cmd_item.CommandText.Replace("#DynamicData#", ShipTypeProductInfo.ListCategoryInfo[i].SysNo + ",null")); } cmd_item.CommandText = builersql.ToString(); cmd_item.ExecuteNonQuery(); } }
/// <summary> /// 新建APInvoice Master信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public virtual int InsertAPInvoiceMaster(APInvoiceInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("InsertMaster"); //command.SetParameterValue("@DocDate", entity.DocDate); command.SetParameterValue("@WareHouseNo", entity.StockSysNo); command.SetParameterValue("@VendorSysNo", entity.VendorSysNo); command.SetParameterValue("@VendorName", entity.VendorName); command.SetParameterValue("@VendorTaxRate", entity.VendorTaxRate); command.SetParameterValue("@Memo", entity.Memo); command.SetParameterValue("@DiffMemo", entity.DiffMemo); command.SetParameterValue("@PoNetAmt", entity.PoNetAmt); command.SetParameterValue("@PoNetTaxAmt", entity.PoNetTaxAmt); command.SetParameterValue("@InvoiceAmt", entity.InvoiceAmt ?? 0); command.SetParameterValue("@InvoiceTaxAmt", entity.InvoiceTaxAmt ?? 0); command.SetParameterValue("@DiffTaxAmt", entity.DiffTaxAmt); command.SetParameterValue("@DiffTaxTreatmentType", entity.DiffTaxTreatmentType); command.SetParameterValueAsCurrentUserAcct("@InUser"); //command.SetParameterValue("@InDate", entity.InDate); command.SetParameterValue("@ConfirmUser", entity.ConfirmUser); command.SetParameterValue("@ConfirmDate", entity.ConfirmDate); command.SetParameterValue("@Status", entity.Status); //command.SetParameterValue("LanguageCode", entity.LanguageCode); //command.SetParameterValue("CurrencyCode", entity.CurrencyCode); command.SetParameterValue("CompanyCode", entity.CompanyCode); //command.SetParameterValue("StoreCompanyCode", entity.StoreCompanyCode); return(Convert.ToInt32(command.ExecuteScalar())); }
public static int GetLocationSysno(int pagetype, int positionID, int pageID) { int locationsysno = 0; DataCommand command = DataCommandManager.GetDataCommand("CheckOnlineListLocation"); command.SetParameterValue("@PageType", pagetype); command.SetParameterValue("@PositionID", positionID); command.SetParameterValue("@PageID", pageID); command.SetParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]); try { locationsysno = command.ExecuteScalar <int>(); } catch { locationsysno = 0; } if (locationsysno == 0) { DataCommand dc = DataCommandManager.GetDataCommand("InsertOnlineListlocation"); dc.SetParameterValue("@PageType", pagetype); dc.SetParameterValue("@PositionID", positionID); dc.SetParameterValue("@Priority", 0); dc.SetParameterValue("@PageID", pageID); dc.SetParameterValue("@Description", "系统添加位置"); dc.SetParameterValue("@InDate", DateTime.Now); dc.SetParameterValue("@InUser", "System"); dc.SetParameterValue("@EditDate", DateTime.Now); dc.SetParameterValue("@EditUser", "System"); dc.SetParameterValue("@Status", "A"); dc.SetParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]); dc.SetParameterValue("@LanguageCode", ConfigurationManager.AppSettings["LanguageCode"]); dc.SetParameterValue("@StoreCompanyCode", ConfigurationManager.AppSettings["CompanyCode"]); dc.ExecuteNonQuery(); locationsysno = (int)dc.GetParameterValue("@OnlineListlocationSysNo"); } return(locationsysno); }
public static OnlineList Insert(OnlineList entity) { DataCommand command = DataCommandManager.GetDataCommand("InsertOnlineList"); command.SetParameterValue("@OnlineListlocationSysNo", entity.OnlineLocationSysNo); command.SetParameterValue("@ProductID", entity.ProductID); command.SetParameterValue("@Priority", entity.Priority); command.SetParameterValue("@BeginDate", DateTime.Now); command.SetParameterValue("@EndDate", DateTime.Now.AddDays(1)); command.SetParameterValue("@InDate", DateTime.Now); command.SetParameterValue("@InUser", "System"); command.SetParameterValue("@EditDate", DateTime.Now); command.SetParameterValue("@EditUser", "System"); command.SetParameterValue("@Status", "A"); command.SetParameterValue("@CompanyCode", ConfigurationManager.AppSettings["CompanyCode"]); command.SetParameterValue("@LanguageCode", ConfigurationManager.AppSettings["LanguageCode"]); command.SetParameterValue("@StoreCompanyCode", ConfigurationManager.AppSettings["CompanyCode"]); command.ExecuteNonQuery(); entity.SysNo = (int)command.GetParameterValue("@SysNo"); return(entity); }
public DataTable GetProductNotifyByQuery(ProductNotifyQueryFilter query, out int totalCount) { DataCommand dc = DataCommandManager.GetDataCommand("GetProductNotifyList"); dc.SetParameterValue("@C1SysNo1", query.Category1SysNo); dc.SetParameterValue("@C2SysNo1", query.Category2SysNo); dc.SetParameterValue("@C3SysNo1", query.Category3SysNo); dc.SetParameterValue("@Status", query.Status); dc.SetParameterValue("@ProductSysNo", query.ProductSysNo); dc.SetParameterValue("@StartTime", query.StartTime); dc.SetParameterValue("@EndTime", query.EndTime); dc.SetParameterValue("@Email", query.Email); dc.SetParameterValue("@CustomerID", query.CustomserID); dc.SetParameterValue("@PMSysNo", query.PMSysNo); dc.SetParameterValue("@PageSize", query.PageInfo.PageSize); dc.SetParameterValue("@PageCurrent", query.PageInfo.PageIndex); dc.SetParameterValue("@SortField", query.PageInfo.SortBy); DataTable dt = new DataTable(); dt = dc.ExecuteDataTable(3, typeof(NotifyStatus)); totalCount = (int)dc.GetParameterValue("@TotalCount"); return(dt); }
/// <summary> /// 更新POItems /// </summary> /// <param name="entity"></param> /// <param name="docNo"></param> public virtual void UpdatePOItem(APInvoicePOItemInfo entity, int docNo) { DataCommand command = DataCommandManager.GetDataCommand("UpdateAPInvoicePOItem"); command.SetParameterValue("@DocNo", docNo); command.SetParameterValue("@PoNo", entity.PoNo); command.SetParameterValue("@PoWarehouseNo", entity.PoStockSysNo ?? 0); command.SetParameterValue("@PoCurrency", 1); command.SetParameterValue("@PoAmt", entity.PoAmt ?? 0); command.SetParameterValue("@EIMSNo", entity.EIMSNo); if (entity.EIMSAmt == null) { entity.EIMSAmt = 0; } command.SetParameterValue("@EIMSAmt", entity.EIMSAmt); if (entity.EIMSNetAmt == null) { entity.EIMSNetAmt = 0; } command.SetParameterValue("@EIMSNetAmt", entity.EIMSNetAmt); command.SetParameterValue("@EIMSNetTaxAmt", entity.EIMSNetTaxAmt); command.SetParameterValue("@PoNetAmt", entity.PoNetAmt); command.SetParameterValue("@PaymentAmt", entity.PaymentAmt ?? 0); command.SetParameterValue("@PoBaselineDate", entity.PoBaselineDate); command.SetParameterValue("@PoPaymentTerm", entity.PoPaymentTerm); command.SetParameterValue("@Status", entity.Status); command.SetParameterValue("@EditDate", DateTime.Now); command.SetParameterValueAsCurrentUserAcct("@EditUser"); command.SetParameterValue("@OrderType", (int)entity.OrderType); command.SetParameterValue("@BatchNumber", entity.BatchNumber); command.SetParameterValue("@PayableTaxAmt", entity.PayableTaxAmt); command.ExecuteNonQuery(); }
public List<Model.TB_MULTI_STEP> GetMultiStepListByTypeID(string typeId) { var cmd = new DataCommand("getMultiStepListByTypeID", new SqlCustomDbCommand()); cmd.SetParameterValue("@TYPEID", typeId); return cmd.ExecuteEntityList<Model.TB_MULTI_STEP>(); }
public void UpdateProductCommonInfoBasicInfo(ProductCommonInfo productCommonInfo, UserInfo operationUser) { DataCommand dc = DataCommandManager.GetDataCommand("UpdateProductCommonInfoBasicInfo"); dc.SetParameterValue("@ProductCommonInfoSysNo", productCommonInfo.ProductCommonInfoSysNo); dc.SetParameterValue("@ProductTitle", productCommonInfo.ProductBasicInfo.ProductTitle.Content); dc.SetParameterValue("@ProductBriefName", productCommonInfo.ProductBasicInfo.ProductBriefName); dc.SetParameterValue("@Keywords", productCommonInfo.ProductBasicInfo.Keywords.Content); dc.SetParameterValue("@ProductModel", productCommonInfo.ProductBasicInfo.ProductModel.Content); dc.SetParameterValue("@ProductType", productCommonInfo.ProductBasicInfo.ProductType); dc.SetParameterValue("@PMUserSysNo", productCommonInfo.ProductBasicInfo.ProductManager.SysNo); dc.SetParameterValue("@ProductDescription", productCommonInfo.ProductBasicInfo.ShortDescription.Content); dc.SetParameterValue("@PackageList", productCommonInfo.ProductBasicInfo.PackageList.Content); dc.SetParameterValue("@ProductLink", productCommonInfo.ProductBasicInfo.ProductLink); dc.SetParameterValue("@Attention", productCommonInfo.ProductBasicInfo.Attention.Content); dc.SetParameterValue("@IsTakePicture", productCommonInfo.ProductBasicInfo.IsTakePicture); dc.SetParameterValue("@UPCCode", productCommonInfo.ProductBasicInfo.UPCCode); dc.SetParameterValue("@BMCode", productCommonInfo.ProductBasicInfo.BMCode); dc.SetParameterValue("@EditUser", operationUser.UserDisplayName); dc.SetParameterValue("@EditUserSysNo", operationUser.SysNo); dc.ExecuteNonQuery(); }