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;
}
