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);
}
