private DTOResult SaveData(string mode, object model)
{
var da = new SEC006P001DA();
//ในกรณีที่มีการ SaveLog ให้ Include SetStandardLog ด้วย
SetStandardLog(
da.DTO,
model,
GetSaveLogConfig("dbo", "VSMS_USER", "USER_ID"));
if (mode == StandardActionName.SaveCreate)
{
SetStandardField(model);
da.DTO.Model = (SEC006P001Model)model;
SetStandardField(da.DTO.Model.ComUserModel);
da.Insert(da.DTO);
}
else if (mode == StandardActionName.SaveModify)
{
SetStandardField(model);
da.DTO.Model = (SEC006P001Model)model;
SetStandardField(da.DTO.Model.ComUserModel);
da.Update(da.DTO);
}
else if (mode == StandardActionName.Delete)
{
da.DTO.Model = new SEC006P001Model();
SetStandardField(da.DTO.Model);
da.DTO.Models = (List <SEC006P001Model>)model;
da.Delete(da.DTO);
}
return(da.DTO.Result);
}
//get ค่าจาก VSMS_USER
private SEC006P001Model GET_VSMS_USER(string USER_ID)
{
var da = new SEC006P001DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SEC006P001ExecuteType.GetByID;
da.DTO.Model.USER_ID = USER_ID;
da.Select(da.DTO);
return(da.DTO.Model);
}
public JsonResult Bind_ComForUser()
{
var da = new SEC006P001DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SEC006P001ExecuteType.GetUserCOM;
da.DTO.Model.USER_ID = TempModel.USER_ID;
da.SelectNoEF(da.DTO);
return(JsonAllowGet(da.DTO.Model.ComUserModel));
}
public ActionResult Info(string USER_ID)
{
SetDefaulButton(StandardButtonMode.View);
var da = new SEC006P001DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = DTOExecuteType.GetByID;
TempModel.USER_ID = da.DTO.Model.USER_ID = USER_ID;
da.Select(da.DTO);
if (da.DTO.Model != null)
{
localModel = da.DTO.Model;
}
return(View(StandardActionName.Info, localModel));
}
public ActionResult CustomsExport(SEC006P001Model model)
{
var da = new SEC006P001DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SEC006P001ExecuteType.GetQuerySearchAll;
da.Select(da.DTO);
if (da.DTO.Models != null)
{
ExportHelper.ExportExcel(Response, da.DTO.Models);
}
return(Content("ExportExcel clicked"));
}
public ActionResult Search(SEC006P001Model model)
{
var da = new SEC006P001DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SEC006P001ExecuteType.GetQuerySearchAll;
if (Request.GetRequest("page").IsNullOrEmpty())
{
model.IsDefaultSearch = true;
TempSearch = model;
}
da.DTO.Model = TempSearch;
da.DTO.Model.COM_CODE = SessionHelper.SYS_COM_CODE;
da.Select(da.DTO);
return(JsonAllowGet(da.DTO.Models, da.DTO.Result));
}
public ActionResult Edit(string USER_ID)
{
SetDefaulButton(StandardButtonMode.Modify);
var da = new SEC006P001DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SEC006P001ExecuteType.GetByID;
TempModel.USER_ID = da.DTO.Model.USER_ID = USER_ID;
da.Select(da.DTO);
if (da.DTO.Model != null)
{
localModel = da.DTO.Model;
}
SetDefaultData(StandardActionName.Edit);
return(View(StandardActionName.Edit, localModel));
}
private List <DDLCenterModel> BindUSG_ID_MODEL_ADD()
{
var da = new SEC006P001DA();
SetStandardErrorLog(da.DTO);
da.DTO.Execute.ExecuteType = SEC006P001ExecuteType.GetQueryCheckUserAdmin;
da.DTO.Model.USER_ID = SessionHelper.SYS_USER_ID;
da.DTO.Model.COM_CODE = SessionHelper.SYS_COM_CODE;
da.SelectNoEF(da.DTO);
if (da.DTO.Models[0].USG_LEVEL.AsString() == "S")
{
return(GetDDLCenter(DDLCenterKey.DD_VSMS_USRGROUP_001));
}
else
{//
return(GetDDLCenter(DDLCenterKey.DD_VSMS_USRGROUP_002));
}
}
