コード例 #1
0
        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);
        }
コード例 #2
0
ファイル: TR01V2Controller.cs プロジェクト: WuYen/VN_PURSYS
        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"));
        }
コード例 #3
0
        /// <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);
        }
コード例 #4
0
ファイル: SysUserService.cs プロジェクト: WuYen/VN_PURSYS
        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);
        }
コード例 #5
0
        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));
        }
コード例 #6
0
        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);
        }
コード例 #7
0
ファイル: RP01Controller.cs プロジェクト: WuYen/VN_PURSYS
        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));
        }
コード例 #8
0
        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)));
        }
コード例 #9
0
ファイル: TR01AViewModel.cs プロジェクト: WuYen/VN_PURSYS
        /// <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 [ 資料處理 ]
            }
        }
コード例 #10
0
        /// <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);
        }
コード例 #11
0
ファイル: RP01V2Controller.cs プロジェクト: WuYen/VN_PURSYS
        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);
        }
コード例 #12
0
ファイル: BA04Controller.cs プロジェクト: WuYen/VN_PURSYS
        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()));
        }
コード例 #13
0
        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);
        }
コード例 #14
0
        /// <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 [ 資料處理 ]
            }
        }
コード例 #15
0
ファイル: TR01V2Controller.cs プロジェクト: WuYen/VN_PURSYS
        /// <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)));
        }
コード例 #16
0
ファイル: TR01Controller.cs プロジェクト: WuYen/LMAS
 public ActionResult BA02BCombobox(int key)
 {
     ViewBag.DataSource = CacheCommonDataModule.GetBA02B(key);
     return(PartialView("_BA02BCombobox"));
 }
コード例 #17
0
 public ActionResult UserSelectGrid()
 {
     return(PartialView("_UserSelectGrid", CacheCommonDataModule.GetSystemUser()));
 }