public List <CustomDataValueDomainModel> GetCustomDataValueDomainModelListByDataIdFromDatabase(string dataId) { List <CustomDataValueDomainModel> list = null; string sql = "SELECT * FROM custom_data_value WHERE data_id = $data_id$ ORDER BY sort_order ASC"; ParameterCollection pc = new ParameterCollection(); pc.Add("data_id", dataId); DataTable dt = ExecuteDataTable(sql, pc); if (dt != null && dt.Rows.Count > 0) { list = new List <CustomDataValueDomainModel>(); CustomDataValueDomainModel model = null; for (int i = 0; i < dt.Rows.Count; i++) { model = new CustomDataValueDomainModel(); model.DataId = dt.Rows[i]["data_id"].ToString(); model.DataValue = dt.Rows[i]["data_value"].ToString(); model.DataValueCode = dt.Rows[i]["data_value_code"].ToString(); model.SortOrder = Convert.ToInt32(dt.Rows[i]["sort_order"]); model.Status = Convert.ToInt32(dt.Rows[i]["status"]); model.ValueId = dt.Rows[i]["value_id"].ToString(); list.Add(model); } } return(list); }
/// <summary> /// 新建自定义枚举值。 /// </summary> /// <param name="valueInfo"></param> /// <param name="dataId"></param> /// <returns></returns> public bool NewCustomDataValue(CustomDataValueDomainModel valueInfo, string dataId) { bool result = false; CustomDataDomainModel dataInfo = GetCustomDataDomainModelById(dataId, false); valueInfo.ValueId = Guid.NewGuid().ToString(); valueInfo.DataId = dataId; valueInfo.SortOrder = dataInfo.ValueList.Count + 1; CustomDataValueModel dataModel = new CustomDataValueModel(); dataModel.ValueId = valueInfo.ValueId; dataModel.DataId = dataId; dataModel.DataValue = valueInfo.DataValue; dataModel.DataValueCode = valueInfo.DataValueCode; dataModel.SortOrder = valueInfo.SortOrder; dataModel.Status = valueInfo.Status; if (CustomDataValueService.Instance.Create(dataModel) > 0) { GetCustomDataDomainModelById(dataId, true); result = true; } return(result); }
public JsonResult DoNewCustomValue() { CustomDataValueDomainModel model = new CustomDataValueDomainModel(); model.ValueId = Guid.NewGuid().ToString(); model.DataId = GetFormData("dataId"); model.DataValue = GetFormData("dataValue"); model.DataValueCode = GetFormData("valueCode"); model.Status = Convert.ToInt32(GetFormData("valueStatus")); if (CustomDataInfoService.Instance.NewCustomDataValue(model, model.DataId)) { return(SuccessedJson("成功添加枚举值成员", "System_CustomInfo", "System_CustomInfo", "forward", "/system/custominfo?cid=" + model.DataId + "&=" + new Random().Next().ToString())); } else { return(FailedJson("操作失败,请与管理员联系")); } }
public JsonResult DoUpdateCustomValue() { CustomDataValueDomainModel model = new CustomDataValueDomainModel(); model.ValueId = GetFormData("valueId"); model.DataId = GetFormData("dataId"); model.DataValue = GetFormData("dataValue"); model.DataValueCode = GetFormData("valueCode"); model.SortOrder = Convert.ToInt32(GetFormData("sortOrder")); model.Status = Convert.ToInt32(GetFormData("valueStatus")); if (CustomDataInfoService.Instance.UpdateCustomDataValue(model, model.DataId)) { return(SuccessedJson("成功更新枚举值成员", "System_CustomInfo", "System_CustomInfo", "forward", "/system/customvaluelist?cid=" + model.DataId)); } else { return(FailedJson("操作失败,请与管理员联系")); } }
/// <summary> /// 更新指定枚举值。 /// </summary> /// <param name="valueInfo"></param> /// <param name="dataId"></param> /// <returns></returns> public bool UpdateCustomDataValue(CustomDataValueDomainModel valueInfo, string dataId) { bool result = false; CustomDataValueModel dataModel = new CustomDataValueModel(); dataModel.ValueId = valueInfo.ValueId; dataModel.DataId = dataId; dataModel.DataValue = valueInfo.DataValue; dataModel.DataValueCode = valueInfo.DataValueCode; dataModel.SortOrder = valueInfo.SortOrder; dataModel.Status = valueInfo.Status; if (CustomDataValueService.Instance.Update(dataModel) > 0) { GetCustomDataDomainModelById(dataId, true); result = true; } return(result); }
// 在此添加你的代码... public bool ImportSalePackageFromExcel(DataSet ds, out string importLogs, out string message) { bool result = false; importLogs = message = "操作失败,请与管理员联系"; if (ds == null && ds.Tables.Count == 0) { message = "Excel数据文件异常,请检查"; return(false); } Dictionary <string, ProductCategoryInfoModel> productCategoryList = ProductCategoryInfoService.Instance.GetProductCategoryList(false); if (productCategoryList == null || productCategoryList.Count == 0) { message = "数据库中无产品类型信息,请检查"; return(false); } ParameterCollection pc = new ParameterCollection(); CustomDataDomainModel SaleCityList = CustomDataInfoService.Instance.GetCustomDataDomainModelByName("销售城市", false); SalesPackageInfoModel salePackInfo = null; ProductCategoryInfoModel proCatInfo = null; List <string> proCatList = new List <string>(); try { BeginTransaction(); for (int t = 0; t < ds.Tables.Count; t++) { if (ds.Tables[t].TableName.Contains("-") == false) { continue; } if (ds.Tables[t].TableName.Split('-')[0] != "营销计划") { continue; } string saleCityName = ds.Tables[t].TableName.Split('-')[1]; CustomDataValueDomainModel saleCityInfo = SaleCityList.GetCustomDataValueDomainByDataValue(saleCityName); if (saleCityInfo == null) { RollbackTransaction(); message = string.Format("数据库中不存在销售城市为【{0}】的营销计划,数据导入失败", saleCityName); return(false); } for (int i = 0; i < ds.Tables[t].Rows.Count; i++) { salePackInfo = new SalesPackageInfoModel(); salePackInfo.BeginTime = Convert.ToDateTime(ds.Tables[t].Rows[i]["有效起始时间"]); salePackInfo.EndTime = Convert.ToDateTime(ds.Tables[t].Rows[i]["有效截止时间"]); salePackInfo.Location = ds.Tables[t].Rows[i]["产品定位"].ToString(); salePackInfo.MonthKeepPrice = Convert.ToDecimal(ds.Tables[t].Rows[i]["每月补存"]); salePackInfo.MonthReturnPrice = Convert.ToDecimal(ds.Tables[t].Rows[i]["每月返还"]); salePackInfo.PackageName = ds.Tables[t].Rows[i]["项目名称"].ToString(); salePackInfo.PriceTotal = Convert.ToDecimal(ds.Tables[t].Rows[i]["业务总额"]); salePackInfo.Remark = ds.Tables[t].Rows[i]["备注信息"].ToString(); salePackInfo.ReturnMonths = Convert.ToInt32(ds.Tables[t].Rows[i]["返还月数"]); salePackInfo.SalePrice = Convert.ToDecimal(ds.Tables[t].Rows[i]["购机金额"]); salePackInfo.SalesCityId = saleCityInfo.ValueId; salePackInfo.SalesCityName = saleCityInfo.DataValue; salePackInfo.SalesPackageId = GetGuid(); salePackInfo.StagePrice = Convert.ToDecimal(ds.Tables[t].Rows[i]["每期金额"]); salePackInfo.Stages = Convert.ToInt32(ds.Tables[t].Rows[i]["分期数"]); salePackInfo.Status = 0; salePackInfo.StoredPrice = Convert.ToDecimal(ds.Tables[t].Rows[i]["预存话费"]); proCatList.Clear(); string[] catNameList = ds.Tables[t].Rows[i]["包含产品"].ToString().Split(','); if (catNameList == null || catNameList.Length == 0) { RollbackTransaction(); message = string.Format("销售城市为【{0}】的营销计划中,营销项目{1}中没有设置包含产品类型名称,数据导入失败", saleCityName, salePackInfo.PackageName); return(false); } for (int j = 0; j < catNameList.Length; j++) { proCatInfo = ProductCategoryInfoService.Instance.GetProductCategoryInfoByName(catNameList[j]); if (proCatInfo == null) { RollbackTransaction(); message = string.Format("销售城市为【{0}】的营销计划中,营销项目{1}中设置包含产品类型名称{2}不存在于数据库,数据导入失败", saleCityName, salePackInfo.PackageName, catNameList[j]); return(false); } proCatList.Add(proCatInfo.ProductCategoryId); } if (SalesPackageInfoService.Instance.CreateSalePackageInfo(salePackInfo, proCatList, out message) == false) { RollbackTransaction(); message = string.Format("销售城市为【{0}】的营销计划中,营销项目{1}数据导入失败", saleCityName, salePackInfo.PackageName); return(false); } } } CommitTransaction(); } catch (Exception ex) { RollbackTransaction(); LogUtil.Error("从Excel导入产品数据异常", ex); throw ex; } return(result); }
// 在此添加你的代码... /// <summary> /// 下移指定枚举值。 /// </summary> /// <param name="dataId"></param> /// <param name="valueId"></param> /// <param name="message"></param> /// <returns></returns> public bool MoveDownCustomDataValue(string dataId, string valueId, out string message) { bool result = false; message = "操作失败,请与管理员联系"; CustomDataDomainModel dataInfo = GetCustomDataDomainModelById(dataId, false); CustomDataValueDomainModel valueInfo = (dataInfo.ValueList.ContainsKey(valueId)) ? dataInfo.ValueList[valueId] : null; if (valueInfo == null) { message = "操作失败,该枚举值不存在"; return(false); } if (valueInfo.SortOrder == dataInfo.ValueList.Count) { message = "操作失败,该枚举值已为最下序列号"; return(false); } CustomDataValueDomainModel downValueInfo = null; foreach (CustomDataValueDomainModel item in dataInfo.ValueList.Values) { if (item.SortOrder == valueInfo.SortOrder + 1) { downValueInfo = item; } } if (downValueInfo != null) { string sql = @"UPDATE custom_data_value SET sort_order = $sort_order$ WHERE value_id = $value_id$"; try { BeginTransaction(); ParameterCollection pc = new ParameterCollection(); pc.Add("value_id", valueInfo.ValueId); pc.Add("sort_order", valueInfo.SortOrder + 1); if (ExecuteNonQuery(sql, pc) > 0) { pc.Clear(); pc.Add("value_id", downValueInfo.ValueId); pc.Add("sort_order", downValueInfo.SortOrder - 1); if (ExecuteNonQuery(sql, pc) > 0) { CommitTransaction(); GetCustomDataDomainModelById(dataId, true); message = "成功下移该自定义枚举值"; return(true); } } RollbackTransaction(); } catch (Exception ex) { RollbackTransaction(); LogUtil.Error("下移自定义枚举信息排序索引异常", ex); throw ex; } } return(result); }