public static List <RP01AModel> FromEntity(List <TR01A> entityList) { var detailList = new List <RP01AModel>(); foreach (var item in entityList) { var BA01A = CacheCommonDataModule.GetBA01A(item.BA01A_ID); detailList.Add(new RP01AModel() { TR01A_ID = item.TR01A_ID, BA01A_ID = item.BA01A_ID, CRE_MY = item.CRE_MY, DEB_MY = item.DEB_MY, SUM_RM = item.SUM_RM, ACC_NO = BA01A.ACC_NO, ACC_NM = BA01A.ACC_NM, TRN_DT = item.TRN_DT, DtTRN_DT = DateTime.ParseExact(item.TRN_DT, "yyyyMMdd", CultureInfo.InvariantCulture), VOU_NO = item.VOU_NO, BA02A_ID = item.BA02A_ID, BA02B_ID = item.BA02B_ID, BA03A_ID = item.BA03A_ID, DA03A_ID = item.DA03A_ID, }); } return(detailList); }
public ActionResult ComboBoxContact(int?key) { if (key.HasValue) { var entity = new PURSysEntities(); var BA01A = entity.BA01A.FirstOrDefault(x => x.BA01A_ID == key.Value); if (BA01A != null) { ViewData["ADD_DR"] = BA01A.ADD_DR; ViewData["FAX_NO"] = BA01A.FAX_NO; ViewData["BA03A_ID"] = BA01A.BA03A_ID; var BA01BList = new Services.BA01.BA01Service().GetAllD(key.Value).ToList(); var BA01B = BA01BList.FirstOrDefault(x => x.BA01A_ID == key.Value); if (BA01B != null) { ViewData["TEL_NO"] = BA01B.TEL_NO; ViewData["TEL_EX"] = BA01B.TEL_EX; } ViewData["CUR_RT"] = CacheCommonDataModule.GetBA03A().First(x => x.BA03A_ID == BA01A.BA03A_ID).CUR_RT; } else { ViewData["ADD_DR"] = ""; ViewData["FAX_NO"] = ""; ViewData["BA03A_ID"] = ""; } ViewBag.Data = entity.BA01B.Where(x => x.BA01A_ID == key.Value).ToList(); } else { ViewBag.Data = new List <BA01B>(); } return(PartialView("_ComboBoxContact")); }
/// <summary>Entity to viewmodel Single</summary> /// <param name="entity">TR01A</param> public static TR01AViewModel FromEntity(TR01A entity) { var data = new TR01AViewModel(); if (entity != null) { var objectHelper = new ActWeis.Utility.ObjectHelper(); objectHelper.CopyValue(entity, data); #region [ 資料處理 ] var BA01A = CacheCommonDataModule.GetBA01A().FirstOrDefault(x => x.BA01A_ID == entity.BA01A_ID); if (BA01A != null) { data.FAX_NO = BA01A.FAX_NO; data.ADD_DR = BA01A.ADD_DR; } var BA01B = new Services.BA01.BA01Service().GetD(x => x.BA01B_ID == entity.BA01B_ID); if (BA01B != null) { data.TEL_NO = BA01B.TEL_NO; data.TEL_EX = BA01B.TEL_EX; } #endregion [ 資料處理 ] } return(data); }
public string SaveChanges(ref SystemUser entity, EntityState state) { var errMsg = ""; using (var trans = _Entity.Database.BeginTransaction(IsolationLevel.Snapshot)) { try { if (state == EntityState.Added) { _Entity.SystemUser.Add(entity); } else if (state == EntityState.Deleted) { _Entity.SystemUser.Remove(entity); } _Entity.SaveChanges(); trans.Commit(); CacheCommonDataModule.ReloadSystemUser(); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { errMsg = ex.Message; } catch (Exception ex) { errMsg = ex.Message;//ValidationHelper.GetSQLMessage(ex); } } return(errMsg); }
public static Tuple <TR01AModel, List <TR01BModel> > FromEntity(List <TR01A> entityList) { var temp = entityList.First(); var master = new TR01AModel { TRN_DT = temp.TRN_DT, DtTRN_DT = DateTime.ParseExact(temp.TRN_DT, "yyyyMMdd", CultureInfo.InvariantCulture), VOU_NO = temp.VOU_NO, BA02A_ID = temp.BA02A_ID, BA02B_ID = temp.BA02B_ID, BA03A_ID = temp.BA03A_ID, DA03A_ID = temp.DA03A_ID, EntityState = EntityState.Modified }; var detailList = new List <TR01BModel>(); foreach (var item in entityList) { var BA01A = CacheCommonDataModule.GetBA01A(item.BA01A_ID); detailList.Add(new TR01BModel() { TR01A_ID = item.TR01A_ID, BA01A_ID = item.BA01A_ID, CRE_MY = item.CRE_MY, DEB_MY = item.DEB_MY, SUM_RM = item.SUM_RM, ACC_NO = BA01A.ACC_NO, ACC_NM = BA01A.ACC_NM }); } return(new Tuple <TR01AModel, List <TR01BModel> >(master, detailList)); }
public static TR01BModel FromEntity(TR01B entity, DataRow dataRow) { var data = new TR01BModel(); if (entity != null) { var objectHelper = new ActWeis.Utility.ObjectHelper(); objectHelper.CopyValue(entity, data); //資料處理 var item = CacheCommonDataModule.GetBA02A().Where(x => x.BA02A_ID == entity.BA02A_ID).FirstOrDefault(); if (item != null) { data.ITM_NO = item.ITM_NO; data.ITM_NM = item.ITM_NM; data.ITM_SP = item.ITM_SP; } var totalQTSTR = dataRow["TotalQT"].ToString(); decimal.TryParse(totalQTSTR, out decimal total); data.ARR_QT_Sum = total; if (data.ARR_QT_Sum == data.PUR_QT) { data.ARR_ST = "1"; } else { data.ARR_ST = "0"; } var totalMYStr = dataRow["TotalMY"].ToString(); decimal.TryParse(totalMYStr, out decimal totalMY); data.ReceiveMY = totalMY; } return(data); }
public ActionResult PivotGridPartial() { var dataTable = GetData3(); dataTable.Columns.Add("TYP_NM", typeof(string)); foreach (DataRow row in dataTable.Rows) { var typeID = row["TYP_ID"].ToString(); if (int.TryParse(typeID, out int id)) { row["TYP_NM"] = CacheCommonDataModule.GetTypeDic().First(x => x.Value == id).Key; } } return(PartialView("_PivotGrid", dataTable)); }
public ActionResult ProductGrid(string selectedItem, string BA01A_ID, int?ignoreID, bool FirstPage = false) { var itemList = CacheCommonDataModule.GetBA02A(); if (selectedItem != null && selectedItem.Length > 0) { ViewData["selectedItem"] = selectedItem; } else { ViewData["FirstPage"] = FirstPage; } return(PartialView("_ProductGrid", GetData(BA01A_ID))); }
/// <summary> /// entity to viewmodel /// </summary> /// <param name="entity"></param> public void FromDomain(TR01A entity) { if (entity != null) { var objectHelper = new ActWeis.Utility.ObjectHelper(); objectHelper.CopyValue(entity, this); #region [ 資料處理 ] var BA01A = CacheCommonDataModule.GetBA01A().FirstOrDefault(x => x.BA01A_ID == this.BA01A_ID); if (BA01A != null) { this.ADD_DR = BA01A.ADD_DR; this.FAX_NO = BA01A.FAX_NO; } #endregion [ 資料處理 ] } }
/// <summary>Entity to viewmodel Single</summary> /// <param name="entity">TR01B</param> public static TR01BViewModel FromEntity(TR01B entity) { var data = new TR01BViewModel(); if (entity != null) { var objectHelper = new ActWeis.Utility.ObjectHelper(); objectHelper.CopyValue(entity, data); //資料處理 var item = CacheCommonDataModule.GetBA02A().Where(x => x.BA02A_ID == entity.BA02A_ID).FirstOrDefault(); if (item != null) { data.ITM_NO = item.ITM_NO; data.ITM_NM = item.ITM_NM; } } return(data); }
private DataTable GetGridViewSessionData3(string Year, bool Reload = false) { var data = Session["GridViewData3"] as DataTable; if (data == null || Reload) { data = GetData3(Year); data.Columns.Add("TYP_NM", typeof(string)); foreach (DataRow row in data.Rows) { var typeID = row["TYP_ID"].ToString(); if (int.TryParse(typeID, out int id)) { row["TYP_NM"] = CacheCommonDataModule.GetBA04AText(UserInfo.LanguageType, int.Parse(typeID)); } } Session["GridViewData3"] = data; } return(data); }
public ActionResult Update(BA04AModel master) { //Validation List <string> errList = BA04Business.Validation(master, ModelState); //BeforeSave + 驗證DDM + Save if (errList.Count == 0) { //BeforeSave var BA04A = BA04Business.BeforSave(master); //驗證DDM errList = BA04Business.Validation(master, ModelState, "BA04A"); //Save if (errList.Count == 0) { var result = _Service.Update(BA04A); master = BA04Business.FromEntity(result.Data); if (!string.IsNullOrWhiteSpace(result.Message)) { errList.Add(result.Message); } } } if (errList.Count > 0) { ViewData["ErrMsg"] = string.Join("<br />", errList); master.ModelState = ModelState; ViewData["ErrorData"] = master; } else { CacheCommonDataModule.ResetBA04AList(); ViewData["Success"] = true; } return(PartialView("_MasterGrid", GetList())); }
private List <ProductSelectModel> GetProductSelectModel(string BA01A_ID) { var dataList = new List <ProductSelectModel>(); var productList = CacheCommonDataModule.GetBA02A(); var incorporationList = CacheCommonDataModule.GetBA01A(); PURSysEntities entity = new PURSysEntities(); foreach (var item in productList) { var data = new ProductSelectModel() { BA02A_ID = item.BA02A_ID, ITM_NO = item.ITM_NO, ITM_NM = item.ITM_NM, //BA01A_ID = BA02B.BA01A_ID, //INC_NM = incorporationList.First(x => x.BA01A_ID == BA02B.BA01A_ID).INC_NM, //PUR_PR = BA02B.PUR_PR }; data.TYP_ID = item.TYP_ID; dataList.Add(data); //var tempData = entity.BA02B.Where(x => x.BA02A_ID == item.BA02A_ID).ToList(); //foreach (var BA02B in tempData) //{ // var data = new ProductSelectModel() // { // BA02A_ID = item.BA02A_ID, // ITM_NO = item.ITM_NO, // ITM_NM = item.ITM_NM, // BA01A_ID = BA02B.BA01A_ID, // INC_NM = incorporationList.First(x=>x.BA01A_ID == BA02B.BA01A_ID).INC_NM, // PUR_PR = BA02B.PUR_PR // }; // dataList.Add(data); //} } return(dataList); }
/// <summary> /// entity to viewmodel /// </summary> /// <param name="entity"></param> public void FromDomain(TR01B entity) { if (entity != null) { var objectHelper = new ActWeis.Utility.ObjectHelper(); objectHelper.CopyValue(entity, this); #region [ 資料處理 ] var item = CacheCommonDataModule.GetBA02A().Where(x => x.BA02A_ID == entity.BA02A_ID).FirstOrDefault(); if (item != null) { this.ITM_NO = item.ITM_NO; this.ITM_NM = item.ITM_NM; } //var incorporation = CacheCommonDataModule.GetBA01A().Where(x => x.BA01A_ID == entity.BA01A_ID).FirstOrDefault(); //if (incorporation != null) //{ // this.ITM_NO = item.ITM_NO; // this.ITM_NM = item.ITM_NM; //} #endregion [ 資料處理 ] } }
/// <summary>Only master data change</summary> /// <param name="master">主檔資料</param> /// <param name="key">JS keyOnPage的 value</param> /// <param name="Deletekey">要刪除的key</param> /// <param name="Reload_TF">控制是否單純刷新資料</param> /// <returns></returns> public ActionResult DetailGridCustomUpdate(TR01AViewModel master, string key, string Deletekey, string Reload_TF, string Lock, string DateBeg, string DateEnd, string Tax) { var errMsg = ""; if (Lock != null) { var entities = new PURSysEntities(); var keyInt = int.Parse(key); var data = entities.TR01A.First(x => x.TR01A_ID == keyInt); if (Lock == "Y") { data.CFN_YN = "N"; } else { data.CFN_YN = "Y"; } entities.SaveChanges(); } if (Reload_TF == "T")//load畫面 => 新增/查詢/取消 { int.TryParse(key, out int keyValue); if (keyValue > 0) { master = TR01Business.FromEntity(_Service.GetA(keyValue)); } else { //新增初始化 master.DtPUR_DT = DateTime.UtcNow.AddHours(07); master.CPN_NM = "劲亨金属表面处理工業有限公司 Công ty Jingheng"; master.TAX_RT = CacheCommonDataModule.GetTaxRate().First().Value; } ModelState.Clear(); } else // 修改(新增、修改) / 刪除 { if (master.CFN_YN == "Y") { errMsg += "資料已確認 不可修改"; int.TryParse(key, out int keyValue); master = TR01Business.FromEntity(_Service.GetA(keyValue)); } else if (master.CFN_YN == "P") { errMsg += "資料申請中 不可修改"; int.TryParse(key, out int keyValue); master = TR01Business.FromEntity(_Service.GetA(keyValue)); } else { if (int.TryParse(Deletekey, out int keyValue))// 刪除 { if (keyValue > 0) { errMsg = "查無此筆刪除資料"; var count = _Service.GetA(x => x.TR01A_ID == keyValue).Count(); if (count == 1) { errMsg = _Service.Delete(keyValue);//刪除成功回傳空字串 } if (errMsg.Length > 0) { ViewData["ErrMsg"] = "Delete Fail"; master = TR01Business.FromEntity(_Service.GetA(keyValue));//取回刪除失敗的資料回畫面顯示 } } ModelState.Clear(); } else// Save 新增、修改 data { //Help.ClearError(ModelState, "DtPUR_DT"); //Help.ClearError(ModelState, "DtEXP_DT"); if (UserInfo.LanguageType == Language.Type.VN) { master.DtPUR_DT = DateTime.Parse(DateBeg); master.DtEXP_DT = DateTime.Parse(DateEnd); ModelState.Clear(); TryValidateModel(master); } var isValid = TR01Business.Validation(master, ModelState); if (!TR01Business.ValidateRemove(master, null)) { isValid = false; errMsg = "資料已被其他人異動過"; } if (isValid)// Save { var TR01A = TR01Business.BeforSave(master); if (UserInfo.LanguageType == Language.Type.VN) { TR01A.PUR_DT = DateBeg.Replace("/", ""); //master.DtPUR_DT.Value.ToString("yyyyddMM"); TR01A.EXP_DT = DateEnd.Replace("/", ""); //master.DtEXP_DT.Value.ToString("yyyyddMM"); System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo(Language.US); TR01A.TAX_RT = double.Parse(Tax); } else { TR01A.PUR_DT = master.DtPUR_DT.Value.ToString("yyyyMMdd"); TR01A.EXP_DT = master.DtEXP_DT.Value.ToString("yyyyMMdd"); } var result = _Service.Update(TR01A); errMsg = result.Message; master = TR01Business.FromEntity(result.Data); } if (errMsg.Length > 0 || !isValid)// Result { errMsg += Resources.Resource.FailureStr; } } } } ViewData["ErrMsg"] = errMsg; ViewData["Key"] = master.TR01A_ID; var BA01BList = new Services.BA01.BA01Service().GetAllD(master.BA01A_ID).ToList(); ViewBag.Data = BA01BList; ViewData["CFN_YN"] = master.CFN_YN; if (master.CFN_YN == "Y") { ViewData["IsConfirm"] = true; } else { ViewData["IsConfirm"] = false; } ViewData["MasterForm"] = ReadViewHelper.PartialView(this, "_MasterForm", master); return(PartialView("_DetailGrid", GetTR01BList(master.TR01A_ID))); }
public ActionResult BA02BCombobox(int key) { ViewBag.DataSource = CacheCommonDataModule.GetBA02B(key); return(PartialView("_BA02BCombobox")); }
public ActionResult UserSelectGrid() { return(PartialView("_UserSelectGrid", CacheCommonDataModule.GetSystemUser())); }