Exemple #1
0
        public void InsertAddRuleSet(List <tpraddrst> list)
        {
            try
            {
                using (TransactionScope scope = new TransactionScope())
                {
                    for (int i = 0; i < list.Count; i++)
                    {
                        DoInsert <tpraddrst>(list[i]);

                        if (list[i].rlcd.Trim() != string.Empty)
                        {
                            //Insert into tprrstsit
                            tprrstsit sit = new tprrstsit();
                            sit.itcd = list[i].itcd;
                            sit.lmtm = DateTime.Now;
                            sit.lmur = Function.GetCurrentUser();
                            sit.rlcd = list[i].rlcd;

                            DoInsert <tprrstsit>(sit);
                        }
                    }
                    scope.Complete();
                }
            }
            catch (UtilException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw new UtilException(ex.Message, ex);
            }
        }
Exemple #2
0
        public void InsertPubRuleSet(tprpubrst obj, List <tprprsdtl> list)
        {
            try
            {
                using (TransactionScope scope = new TransactionScope())
                {
                    //insert
                    DoInsert <tprpubrst>(obj);

                    for (int i = 0; i < list.Count; i++)
                    {
                        string rlcd = UtilDatetime.FormatTime4(DateTime.Now);
                        if (list[i].vtyp == "Sum")
                        {
                            list[i].rlcd = rlcd;
                        }
                        DoInsert <tprprsdtl>(list[i]);

                        if (list[i].vtyp == "Sum")
                        {
                            string[] arr = list[i].valu.Split(',');
                            for (int j = 0; j < arr.Length; j++)
                            {
                                tprrstsit sit = new tprrstsit();
                                sit.itcd = arr[j].Substring(1, arr[j].Length - 2);
                                sit.lmtm = list[i].lmtm;
                                sit.lmur = list[i].lmur;
                                sit.rlcd = rlcd;

                                DoInsert <tprrstsit>(sit);
                            }
                        }
                    }
                    scope.Complete();
                }
            }
            catch (UtilException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw new UtilException(ex.Message, ex);
            }
        }
Exemple #3
0
        public void UpdatePriRuleSet(string _emno, List <tprprirst> list)
        {
            try
            {
                using (TransactionScope scope = new TransactionScope())
                {
                    //delete first
                    List <ColumnInfo> parameters = new List <ColumnInfo>()
                    {
                        new ColumnInfo()
                        {
                            ColumnName = "emno", ColumnValue = _emno
                        }
                    };
                    BaseBll          baseBll = new BaseBll();
                    List <tprprirst> lstDtl  = baseBll.GetSelectedRecords <tprprirst>(parameters, true);
                    for (int i = 0; i < lstDtl.Count; i++)
                    {
                        if (lstDtl[i].vtyp == "Sum")
                        {
                            //delete rel item
                            List <ColumnInfo> relparams = new List <ColumnInfo>()
                            {
                                new ColumnInfo()
                                {
                                    ColumnName = "rlcd", ColumnValue = lstDtl[i].rlcd
                                }
                            };
                            DoMultiDelete <tprrstsit>(relparams);
                        }
                        //DoDelete<tprprirst>(lstDtl[i]);
                    }

                    DoMultiDelete <tprprirst>(parameters);

                    for (int i = 0; i < list.Count; i++)
                    {
                        string rlcd = UtilDatetime.FormatTime4(DateTime.Now);
                        if (list[i].vtyp == "Sum")
                        {
                            list[i].rlcd = rlcd;
                        }

                        DoInsert <tprprirst>(list[i]);

                        if (list[i].vtyp == "Sum")
                        {
                            string[] arr = list[i].valu.Split(',');
                            for (int j = 0; j < arr.Length; j++)
                            {
                                tprrstsit sit = new tprrstsit();
                                sit.itcd = arr[j].Substring(1, arr[j].Length - 2);
                                sit.lmtm = list[i].lmtm;
                                sit.lmur = list[i].lmur;
                                sit.rlcd = rlcd;

                                DoInsert <tprrstsit>(sit);
                            }
                        }
                    }
                    scope.Complete();
                }
            }
            catch (UtilException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw new UtilException(ex.Message, ex);
            }
        }
