/// <summary>
/// 更新请示单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateElevatorOrder(JC_ElevatorOrderInfo model)
{
string methodName = "UpdateElevatorOrder";
Logger.Write(this.GetType(), EnumLogLevel.Info, className + ":" + methodName + ":" + MessageType.IN + ":" + string.Format("JC_ElevatorOrderInfo={0}", model));
DataProvider db = new DataProvider();
db.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BPMConnectionString"].ConnectionString;
string sql = string.Format("Update Biz.JC_ElevatorOrder set SecurityLevel='{0}',UrgenLevel = '{1}'," +
"ReportCode = '{2}',DeptName='{3}',UserName='******',Mobile='{5}',Date='{6}',OrderType='{7}',OrderID='{8}',Url='{9}'," +
"UpdateByUserCode ='{10}',UpdateByUserName = '******',SumitTime ='{12}',ApproveStatus ='{13}', ReportTitle='{14}', Note='{15}', StartDeptCode='{16}',MaxCost={17} where FormID = '{18}'",
model.SecurityLevel, model.UrgenLevel, model.ReportCode, model.DeptName, model.UserName, model.Mobile,
model.Date, model.OrderType, model.OrderID, model.Url, model.UpdateByUserCode, model.UpdateByUserName,
model.SumitTime, model.ApproveStatus, model.ReportTitle, model.Note, model.StartDeptCode, model.MaxCost, model.FormID);
if (db.ExecuteNonQuery(sql, CommandType.Text) > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 添加请示单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InsertElevatorOrder(JC_ElevatorOrderInfo model)
{
string methodName = "InsertElevatorOrder";
Logger.Write(this.GetType(), EnumLogLevel.Info, className + ":" + methodName + ":" + MessageType.IN + ":" + string.Format("JC_ElevatorOrderInfo={0}", model));
DataProvider db = new DataProvider();
db.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BPMConnectionString"].ConnectionString;
string sql = string.Format("INSERT INTO Biz.JC_ElevatorOrder (FormID,SecurityLevel,UrgenLevel," +
"ReportCode, StartDeptCode,DeptName ,UserName,Mobile,Date,OrderType,OrderID ,Url ,Note," +
"CreateByUserCode,CreateByUserName ,CreateAtTime ,ApproveStatus,ReportTitle, UpdateByUserCode, UpdateByUserName,MaxCost) VALUES" +
"('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}',{20})", model.FormID,
model.SecurityLevel, model.UrgenLevel, model.ReportCode, model.StartDeptCode, model.DeptName, model.UserName, model.Mobile,
model.Date, model.OrderType, model.OrderID, model.Url, model.Note, model.CreateByUserCode, model.CreateByUserName,
model.CreateAtTime, model.ApproveStatus, model.ReportTitle, model.UpdateByUserCode, model.UpdateByUserName, model.MaxCost);
if (db.ExecuteNonQuery(sql, CommandType.Text) > 0)
{
return(true);
}
return(false);
}
public JC_ElevatorOrderInfo GetElevatorOrder(string FormID)
{
string methodName = "GetElevatorOrder";
Logger.Write(this.GetType(), EnumLogLevel.Info, className + ":" + methodName + ":" + MessageType.IN + ":" + string.Format("ID={0}", FormID));
DataProvider db = new DataProvider();
db.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BPMConnectionString"].ConnectionString;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@FormID", System.Data.SqlDbType.NVarChar, 100)
};
parameters[0].Value = FormID;
DataTable dt = db.ExecutedProcedure("Biz.JC_GetElevatorOrder", parameters);
JC_ElevatorOrderInfo jcInfo = new JC_ElevatorOrderInfo();
if (dt != null && dt.Rows.Count > 0)
{
jcInfo.FormID = Assign(dt.Rows[0]["FormID"]);
//TODO:此处有问题
if (dt.Rows[0]["SecurityLevel"] != null)
{
jcInfo.SecurityLevel = Convert.ToInt16(dt.Rows[0]["SecurityLevel"].ToString());
}
if (dt.Rows[0]["UrgenLevel"] != null)
{
jcInfo.UrgenLevel = Convert.ToInt16(dt.Rows[0]["UrgenLevel"].ToString());
}
jcInfo.StartDeptCode = Assign(dt.Rows[0]["StartDeptCode"]);
jcInfo.DeptName = Assign(dt.Rows[0]["DeptName"]);
jcInfo.UserName = Assign(dt.Rows[0]["UserName"]);
if (dt.Rows[0]["Date"] != null)
{
jcInfo.Date = (DateTime)dt.Rows[0]["Date"];
}
jcInfo.Mobile = Assign(dt.Rows[0]["Mobile"]);
jcInfo.ReportCode = Assign(dt.Rows[0]["ReportCode"]);
jcInfo.ReportTitle = Assign(dt.Rows[0]["ReportTitle"]);
jcInfo.Url = Assign(dt.Rows[0]["Url"]);
if (dt.Rows[0]["MaxCost"] != null && dt.Rows[0]["MaxCost"] != System.DBNull.Value)
{
jcInfo.MaxCost = Convert.ToDecimal(dt.Rows[0]["MaxCost"]);
}
jcInfo.Note = Assign(dt.Rows[0]["Note"]);
jcInfo.OrderType = Assign(dt.Rows[0]["OrderType"]);
jcInfo.OrderID = Assign(dt.Rows[0]["OrderID"]);
jcInfo.CreateByUserName = Assign(dt.Rows[0]["CreateByUserName"]);
jcInfo.CreateByUserCode = Assign(dt.Rows[0]["CreateByUserCode"]);
jcInfo.CreateAtTime = (DateTime)dt.Rows[0]["CreateAtTime"];
jcInfo.UpdateByUserCode = Assign(dt.Rows[0]["UpdateByUserCode"]);
jcInfo.UpdateByUserName = Assign(dt.Rows[0]["UpdateByUserName"]);
if (dt.Rows[0]["SumitTime"] != System.DBNull.Value)
{
jcInfo.SumitTime = (DateTime)dt.Rows[0]["SumitTime"];
}
jcInfo.ApproveStatus = Assign(dt.Rows[0]["ApproveStatus"]);
return(jcInfo);
}
return(null);
}
