public HttpResponseMessage Get(int id) { string errMsg = ""; Model.Bill bill = BLL.BillManager.GetBillById(id, out errMsg); HttpStatusCode status; string json; //errMsg = "网络繁忙,请稍稍再度"; if (errMsg.Length > 0) { status = (HttpStatusCode)422; var msg = new { errors = new { ServerSideError = errMsg } }; json = JsonConvert.SerializeObject(msg); } else { status = HttpStatusCode.OK; var msg2 = new { bill = bill }; json = JsonConvert.SerializeObject(msg2); } return(new HttpResponseMessage(status) { Content = new StringContent(json, System.Text.Encoding.GetEncoding("UTF-8"), "application/json") }); }
private bool tryPut(ref Model.Bill model, out string errMsg) { errMsg = ""; bool re = false; model.Modifier = this.auth.UserId; model.ModifiedDate = DateTime.Now; if (BillManager.ModifyBillById(ref model, out errMsg)) { re = true; } return(re); }
/// <summary> /// 根据id修改加油单 /// </summary> /// <param name="Model.Bill"></param> /// <returns></returns> public static bool ModifyBillById(ref Model.Bill model, out string errMsg) { errMsg = ""; try { model.DriverName = model.DriverName.Trim(); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Id", model.Id), new SqlParameter("@Project", model.Project), new SqlParameter("@Department", model.Department), new SqlParameter("@Oil", model.Oil), new SqlParameter("@Volume", model.Volume), new SqlParameter("@Mileage", model.Mileage), new SqlParameter("@DriverName", model.DriverName), new SqlParameter("@Rate", model.Rate), new SqlParameter("@Time", model.Time), new SqlParameter("@Modifier", model.Modifier), new SqlParameter("@ModifiedDate", model.ModifiedDate) }; int i = DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, "proc_BillByIdUpdate", para); if (i > 0) { EventLog e = new EventLog(); e.TargetIds = model.Id.ToString(); e.CodeTag = "ModifyBillById"; e.LogName = "修改加油单"; EventLogService.AddEventLog <Model.Bill>(e, model); return(true); } else { errMsg = "该记录已被删除,不能修改!"; return(false); } } catch (Exception ex) { errMsg = ex.Message; ErrorLog e = new ErrorLog(); e.TargetIds = model.Id.ToString(); e.CodeTag = "ModifyBillById"; e.LogName = "修改加油单"; e.ErrorMsg = ex.Message.ToString(); ErrorLogService.AddErrorLog <Model.Bill>(e, model); return(false); } }
/// <summary> /// 根据id修改加油单 /// </summary> /// <param name="Model.Bill"></param> /// <returns></returns> public static bool ModifyBillById(ref Model.Bill model, out string errMsg) { return(BillService.ModifyBillById(ref model, out errMsg)); }
/// <summary> /// 获取单个加油单 /// </summary> /// <param name="id"></param> /// <param name="errMsg"></param> /// <returns></returns> public static Model.Bill GetBillById(int id, out string errMsg) { errMsg = ""; try { string sql = ""; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Id", id) }; sql = "select * from [Bill] where Id = @Id"; DataTable dt = DBHelper.ExecuteGetDataTable(CommandType.Text, sql, para); Model.Bill bill = null; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; bill = new Bill(); bill.Id = (int)dr["Id"]; bill.Car = (int)dr["Car"]; bill.Instance = (int)dr["Instance"]; bill.Project = (int)dr["Project"]; bill.Department = (int)dr["Department"]; bill.Oil = (int)dr["Oil"]; bill.Volume = double.Parse(dr["Volume"].ToString()); bill.Mileage = double.Parse(dr["Mileage"].ToString()); bill.DriverName = (string)dr["DriverName"]; if (DBNull.Value.Equals(dr["Signature"])) { bill.Signature = null; } else { bill.Signature = new int?((int)dr["Signature"]); } if (DBNull.Value.Equals(dr["PreviousOil"])) { bill.PreviousOil = null; } else { bill.PreviousOil = new int?((int)dr["PreviousOil"]); } bill.Rate = double.Parse(dr["Rate"].ToString()); bill.Oiler = (int)dr["Oiler"]; bill.Time = (DateTime)dr["Time"]; bill.IsLost = (bool)dr["IsLost"]; bill.IsPrinted = (bool)dr["IsPrinted"]; bill.Creater = (int)dr["Creater"]; bill.CreatedDate = (DateTime)dr["CreatedDate"]; bill.Modifier = (int)dr["Modifier"]; bill.ModifiedDate = (DateTime)dr["ModifiedDate"]; } else { errMsg = "该加油单不存在或已被删除"; } return(bill); } catch (Exception ex) { errMsg = ex.Message; return(null); } }
/// <summary> /// 获取指定申请单车辆上一次加油单 /// </summary> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <param name="errMsg"></param> /// <returns></returns> public static IList <Model.Bill> GetLastOneBillByCar(int id, int car, out string errMsg) { errMsg = ""; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Id", id), new SqlParameter("@Car", car) }; string sql = "select top 1 * from [Bill] where Id < @Id and Car = @Car order by Id desc"; DataTable dt = DBHelper.ExecuteGetDataTable(CommandType.Text, sql, para); IList <Model.Bill> listBills = new List <Model.Bill>(); foreach (DataRow dr in dt.Rows) { Model.Bill bill = new Model.Bill(); bill.Id = (int)dr["Id"]; bill.Car = (int)dr["Car"]; bill.Instance = (int)dr["Instance"]; bill.Project = (int)dr["Project"]; bill.Department = (int)dr["Department"]; bill.Oil = (int)dr["Oil"]; bill.Volume = double.Parse(dr["Volume"].ToString()); bill.Mileage = double.Parse(dr["Mileage"].ToString()); bill.DriverName = (string)dr["DriverName"]; if (DBNull.Value.Equals(dr["Signature"])) { bill.Signature = null; } else { bill.Signature = new int?((int)dr["Signature"]); } if (DBNull.Value.Equals(dr["PreviousOil"])) { bill.PreviousOil = null; } else { bill.PreviousOil = new int?((int)dr["PreviousOil"]); } bill.Rate = double.Parse(dr["Rate"].ToString()); bill.Oiler = (int)dr["Oiler"]; bill.Time = (DateTime)dr["Time"]; bill.IsLost = (bool)dr["IsLost"]; bill.IsPrinted = (bool)dr["IsPrinted"]; bill.Creater = (int)dr["Creater"]; bill.CreatedDate = (DateTime)dr["CreatedDate"]; bill.Modifier = (int)dr["Modifier"]; bill.ModifiedDate = (DateTime)dr["ModifiedDate"]; listBills.Add(bill); } return(listBills); } catch (Exception ex) { errMsg = ex.Message; return(null); } }
/// <summary> /// 获取加油单列表 /// </summary> /// <param name="count">要返回的记录个数</param> /// <param name="billsFilter">筛选参数</param> /// <param name="lastId">最后(小)id值</param> /// <param name="errMsg">错误信息</param> /// <returns></returns> public static IList <Model.Bill> GetBills( int?count, BillsFilter billsFilter, out string errMsg) { errMsg = ""; try { string sql = ""; SqlParameter[] para = null; List <SqlParameter> listPara = new List <SqlParameter>(); if (count == null) { count = 20; } listPara.Add(new SqlParameter("@Count", count)); string where = ""; IList <string> listWhere = new List <string>(); if (billsFilter.LastId > 0) { listPara.Add(new SqlParameter("@LastId", billsFilter.LastId)); listWhere.Add("Id > @LastId"); } if (billsFilter != null && billsFilter.Project > 0) { listPara.Add(new SqlParameter("@Project", billsFilter.Project)); listWhere.Add("Project = @Project"); } if (billsFilter != null && billsFilter.Department > 0) { listPara.Add(new SqlParameter("@Department", billsFilter.Department)); listWhere.Add("Department = @Department"); } if (billsFilter != null) { listPara.Add(new SqlParameter("@StartDate", billsFilter.StartDate)); listPara.Add(new SqlParameter("@EndDate", billsFilter.EndDate)); listWhere.Add("Time between @StartDate and @EndDate"); } para = listPara.ToArray(); if (listWhere.Count > 0) { where += "where "; where += String.Join(" and ", listWhere.ToArray()); } sql = string.Format("select top (@Count) * from [Bill] {0} order by Id asc", where); DataTable dt = DBHelper.ExecuteGetDataTable(CommandType.Text, sql, para); IList <Model.Bill> listBills = new List <Model.Bill>(); foreach (DataRow dr in dt.Rows) { Model.Bill bill = new Model.Bill(); bill.Id = (int)dr["Id"]; bill.Car = (int)dr["Car"]; bill.Instance = (int)dr["Instance"]; bill.Project = (int)dr["Project"]; bill.Department = (int)dr["Department"]; bill.Oil = (int)dr["Oil"]; bill.Volume = double.Parse(dr["Volume"].ToString()); bill.Mileage = double.Parse(dr["Mileage"].ToString()); bill.DriverName = (string)dr["DriverName"]; if (DBNull.Value.Equals(dr["Signature"])) { bill.Signature = null; } else { bill.Signature = new int?((int)dr["Signature"]); } if (DBNull.Value.Equals(dr["PreviousOil"])) { bill.PreviousOil = null; } else { bill.PreviousOil = new int?((int)dr["PreviousOil"]); } bill.Rate = double.Parse(dr["Rate"].ToString()); bill.Oiler = (int)dr["Oiler"]; bill.Time = (DateTime)dr["Time"]; bill.IsLost = (bool)dr["IsLost"]; bill.IsPrinted = (bool)dr["IsPrinted"]; bill.Creater = (int)dr["Creater"]; bill.CreatedDate = (DateTime)dr["CreatedDate"]; bill.Modifier = (int)dr["Modifier"]; bill.ModifiedDate = (DateTime)dr["ModifiedDate"]; listBills.Add(bill); } return(listBills); } catch (Exception ex) { errMsg = ex.Message; return(null); } }
public void CopyFrom(Bill bill) { DateOwed = FromDate(bill.DateOwed); Name = bill.Name; TotalOwed = bill.TotalOwed; }