Exemple #4
0
        public void ApplyTo(List <vw_employment> _emps, List <tprprirst> lstObj)
        {
            try
            {
                using (TransactionScope scope = new TransactionScope())
                {
                    for (int i = 0; i < _emps.Count; i++)
                    {
                        if (_emps[i].emno != lstObj[0].emno)
                        {
                            int?n = GetMaxsqno(new List <ColumnInfo>()
                            {
                                new ColumnInfo()
                                {
                                    ColumnName = "emno", ColumnValue = _emps[i].emno
                                }
                            });
                            int maxSqno = 0;

                            if (!n.HasValue)
                            {
                                maxSqno = 0;
                            }
                            else
                            {
                                maxSqno = n.Value;
                            }

                            for (int j = 0; j < lstObj.Count; j++)
                            {
                                string    rlcd = UtilDatetime.FormatTime4(DateTime.Now.AddMilliseconds(100));
                                tprprirst obj  = lstObj[j];

                                tprprirst newobj = new tprprirst();

                                newobj.cnfr = obj.cnfr;
                                newobj.cred = obj.cred;
                                newobj.crcd = obj.crcd;
                                newobj.efdt = obj.efdt;
                                newobj.emno = _emps[i].emno;
                                newobj.exdt = obj.exdt;
                                newobj.isca = obj.isca;
                                newobj.itcd = obj.itcd;
                                newobj.lmtm = DateTime.Now;
                                newobj.lmur = Function.GetCurrentUser();
                                newobj.pdcd = obj.pdcd;
                                newobj.sqno = maxSqno + j + 1;
                                newobj.ssty = obj.ssty;
                                newobj.valu = obj.valu;
                                newobj.vtyp = obj.vtyp;
                                newobj.rlcd = rlcd;

                                DoInsert <tprprirst>(newobj);

                                if (newobj.valu == "Sum")
                                {
                                    List <ColumnInfo> relparams = new List <ColumnInfo>()
                                    {
                                        new ColumnInfo()
                                        {
                                            ColumnName = "rlcd", ColumnValue = obj.rlcd
                                        }
                                    };
                                    List <tprrstsit> lstRel = GetSelectedRecords <tprrstsit>(relparams);
                                    for (int m = 0; m < lstRel.Count; m++)
                                    {
                                        tprrstsit newsit = new tprrstsit();
                                        newsit.itcd = lstRel[m].itcd;
                                        newsit.lmtm = newobj.lmtm;
                                        newsit.lmur = newobj.lmur;
                                        newsit.rlcd = rlcd;

                                        DoInsert <tprrstsit>(newsit);
                                    }
                                }
                            }
                        }
                    }

                    scope.Complete();
                }
            }
            catch (UtilException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw new UtilException(ex.Message, ex);
            }
        }
Exemple #5
0
        public void UpdateAddRuleSet(string _emno, List <tpraddrst> list)
        {
            try
            {
                using (TransactionScope scope = new TransactionScope())
                {
                    //delete first
                    List <ColumnInfo> parameters = new List <ColumnInfo>()
                    {
                        new ColumnInfo()
                        {
                            ColumnName = "emno", ColumnValue = _emno
                        }
                    };

                    //delete summary relationship
                    List <tpraddrst> lstOld = GetSelectedRecords <tpraddrst>(parameters);
                    for (int i = 0; i < lstOld.Count; i++)
                    {
                        DoDelete <tprrstsit>(new List <ColumnInfo>()
                        {
                            new ColumnInfo()
                            {
                                ColumnName = "rlcd", ColumnValue = lstOld[i].rlcd
                            },
                            new ColumnInfo()
                            {
                                ColumnName = "itcd", ColumnValue = lstOld[i].itcd
                            }
                        });
                    }

                    DoMultiDelete <tpraddrst>(parameters);

                    for (int i = 0; i < list.Count; i++)
                    {
                        DoInsert <tpraddrst>(list[i]);

                        if (list[i].rlcd.Trim() != string.Empty)
                        {
                            //Insert into tprrstsit
                            tprrstsit sit = new tprrstsit();
                            sit.itcd = list[i].itcd;
                            sit.lmtm = DateTime.Now;
                            sit.lmur = Function.GetCurrentUser();
                            sit.rlcd = list[i].rlcd;

                            DoInsert <tprrstsit>(sit);
                        }
                    }
                    scope.Complete();
                }
            }
            catch (UtilException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw new UtilException(ex.Message, ex);
            }
        }