public ActionResult DCW003Paging(CmnPagingModel cmnPagingModel)
{
DCW003ConditionModel conditionModel = base.GetCache <DCW003ConditionModel>(CacheKeys.DCW003_CONDITION);
List <DCW003FuzokuhinMaster> lstFuzokuhinMaster = new List <DCW003FuzokuhinMaster>();
string typeMsg = string.Empty;
string errorMsg = string.Empty;
int rowCount = 0;
conditionModel.PageIndex = cmnPagingModel.PageIndex;
conditionModel.PageSize = cmnPagingModel.PageSize;
conditionModel.PageBegin = cmnPagingModel.PageBegin;
conditionModel.PageEnd = cmnPagingModel.PageEnd;
DCW003DetailModel detailModel = new DCW003DetailModel();
List <DCW003Result> resultModel = new List <DCW003Result>();
List <DCW003Uketori> uketoriModel = new List <DCW003Uketori>();
using (DCW003Services services = new DCW003Services())
{
lstFuzokuhinMaster = services.DCW003GetFuzokuhinMaster();
ViewBag.DocFuzokuhinMaster = lstFuzokuhinMaster;
services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
}
detailModel.ResultModel = resultModel;
detailModel.UketoriModel = uketoriModel;
base.SaveCache(CacheKeys.DCW003_CONDITION, conditionModel);
InitialDropDownList();
ViewBag.SearchCondition = conditionModel;
return(View("_DCW003Result", detailModel));
}
public ActionResult DCW003Search(DCW003ConditionModel conditionModel)
{
List <DCW003FuzokuhinMaster> lstFuzokuhinMaster = new List <DCW003FuzokuhinMaster>();
string typeMsg = string.Empty;
string contentMsg = string.Empty;
int rowCount = 0;
conditionModel.PageIndex = DCW003Constant.DEFAULT_PAGE_INDEX;
conditionModel.PageSize = DCW003Constant.DEFAULT_PAGE_SIZE;
DCW003DetailModel detailModel = new DCW003DetailModel();
List <DCW003Result> resultModel = new List <DCW003Result>();
List <DCW003Uketori> uketoriModel = new List <DCW003Uketori>();
using (DCW003Services services = new DCW003Services())
{
lstFuzokuhinMaster = services.DCW003GetFuzokuhinMaster();
ViewBag.DocFuzokuhinMaster = lstFuzokuhinMaster;
services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
if (resultModel.Count == 0)
{
UtilityServices.Utility.GetMessage("I0003",
string.Empty,
out typeMsg,
out contentMsg);
this.ViewBag.typeMsgI0001 = typeMsg;
this.ViewBag.contentMsgI0001 = contentMsg;
}
}
if (conditionModel == null)
{
conditionModel.PageIndex = DCW003Constant.DEFAULT_PAGE_INDEX;
conditionModel.PageSize = DCW003Constant.DEFAULT_PAGE_SIZE;
conditionModel.TotalRow = rowCount;
}
conditionModel.TotalRow = resultModel.Count != 0 ? resultModel[0].RowCount : 0;
base.SaveCache(CacheKeys.DCW003_CONDITION, conditionModel);
detailModel.ResultModel = resultModel;
detailModel.UketoriModel = uketoriModel;
InitialDropDownList();
ViewBag.SearchCondition = conditionModel;
return(View("_DCW003Result", detailModel));
}
public ActionResult DCW003Index(int mode, int check)
{
string lstError = string.Empty;
string lstNoMap = string.Empty;
string lstImport = string.Empty;
string lstDocControlNo = string.Empty;
string messageContent = string.Empty;
string messageType = string.Empty;
int rowCount = 0;
DCW003Model model = new DCW003Model();
DCW003ConditionModel conditionModel = new DCW003ConditionModel();
DCW003DetailModel detailModel = new DCW003DetailModel();
List <DCW003Uketori> uketoriModel = new List <DCW003Uketori>();
List <DCW003Result> resultModel = new List <DCW003Result>();
DCW003ConditionModel cache = base.GetCache <DCW003ConditionModel>(CacheKeys.DCW003_CONDITION);
if (cache == null)
{
conditionModel.PageIndex = DCW003Constant.DEFAULT_PAGE_INDEX;
conditionModel.PageSize = DCW003Constant.DEFAULT_PAGE_SIZE;
conditionModel.KeiCarFlg0 = NUMBER.NUM_0;
conditionModel.KeiCarFlg1 = NUMBER.NUM_0;
conditionModel.JishameiFlg = NUMBER.NUM_0;
conditionModel.MasshoFlg = NUMBER.NUM_0;
conditionModel.RadioType = NUMBER.NUM_1;
}
else
{
conditionModel = cache;
mode = 0;
}
List <DCW003FuzokuhinMaster> lstFuzokuhinMaster = new List <DCW003FuzokuhinMaster>();
using (DCW003Services services = new DCW003Services())
{
//Get label master fuzokuhin
lstFuzokuhinMaster = services.DCW003GetFuzokuhinMaster();
ViewBag.DocFuzokuhinMaster = lstFuzokuhinMaster;
switch (mode)
{
case 0:
{
services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
}
break;
//詳細条件で書類を検索する
case 1:
{
conditionModel.ShohinType = DCW003Constant.SHOHIN_TYPE_DN;
conditionModel.DocStatus102 = 1;
conditionModel.AaDnSeiyakuDateStart = null;
conditionModel.AaDnSeiyakuDateEnd = DateTime.Now.AddDays(-1);
ViewBag.Mode = 1;
services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
}
break;
//本日発送予定の書類を検索する(普通車)
case 2:
{
conditionModel.ShohinType = DCW003Constant.SHOHIN_TYPE_DN;
conditionModel.DocStatus102 = 1;
conditionModel.KeiCarFlg0 = NUMBER.NUM_1;
conditionModel.AaDnSeiyakuDateEnd = DateTime.Now.AddDays(-1);
services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
}
break;
//本日発送予定の書類を検索する(軽)
case 3:
{
conditionModel.ShohinType = DCW003Constant.SHOHIN_TYPE_DN;
conditionModel.DocStatus102 = 1;
conditionModel.KeiCarFlg1 = NUMBER.NUM_1;
conditionModel.AaDnSeiyakuDateEnd = DateTime.Now.AddDays(-1);
services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
}
break;
//棚卸し
case 5:
{
conditionModel.DocStatus102 = 1;
services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
}
break;
//Import 1
case 6:
{
List <DCW003CsvModel> lstCsv = new List <DCW003CsvModel>();
DataTable tblCsv = (DataTable)TempData["tblCsv"];
if (tblCsv != null)
{
if (tblCsv.Rows.Count > 0)
{
for (int i = 0; i < tblCsv.Rows.Count; i++)
{
lstCsv.Add(new DCW003CsvModel
{
ID = i,
RacFileNo = tblCsv.Rows[i][0].ToString(),
KeiCarFlg = tblCsv.Rows[i][1].ToString(),
TorokuNo = tblCsv.Rows[i][2].ToString(),
HyobanType = tblCsv.Rows[i][3].ToString(),
ChassisNo = tblCsv.Rows[i][4].ToString(),
GendokiKatashiki = tblCsv.Rows[i][5].ToString(),
ReportType = tblCsv.Rows[i][6].ToString(),
});
}
if (check == 0)
{
conditionModel.ModeImport = 1;
services.DCW003ImportCsv(lstCsv, out lstError, out lstNoMap, out lstImport, out lstDocControlNo);
Utility.GetMessage("I0010",
SubStringList(lstImport), SubStringList(lstError), SubStringList(lstNoMap),
out messageType,
out messageContent);
ViewBag.contentMsgI0010 = messageContent;
ViewBag.typeMsgI0010 = messageType;
if (!string.IsNullOrEmpty(lstDocControlNo))
{
lstDocControlNo = lstDocControlNo.Substring(1);
services.DCW003GetListImport(lstDocControlNo, lstFuzokuhinMaster, conditionModel.PageIndex, conditionModel.PageSize,
out resultModel, out uketoriModel, out rowCount);
}
}
else
{
conditionModel.ModeImport = 2;
services.DCW003GetDocControlExist(lstCsv, lstFuzokuhinMaster, conditionModel.PageIndex, conditionModel.PageSize, 1,
out resultModel, out uketoriModel, out lstImport, out rowCount);
Utility.GetMessage("I0010",
lstImport, string.Empty, string.Empty,
out messageType,
out messageContent);
ViewBag.contentMsgI0010 = messageContent;
ViewBag.typeMsgI0010 = messageType;
}
}
else
{
return(ReturnResult());
}
}
}
break;
case 7:
{
conditionModel.ModeImport = 3;
List <DCW003CsvModel> lstCsv = new List <DCW003CsvModel>();
DataTable tblCsv = (DataTable)TempData["tblCsv"];
if (tblCsv != null)
{
if (tblCsv.Rows.Count > 0)
{
for (int i = 0; i < tblCsv.Rows.Count; i++)
{
lstCsv.Add(new DCW003CsvModel
{
ID = i,
KeiCarFlg = tblCsv.Rows[i][0].ToString(),
TorokuNo = tblCsv.Rows[i][1].ToString(),
HyobanType = tblCsv.Rows[i][2].ToString(),
ChassisNo = tblCsv.Rows[i][3].ToString(),
GendokiKatashiki = tblCsv.Rows[i][4].ToString(),
ReportType = tblCsv.Rows[i][5].ToString(),
});
}
services.DCW003GetDocControlExist(lstCsv, lstFuzokuhinMaster, conditionModel.PageIndex, conditionModel.PageSize, 2,
out resultModel, out uketoriModel, out lstImport, out rowCount);
}
}
}
break;
case 8:
{
conditionModel.ModeImport = 3;
List <DCW003RFID> lstCsv = new List <DCW003RFID>();
DataTable tblCsv = (DataTable)TempData["tblCsv"];
if (tblCsv != null)
{
if (tblCsv.Rows.Count > 0)
{
for (int i = 0; i < tblCsv.Rows.Count; i++)
{
lstCsv.Add(new DCW003RFID
{
ID = i,
RFIDKey = tblCsv.Rows[i][0].ToString(),
});
}
resultModel = services.DCW003GetDocControlMaster(lstCsv, conditionModel.PageIndex, conditionModel.PageSize, out rowCount);
}
}
}
break;
case 9:
{
conditionModel.ModeImport = 4;
List <DCW003CsvModel> lstCsv = new List <DCW003CsvModel>();
DataTable tblCsv = (DataTable)TempData["tblCsv"];
if (tblCsv != null)
{
if (tblCsv.Rows.Count > 0)
{
for (int i = 0; i < tblCsv.Rows.Count; i++)
{
if (tblCsv.Rows[i][5].ToString() == "自社名依頼")
{
tblCsv.Rows[i][5] = "101";
}
else if (tblCsv.Rows[i][5].ToString() == "抹消依頼")
{
tblCsv.Rows[i][5] = "201";
}
lstCsv.Add(new DCW003CsvModel
{
ID = i,
IraiDate = tblCsv.Rows[i][0].ToString(),
ShopCd = tblCsv.Rows[i][1].ToString(),
GenshaLocation = tblCsv.Rows[i][2].ToString(),
CarName = tblCsv.Rows[i][3].ToString(),
ChassisNo = tblCsv.Rows[i][4].ToString(),
JMType = tblCsv.Rows[i][5].ToString(),
Note = tblCsv.Rows[i][6].ToString(),
});
}
services.DCW003GetDocControlExist(lstCsv, lstFuzokuhinMaster, conditionModel.PageIndex, conditionModel.PageSize, 3,
out resultModel, out uketoriModel, out lstImport, out rowCount);
if (resultModel.Count > 0)
{
services.DCWOO3InserJishameiMassho(resultModel, lstCsv);
}
}
}
}
break;
}
}
conditionModel.TotalRow = resultModel.Count != 0 ? resultModel[0].RowCount: 0;
if (conditionModel.TotalRow == 0 && mode != 6)
{
Utility.GetMessage(MessageCd.I0003, string.Empty, out messageType, out messageContent);
ViewBag.typeMsgI0010 = messageType;
ViewBag.contentMsgI0010 = messageContent;
}
detailModel.UketoriModel = uketoriModel;
detailModel.ResultModel = resultModel;
model.Condition = conditionModel;
model.Detail = detailModel;
base.SaveCache(CacheKeys.DCW003_CONDITION, conditionModel);
InitialDropDownList();
ViewBag.SearchCondition = model.Condition;
return(View(model));
}
