Exemple #1
0
        public void UpdateMUF(string muid, string action)
        {
            try
            {
                BaseBll bll = new BaseBll();
                if (action == "add")
                {
                    tstmnumuf muf = new tstmnumuf();
                    muf.apnm = Parameter.APPLICATION_NAME;
                    muf.muid = muid.Trim();
                    muf.urid = Function.GetCurrentUser();
                    muf.adtm = DateTime.Now;

                    bll.DoInsert <tstmnumuf>(muf);
                }

                if (action == "delete")
                {
                    List <ColumnInfo> parameters = new List <ColumnInfo>()
                    {
                        new ColumnInfo()
                        {
                            ColumnName = "muid", ColumnValue = muid
                        },
                        new ColumnInfo()
                        {
                            ColumnName = "apnm", ColumnValue = Parameter.APPLICATION_NAME
                        },
                        new ColumnInfo()
                        {
                            ColumnName = "urid", ColumnValue = Function.GetCurrentUser()
                        }
                    };

                    tstmnumuf obj = bll.GetSelectedObject <tstmnumuf>(parameters);
                    if (obj != null)
                    {
                        //bll.DoDelete<tstmnumuf>(parameters);
                        bll.DoDelete <tstmnumuf>(obj);
                    }
                }
            }
            catch (UtilException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw new UtilException(ex.Message, ex);
            }
        }
Exemple #2
0
        public List <object> GetCalendarDetails(List <ColumnInfo> _parameter)
        {
            List <tatclddtl> result    = new List <tatclddtl>();
            DateTime         startDate = DateTime.Now;
            DateTime         endDate   = DateTime.Now;
            string           otcd      = string.Empty;
            string           htcd      = string.Empty;

            var q = from p in _parameter
                    where p.ColumnName == "stdt"
                    select p.ColumnValue;

            startDate = Convert.ToDateTime(q.Single());

            q = from p in _parameter
                where p.ColumnName == "endt"
                select p.ColumnValue;

            endDate = Convert.ToDateTime(q.Single());

            q = from p in _parameter
                where p.ColumnName == "otcd"
                select p.ColumnValue;

            otcd = q.Single();

            q = from p in _parameter
                where p.ColumnName == "htcd"
                select p.ColumnValue;

            htcd = q.Single();

            //tbssyscfgBll syscfgBll = new tbssyscfgBll();
            int  weekday   = Convert.ToUInt16(((StSystemConfig)Parameter.CURRENT_SYSTEM_CONFIG).AtWDPW);//syscfgBll.GetSysParameter_Weekwkdas();
            bool isHoliday = false;

            while (startDate <= endDate)
            {
                if (weekday == 5)
                {
                    if ((startDate.DayOfWeek == DayOfWeek.Saturday) || (startDate.DayOfWeek == DayOfWeek.Sunday))
                    {
                        isHoliday = true;
                    }
                    else
                    {
                        isHoliday = false;
                    }
                }
                else if (weekday == 6)
                {
                    if ((startDate.DayOfWeek == DayOfWeek.Sunday))
                    {
                        isHoliday = true;
                    }
                    else
                    {
                        isHoliday = false;
                    }
                }

                if (isHoliday)
                {
                    tatclddtl dtl = new tatclddtl()
                    {
                        cddt = startDate,
                        htcd = htcd,
                        otcd = otcd,
                        remk = "auto generation",
                        lmtm = DateTime.Now,
                        lmur = "System"
                    };
                    result.Add(dtl);
                }

                startDate = startDate.AddDays(1);
            }

            string  htnm    = string.Empty;
            string  otnm    = string.Empty;
            BaseBll baseBll = new BaseBll();

            tathldtyp ht = baseBll.GetSelectedObject <tathldtyp>(new List <ColumnInfo>()
            {
                new ColumnInfo()
                {
                    ColumnName = "htcd", ColumnValue = htcd
                }
            });

            htnm = ht.htnm;
            tottype ottype = baseBll.GetSelectedObject <tottype>(new List <ColumnInfo>()
            {
                new ColumnInfo()
                {
                    ColumnName = "otcd", ColumnValue = otcd
                }
            });

            otnm = ottype.otnm;

            var q1 = from p in result
                     select new
            {
                p.cddt,
                p.htcd,
                p.otcd,
                p.remk,
                p.lmtm,
                p.lmur,
                htnm = htnm,
                otnm = otnm
            };

            return(q1.Cast <object>().ToList());
        }
Exemple #3
0
        private void LoadData(string rpcd, List <ColumnInfo> lstParameters)
        {
            BaseBll bll = new BaseBll();

            trpexrpdf def = bll.GetSelectedObject <trpexrpdf>(new List <ColumnInfo>()
            {
                new ColumnInfo()
                {
                    ColumnName = "rpcd", ColumnValue = rpcd
                }
            });

            List <trpexrpdd> lstDtl = bll.GetSelectedRecords <trpexrpdd>(new List <ColumnInfo>()
            {
                new ColumnInfo()
                {
                    ColumnName = "rpcd", ColumnValue = rpcd
                }
            });

            rpexrpdpBll rpbll = new rpexrpdpBll();
            DataSet     ds    = null;

            switch (def.rpty)
            {
            case "Personnel":
                ds = rpbll.GetPersonalData(rpcd, lstDtl, lstParameters);
                break;

            case "Payroll":
                ds = rpbll.GetPayrollData(rpcd, lstDtl, lstParameters);
                break;

            case "PayrollBankAlloc":
                ds = rpbll.GetPayrollBankAllocData(rpcd, lstDtl, lstParameters);
                break;
            }

            if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                //Title
                this.GridView1.Caption = "<B>" + def.rptt + "</B>";

                this.GridView1.DataSource = ds;
                this.GridView1.DataBind();

                //Merge Column
                MergeGridView mergeGV = new MergeGridView();
                for (int i = 0; i < lstDtl.Count; i++)
                {
                    if (lstDtl[i].isme == "Y")
                    {
                        mergeGV.Merge(this.GridView1, i);
                    }
                }

                //Summary
                var q = (from p in lstDtl
                         where p.issu == "Y"
                         select p).ToList();

                for (int i = 0; i < q.Count; i++)
                {
                    //GridViewSummary sum = new GridViewSummary(q[i].itnm, SummaryOperation.Sum);
                }
            }
            else
            {
            }
        }