public HttpResponseMessage Get(int id)
{
string errMsg = "";
Model.Instance instance = BLL.InstanceManager.GetInstanceById(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
{
instance = instance
};
json = JsonConvert.SerializeObject(msg2);
}
return(new HttpResponseMessage(status)
{
Content = new StringContent(json, System.Text.Encoding.GetEncoding("UTF-8"), "application/json")
});
}
/// <summary>
/// 获取单个申请单
/// </summary>
/// <param name="id"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public static Model.Instance GetInstanceById(int id, out string errMsg)
{
errMsg = "";
try
{
string sql = "";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Id", id)
};
sql = "select * from [Instance] where Id = @Id";
DataTable dt = DBHelper.ExecuteGetDataTable(CommandType.Text, sql, para);
Model.Instance instance = null;
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
instance = new Instance();
instance.Id = (int)dr["Id"];
instance.Car = (int)dr["Car"];
instance.Project = (int)dr["Project"];
instance.Department = (int)dr["Department"];
instance.UserName = (string)dr["UserName"];
if (!DBNull.Value.Equals(dr["Oils"]))
{
string oilsStr = (string)dr["Oils"];
string[] oilsArrayTemp = oilsStr.Split(new char[]
{
','
});
int[] oilsArray = Array.ConvertAll <string, int>(oilsArrayTemp, (string s) => int.Parse(s));
instance.Oils = oilsArray.ToList <int>();
}
instance.Goal = (string)dr["Goal"];
instance.StartDate = (DateTime)dr["StartDate"];
instance.EndDate = (DateTime)dr["EndDate"];
instance.IsReleased = (bool)dr["IsReleased"];
instance.IsPending = (bool)dr["IsPending"];
instance.IsArchived = (bool)dr["IsArchived"];
instance.IsEnable = (bool)dr["IsEnable"];
//if (DBNull.Value.Equals(dr["Message"]))
//{
// instance.Message = null;
//}
//else
//{
// instance.Message = new int?((int)dr["Message"]);
//}
instance.BillCount = (int)dr["BillCount"];
instance.Creater = (int)dr["Creater"];
instance.CreatedDate = (DateTime)dr["CreatedDate"];
instance.Modifier = (int)dr["Modifier"];
instance.ModifiedDate = (DateTime)dr["ModifiedDate"];
}
else
{
errMsg = "该申请单不存在或已被删除";
}
return(instance);
}
catch (Exception ex)
{
errMsg = ex.Message;
return(null);
}
}
