public ActionResult EditMainType()
{
string typecod1 = Request["typecode1"];
string typecod2 = Request["typecode2"];
logger.Debug("get main type code1=" + typecod1 + ",typecod2=" + typecod2);
TyepManageModel typeManageModel = service.getTypeManageModel(typecod1, typecod2);
return(View(typeManageModel));
}
public ActionResult EditMainType(TyepManageModel typeManageModel)
{
logger.Info("modify mainType" + typeManageModel.MainType.TYPE_DESC);
logger.Info("modify SubType" + Request["item.SUB_TYPE_CODE"]);
string[] subTypeId = null;
string[] mainTypeId = null;
string[] subTypeCode = null;
string[] subTypeDesc = null;
if (Request["item.SUB_TYPE_ID"] != null)
{
subTypeId = Request["item.SUB_TYPE_ID"].Split(',');
mainTypeId = Request["item.TYPE_CODE_ID"].Split(',');
subTypeCode = Request["item.SUB_TYPE_CODE"].Split(',');
subTypeDesc = Request["item.TYPE_DESC"].Split(',');
}
List <REF_TYPE_SUB> lstSubType = new List <REF_TYPE_SUB>();
if (subTypeId != null)
{
for (int i = 0; i < subTypeCode.Count(); i++)
{
logger.Debug("subTypeId=" + subTypeId[i] + ",mainTypeId=" + mainTypeId[i] + ",subTypeCode=" + subTypeCode[i] + ",subTypeDesc=" + subTypeDesc[i]);
REF_TYPE_SUB subType = new REF_TYPE_SUB();
if (subTypeId[i] == "")
{
//新次九宮格
subType.SUB_TYPE_ID = int.Parse(mainTypeId[i] + subTypeCode[i]);
}
else
{
//原次九宮格
subType.SUB_TYPE_ID = int.Parse(subTypeId[i]);
}
subType.TYPE_CODE_ID = mainTypeId[i];
subType.SUB_TYPE_CODE = int.Parse(subTypeCode[i]);
subType.TYPE_DESC = subTypeDesc[i];
lstSubType.Add(subType);
}
}
service.updateTypeManageModel(typeManageModel.MainType, lstSubType);
return(Redirect("Index"));
//return View(typeManageModel);
}
public TyepManageModel getTypeManageModel(string typecode1, string typecode2)
{
TyepManageModel typeManageModel = new TyepManageModel();
//List<REF_TYPE_MAIN> lstMainType = new List<REF_TYPE_MAIN>();
using (var context = new topmepEntities())
{
var parameters = new List <SqlParameter>();
string sql = "SELECT * FROM REF_TYPE_MAIN WHERE TYPE_CODE_1=@code1 AND TYPE_CODE_2=@code2 ";
logger.Debug(sql);
parameters.Add(new SqlParameter("code1", typecode1));
parameters.Add(new SqlParameter("code2", typecode2));
//lstMainType = context.REF_TYPE_MAIN.SqlQuery(sql, parameters.ToArray()).ToList();
typeManageModel.MainType = context.REF_TYPE_MAIN.SqlQuery(sql, parameters.ToArray()).First();
}
typeManageModel.SubTypes = getSubType(typeManageModel.MainType.TYPE_CODE_1 + typeManageModel.MainType.TYPE_CODE_2);
logger.Debug("get Main Type Count" + typeManageModel.MainType.TYPE_DESC + ",sub type count" + typeManageModel.SubTypes.Count());
return(typeManageModel);
}
