public int UpdateStayRate(StayRateModel mStayRate) { string sql = "UPDATE STAY_RATE SET STAY_RATE=" + mStayRate.StayRate; sql += " WHERE ID=" + mStayRate.Id; return ExcuteNonQuery(sql); }
public int InsertStayRate(StayRateModel mStayRate) { STAY_RATE sr = new STAY_RATE() { DAYS = mStayRate.Days, STAY_RATE1 = mStayRate.StayRate }; dc.STAY_RATE.InsertOnSubmit(sr); dc.SubmitChanges(); return sr.ID; }
private void pbtnSearch_Click(object sender, EventArgs e) { try { StayRateModel mStayRate = new StayRateModel(); mStayRate.CommonInfo = new CommonModel(); mStayRate.CommonInfo.StartDate = GetDateTimePickValue(dtpStart, null); mStayRate.CommonInfo.EndDate = GetDateTimePickValue(dtpEnd, null); dgvStayRate.AutoGenerateColumns = false; List<StayRateModel> listStayRate = bStayInfo.GetStayRate(mStayRate, new ObjectControls(MCtrl.ByStartDateBetween)); dgvStayRate.Rows.Clear(); if (cmn.CheckEOF(listStayRate)) { int i = 0; double dTotal = 0.0; foreach (StayRateModel msr in listStayRate) { dgvStayRate.Rows.Add(); dgvStayRate.Rows[i].Cells["ID"].Value = msr.Id; dgvStayRate.Rows[i].Cells["StayRate"].Value = msr.StayRate + "%"; dgvStayRate.Rows[i].Cells["Days"].Value = msr.Days.ToString("yyyy-MM-dd"); dTotal += msr.StayRate; i++; } dTotal = Math.Round(dTotal / listStayRate.Count, 2); dgvStayRate.Rows.Add(); dgvStayRate.Rows[i].Cells["Days"].Value = "平均入住率"; dgvStayRate.Rows[i].Cells["StayRate"].Value = dTotal + "%"; } } catch (Exception err) { cmn.Show(err.Message); } }
public List<StayRateModel> GetStayRate(StayRateModel mStayRate, ObjectControls oCtrl) { string sql = "SELECT A.ID,A.STAY_RATE,A.DAYS FROM STAY_RATE A WHERE 1=1 "; oCtrl.Helper(oCtrl.Exsit(MCtrl.ById) && oCtrl.Append(ref sql, " AND A.ID=" + SQL(mStayRate.Id))); oCtrl.Helper(oCtrl.Exsit(MCtrl.ByCreateDate) && oCtrl.Append(ref sql, " AND A.DAYS=" + SQL(mStayRate.Days))); oCtrl.Helper(oCtrl.Exsit(MCtrl.ByStartDateBetween) && oCtrl.Append(ref sql, " AND A.DAYS BETWEEN " + SQL(mStayRate.CommonInfo.StartDate) + " AND " + SQL(mStayRate.CommonInfo.EndDate))); sql += " ORDER BY A.DAYS"; sdr=ExecuteReader(sql); using (sdr) { List<StayRateModel> listStayRate = new List<StayRateModel>(); while (sdr.Read()) { StayRateModel mStayRateNew = new StayRateModel(); mStayRateNew.Id = ToInt32(sdr["ID"]); mStayRateNew.StayRate = ToDouble(sdr["STAY_RATE"]); mStayRateNew.Days = ToDateTime(sdr["DAYS"]); listStayRate.Add(mStayRateNew); } return listStayRate; } }
private void tmAutoSetStayRate_Tick(object sender, EventArgs e) { StayRateModel mStayRate = new StayRateModel(); mStayRate.StayRate = double.Parse(lblUseRate.Text.Replace("%", "")); mStayRate.Days = cmn.DateBaseDate.Date; hml.DoStayRate(mStayRate); }
public void DoStayRate(StayRateModel mStayRate) { List<StayRateModel> listStayRate = bStayRate.GetStayRate(mStayRate, new ObjectControls(MCtrl.ByCreateDate)); if (Cmn.CheckEOF(listStayRate)) { listStayRate[0].StayRate = mStayRate.StayRate; bStayRate.UpdateStayRate(listStayRate[0]); } else { bStayRate.InsertStayRate(mStayRate); } }
public int UpdateStayRate(StayRateModel mStayRate) { return dStayRate.UpdateStayRate(mStayRate); }
public int InsertStayRate(StayRateModel mStayRate) { return dStayRate.InsertStayRate(mStayRate); }
public List<StayRateModel> GetStayRate(StayRateModel mStayRate, ObjectControls oCtrl) { return dStayRate.GetStayRate(mStayRate, oCtrl); }