Exemple #1
0
 /// <summary>
 ///
 /// </summary>
 public UpdateAdjustRestByOut(OutApplicationItem item, int accountid)
 {
     _OutApplicationItem = item;
     _AccountID          = accountid;
     _AdjustRule         = new GetEmployeeAdjustRule().GetAdjustRuleByAccountID(accountid);
     if (_AdjustRule == null)
     {
         _AdjustRule = new AdjustRule(0, "", 0, 0, 0, 0, 0, 0);
     }
 }
 /// <summary>
 ///
 /// </summary>
 public UpdateAdjustRestByOverWork(OverWorkItem item, int accountid)
 {
     _OverWorkItem = item;
     _AccountID    = accountid;
     _AdjustRule   = new GetEmployeeAdjustRule().GetAdjustRuleByAccountID(accountid);
     if (_AdjustRule == null)
     {
         _AdjustRule = new AdjustRule(0, "", 0, 0, 0, 0, 0, 0);
     }
 }
        /// <summary>
        ///
        /// </summary>
        /// <param name="adjustRule"></param>
        /// <returns></returns>
        public int UpdateAdjustRule(AdjustRule adjustRule)
        {
            SqlCommand cmd = new SqlCommand();

            cmd.Parameters.Add(_PKID, SqlDbType.Int).Value                      = adjustRule.AdjustRuleID;
            cmd.Parameters.Add(_Name, SqlDbType.NVarChar, 200).Value            = adjustRule.AdjustRuleName;
            cmd.Parameters.Add(_OverWorkPuTongRate, SqlDbType.Decimal).Value    = adjustRule.OverWorkPuTongRate;
            cmd.Parameters.Add(_OverWorkJieRiRate, SqlDbType.Decimal).Value     = adjustRule.OverWorkJieRiRate;
            cmd.Parameters.Add(_OverWorkShuangXiuRate, SqlDbType.Decimal).Value = adjustRule.OverWorkShuangXiuRate;
            cmd.Parameters.Add(_OutCityPuTongRate, SqlDbType.Decimal).Value     = adjustRule.OutCityPuTongRate;
            cmd.Parameters.Add(_OutCityJieRiRate, SqlDbType.Decimal).Value      = adjustRule.OutCityJieRiRate;
            cmd.Parameters.Add(_OutCityShuangXiuRate, SqlDbType.Decimal).Value  = adjustRule.OutCityShuangXiuRate;
            return(SqlHelper.ExecuteNonQuery("AdjustRuleUpdate", cmd));
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="adjustRule"></param>
        /// <returns></returns>
        public int InsertAdjustRule(AdjustRule adjustRule)
        {
            int        pkid;
            SqlCommand cmd = new SqlCommand();

            cmd.Parameters.Add(_PKID, SqlDbType.Int).Direction                  = ParameterDirection.Output;
            cmd.Parameters.Add(_Name, SqlDbType.NVarChar, 200).Value            = adjustRule.AdjustRuleName;
            cmd.Parameters.Add(_OverWorkPuTongRate, SqlDbType.Decimal).Value    = adjustRule.OverWorkPuTongRate;
            cmd.Parameters.Add(_OverWorkJieRiRate, SqlDbType.Decimal).Value     = adjustRule.OverWorkJieRiRate;
            cmd.Parameters.Add(_OverWorkShuangXiuRate, SqlDbType.Decimal).Value = adjustRule.OverWorkShuangXiuRate;
            cmd.Parameters.Add(_OutCityPuTongRate, SqlDbType.Decimal).Value     = adjustRule.OutCityPuTongRate;
            cmd.Parameters.Add(_OutCityJieRiRate, SqlDbType.Decimal).Value      = adjustRule.OutCityJieRiRate;
            cmd.Parameters.Add(_OutCityShuangXiuRate, SqlDbType.Decimal).Value  = adjustRule.OutCityShuangXiuRate;
            SqlHelper.ExecuteNonQueryReturnPKID("AdjustRuleInsert", cmd, out pkid);
            return(pkid);
        }
 private void InitView(bool isPostBack)
 {
     if (!isPostBack)
     {
         AdjustRule adjustRule = _AdjustRuleFacade.GetAdjustRuleByAdjustRuleID(_View.AdjustRuleID);
         _View.Operation             = "Ð޸ĵ÷ÐݹæÔò";
         _View.Name                  = adjustRule.AdjustRuleName;
         _View.OutCityJieRiRate      = adjustRule.OutCityJieRiRate.ToString();
         _View.OutCityPuTongRate     = adjustRule.OutCityPuTongRate.ToString();
         _View.OutCityShuangXiuRate  = adjustRule.OutCityShuangXiuRate.ToString();
         _View.OverWorkJieRiRate     = adjustRule.OverWorkJieRiRate.ToString();
         _View.OverWorkPuTongRate    = adjustRule.OverWorkPuTongRate.ToString();
         _View.OverWorkShuangXiuRate = adjustRule.OverWorkShuangXiuRate.ToString();
         EmptyMessage();
     }
 }
        /// <summary>
        ///
        /// </summary>
        private static decimal GetMagnification(OverWorkItem overWorkItem, AdjustRule adjustRule)
        {
            decimal magnification = 0;

            if (overWorkItem.OverWorkType == OverWorkType.PuTong)
            {
                magnification = adjustRule.OverWorkPuTongRate;
            }
            else if (overWorkItem.OverWorkType == OverWorkType.ShuangXiu)
            {
                magnification = adjustRule.OverWorkShuangXiuRate;
            }
            else if (overWorkItem.OverWorkType == OverWorkType.JieRi)
            {
                magnification = adjustRule.OverWorkJieRiRate;
            }
            return(magnification);
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="pKID"></param>
        /// <returns></returns>
        public AdjustRule GetAdjustRuleByAdjustRuleID(int pKID)
        {
            AdjustRule adjustRule = null;
            SqlCommand cmd        = new SqlCommand();

            cmd.Parameters.Add(_PKID, SqlDbType.Int).Value = pKID;

            using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetAdjustRuleByAdjustRuleID", cmd))
            {
                while (sdr.Read())
                {
                    adjustRule =
                        new AdjustRule(Convert.ToInt32(sdr[_DbPKID]), sdr[_DbName].ToString(),
                                       Convert.ToDecimal(sdr[_DbOverWorkPuTongRate]),
                                       Convert.ToDecimal(sdr[_DbOverWorkJieRiRate]),
                                       Convert.ToDecimal(sdr[_DbOverWorkShuangXiuRate]),
                                       Convert.ToDecimal(sdr[_DbOutCityPuTongRate]),
                                       Convert.ToDecimal(sdr[_DbOutCityJieRiRate]),
                                       Convert.ToDecimal(sdr[_DbOutCityShuangXiuRate]));
                }
            }
            return(adjustRule);
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public List <AdjustRule> GetAdjustRuleByNameLike(string name)
        {
            List <AdjustRule> adjustRuleList = new List <AdjustRule>();
            SqlCommand        cmd            = new SqlCommand();

            cmd.Parameters.Add(_Name, SqlDbType.NVarChar, 200).Value = name;

            using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetAdjustRuleByNameLike", cmd))
            {
                while (sdr.Read())
                {
                    AdjustRule adjustRule =
                        new AdjustRule(Convert.ToInt32(sdr[_DbPKID]), sdr[_DbName].ToString(),
                                       Convert.ToDecimal(sdr[_DbOverWorkPuTongRate]),
                                       Convert.ToDecimal(sdr[_DbOverWorkJieRiRate]),
                                       Convert.ToDecimal(sdr[_DbOverWorkShuangXiuRate]),
                                       Convert.ToDecimal(sdr[_DbOutCityPuTongRate]),
                                       Convert.ToDecimal(sdr[_DbOutCityJieRiRate]),
                                       Convert.ToDecimal(sdr[_DbOutCityShuangXiuRate]));
                    adjustRuleList.Add(adjustRule);
                }
            }
            return(adjustRuleList);
        }
 /// <summary>
 ///
 /// </summary>
 public EditEmployeeAdjustRule(int accountid, AdjustRule rule)
 {
     _AdjustRule = rule;
     _AccountID  = accountid;
 }
Exemple #10
0
 /// <summary>
 /// test
 /// </summary>
 public UpdateAdjustRule(AdjustRule adjustRule, IAdjustRule ruledal)
 {
     _AdjustRule    = adjustRule;
     _AdjustRuleDal = ruledal;
 }
Exemple #11
0
 /// <summary>
 ///
 /// </summary>
 public UpdateAdjustRule(AdjustRule adjustRule)
 {
     _AdjustRule = adjustRule;
 }
 public void UpdateAdjustRule(AdjustRule adjustRule)
 {
     new UpdateAdjustRule(adjustRule).Excute();
 }
 public void InsertAdjustRule(AdjustRule adjustRule)
 {
     new AddAdjustRule(adjustRule).Excute();
 }
 /// <summary>
 ///
 /// </summary>
 public AddAdjustRule(AdjustRule adjustRule)
 {
     _AdjustRule = adjustRule;
 }
Exemple #15
0
 /// <summary>
 ///
 /// </summary>
 public OutCityUpdateAdjust(OutApplicationItem item, Account beAdjustAccount)
 {
     _BeAdjustAccount    = beAdjustAccount;
     _OutApplicationItem = item;
     _AdjustRule         = new GetEmployeeAdjustRule().GetAdjustRuleByAccountID(beAdjustAccount.Id);
 }
 /// <summary>
 /// test
 /// </summary>
 public AddAdjustRule(AdjustRule adjustRule, IAdjustRule ruledal)
 {
     _AdjustRule    = adjustRule;
     _AdjustRuleDal = ruledal;
 }
Exemple #17
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="overWorkItem"></param>
 /// <param name="beAdjustAccount">要调整的人</param>
 public OverWorkUpdateAdjust(OverWorkItem overWorkItem, Account beAdjustAccount)
 {
     _OverWorkItem    = overWorkItem;
     _BeAdjustAccount = beAdjustAccount;
     _AdjustRule      = new GetEmployeeAdjustRule().GetAdjustRuleByAccountID(beAdjustAccount.Id);
 }