public InstructionOfEToIInfo Get(string FormID)
{
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@FormID", System.Data.SqlDbType.NVarChar, 100)
};
parameters[0].Value = FormID;
DataTable dt = DBHelper.ExecutedProcedure("Biz.OA_InstructionOfEToI_Get", parameters);
InstructionOfEToIInfo Info = new InstructionOfEToIInfo();
if (dt != null && dt.Rows.Count > 0)
{
Info.FormID = Assign(dt.Rows[0]["FormID"]);
Info.SecurityLevel = Assign(dt.Rows[0]["SecurityLevel"]);
Info.UrgenLevel = Assign(dt.Rows[0]["UrgenLevel"]);
Info.DeptName = Assign(dt.Rows[0]["DeptName"]);
Info.DeptCode = Assign(dt.Rows[0]["DeptCode"]);
Info.UserName = Assign(dt.Rows[0]["UserName"]);
Info.Mobile = Assign(dt.Rows[0]["Mobile"]);
Info.DateTime = Assign(dt.Rows[0]["DateTime"]);
Info.Title = Assign(dt.Rows[0]["Title"]);
Info.Content = Assign(dt.Rows[0]["Content"]);
Info.LeadersSelected = Assign(dt.Rows[0]["LeadersSelected"]);
Info.IsReport = Assign(dt.Rows[0]["IsReport"]);
Info.IsApproval = Assign(dt.Rows[0]["IsApproval"]);
return(Info);
}
return(null);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(InstructionOfEToIInfo model)
{
string sql = string.Format("Update Biz.OA_InstructionOfEToI set SecurityLevel='{0}',UrgenLevel = '{1}',DeptName = '{2}',DeptCode='{3}'," +
"UserName='******',Mobile='{5}',DateTime='{6}',Title='{7}',Content='{8}',LeadersSelected='{9}',IsReport='{10}',IsApproval = '{11}' where FormID = '{12}'",
model.SecurityLevel, model.UrgenLevel, model.DeptName, model.DeptCode, model.UserName, model.Mobile, model.DateTime,
model.Title, model.Content, model.LeadersSelected, model.IsReport, model.IsApproval, model.FormID);
return(DBHelper.ExecuteNonQuery(sql));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Insert(InstructionOfEToIInfo model)
{
string sql = string.Format("INSERT INTO Biz.OA_InstructionOfEToI (FormID,SecurityLevel,UrgenLevel,DeptName ,DeptCode,UserName," +
"Mobile, DateTime,Title,Content,LeadersSelected,IsReport, IsApproval) VALUES" +
"('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}')", model.FormID,
model.SecurityLevel, model.UrgenLevel, model.DeptName, model.DeptCode, model.UserName, model.Mobile,
model.DateTime, model.Title, model.Content, model.LeadersSelected, model.IsReport, model.IsApproval);
return(DBHelper.ExecuteNonQuery(sql));
}
