Ejemplo n.º 1
0
        public bool CreateDataByPsersons(string psersons, string rowid)
        {
            if (string.IsNullOrEmpty(psersons))
            {
                return(false);
            }
            List <string> liStr = new List <string>(psersons.Split(','));

            //1:删除数据
            DBSession.IWGJG02_TemplateDAL.DeletePersonsData(liStr, rowid);
            //2:添加数据
            WGJG01_Template wg1  = DBSession.IWGJG01_TemplateDAL.Select(s => s.RowID == rowid).FirstOrDefault();
            List <A01>      list = DBSession.IA01DAL.GetPeronsBySel(liStr, wg1.UnitID);

            foreach (A01 item in list)
            {
                Add(new WGJG02_Template()
                {
                    RowID          = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()),
                    WGJG01RowID    = rowid,
                    PersonSalaryID = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()),
                    PersonID       = item.PersonID,
                    A0101          = item.A0101,
                    A0177          = item.A0177,
                    B0002          = "",//item.B0002,
                    UnitID         = item.UnitID,
                    E0386          = item.E0386,
                    WGJG0203       = wg1?.WGJG0203,
                    WGJG0204       = item.A0178, //工资
                    WGJG0207       = item.A0178,
                    WGJG0208       = item.A0178
                });
            }
            return(true);
        }
Ejemplo n.º 2
0
        /// <summary>
        ///  导入数据
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public bool ImportPersonData(DataTable dt, string UnitID, string RowID)
        {
            if (null == dt || dt.Rows.Count <= 0)
            {
                return(false);
            }
            List <A01> a01 = DBSession.IA01DAL.Select(s => s.UnitID.Equals(UnitID));

            if (null == a01 || a01.Count <= 0)
            {
                return(false);
            }
            //删除之前的模板数据
            DBSession.IWGJG02_TemplateDAL.Delete(s => s.WGJG01RowID.Equals(RowID));
            WGJG01_Template wg1 = DBSession.IWGJG01_TemplateDAL.Select(s => s.RowID == RowID).FirstOrDefault();

            foreach (DataRow item in dt.Rows)
            {
                A01 temp = a01.Where(s => s.PersonID.Equals(item["F5"])).FirstOrDefault();
                if (null == temp)
                {
                    continue;
                }
                decimal W0178 = 0, //应发
                        A0178 = 0; //实发
                try{
                    W0178 = Convert.ToDecimal(item["F3"]);
                    A0178 = Convert.ToDecimal(item["F4"]);
                }
                catch
                { W0178 = 0; A0178 = 0; }
                Add(new WGJG02_Template()
                {
                    RowID          = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()),
                    WGJG01RowID    = RowID,
                    PersonSalaryID = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()),
                    PersonID       = temp.PersonID,
                    A0101          = temp.A0101,
                    A0177          = temp.A0177,
                    B0002          = "",//item.B0002,
                    UnitID         = temp.UnitID,
                    E0386          = temp.E0386,
                    WGJG0203       = wg1?.WGJG0203,
                    WGJG0204       = temp.A0178, //工资
                    WGJG0207       = W0178,      //应发
                    WGJG0208       = A0178       //实发
                });
            }
            return(true);
        }
Ejemplo n.º 3
0
        public bool CheckGrantWage(string wgDate, string rowId)
        {
            WGJG01_Template wt1 = DBSession.IWGJG01_TemplateDAL.Select(s => s.RowID == rowId).FirstOrDefault();

            if (wt1 == null)
            {
                return(false);
            }
            DateTime?dt = DateTime.ParseExact(wgDate, "yyyy-MM-dd", new System.Globalization.CultureInfo("zh-CN"));
            WGJG01   wg = DBSession.IWGJG01DAL.Select(s => s.ModelID == rowId && s.WGJG0103 == wt1.WGJG0103 && s.WGJG0107 == dt).FirstOrDefault();

            if (null != wg)
            {
                return(true);
            }
            return(false);
        }
Ejemplo n.º 4
0
        public bool CreateDataByUnit(string rowid)
        {
            if (string.IsNullOrEmpty(rowid))
            {
                return(false);
            }
            //1:删除数据
            Delete(s => s.WGJG01RowID == rowid);
            //2:重新生成数据
            WGJG01_Template wg1 = DBSession.IWGJG01_TemplateDAL.Select(s => s.RowID == rowid).FirstOrDefault();

            if (wg1 == null)
            {
                return(false);
            }
            //3:添加数据
            List <A01> list = DBSession.IA01DAL.Select(s => s.UnitID == wg1.UnitID);

            foreach (A01 item in list)
            {
                Add(new WGJG02_Template()
                {
                    RowID          = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()),
                    WGJG01RowID    = rowid,
                    PersonSalaryID = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()),
                    PersonID       = item.PersonID,
                    A0101          = item.A0101,
                    A0177          = item.A0177,
                    B0002          = "",//item.B0002,
                    UnitID         = item.UnitID,
                    E0386          = item.E0386,
                    WGJG0203       = wg1.WGJG0203,
                    WGJG0204       = item.A0178, //工资
                    WGJG0207       = item.A0178,
                    WGJG0208       = item.A0178
                });
            }
            return(true);
        }
Ejemplo n.º 5
0
        public int AddWGJG01(WGJG01_Template model)
        {
            B01 b01 = DBSession.IB01DAL.Select(s => s.UnitID == model.UnitID).FirstOrDefault();

            if (b01 == null)
            {
                return(0);
            }
            WGJG01_Template wg = new WGJG01_Template()
            {
                B0001    = (b01.KeyParent.Equals(".")) ? model.UnitID : b01.KeyParent,
                B0002    = "",//(model.UnitID.Length == 3) ? "" : model.UnitID,
                UnitID   = model.UnitID,
                RowID    = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()),
                WGJG0101 = model.WGJG0101,
                WGJG0103 = model.WGJG0103,
                WGJG0104 = model.WGJG0104,
                WGJG0106 = model.WGJG0106,
                WGJG0203 = model.WGJG0203,
                WGJGDAY  = model.WGJGDAY
            };

            return(Add(wg));
        }
Ejemplo n.º 6
0
 public int EditWGJG01(WGJG01_Template model)
 {
     return(Modify(model, "WGJG0101", "WGJG0103", "WGJGDAY", "WGJG0104", "WGJG0203"));
 }