/// <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; }
/// <summary> /// test /// </summary> public UpdateAdjustRule(AdjustRule adjustRule, IAdjustRule ruledal) { _AdjustRule = adjustRule; _AdjustRuleDal = ruledal; }
/// <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; }
/// <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; }
/// <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); }