public ActionResult Add()
{
Bse_Message info = new Bse_Message();
info.Msg_Code = mInstance.GenerateMsgCode();
GetbackUrl();
return(View(info));
}
public bool Add(Bse_Message model)
{
if (mInstance.Add(model) > 0)
{
return(true);
}
return(false);
}
public bool Update(Bse_Message model)
{
model.UpdateTime = DateTime.Now;
if (mInstance.Update(model) > 0)
{
return(true);
}
return(false);
}
public JsonResult FileOperation(FormCollection formCollect)
{
var flag = false;
Bse_Message doc = new Bse_Message();
bmHelper.BindFormToModel <Bse_Message>(doc, formCollect);
string type = formCollect["optype"];
if (formCollect["formOper"] == "edit")
{
doc.UpdateTime = DateTime.Now;
if (type == "nor")
{
doc.Msg_Stat = "Draft";
}
else
{
doc.Msg_Stat = "Normal";
////进入审核流程
//doc.AuditStat = "Auditing";
//var model = auditInstance.GetVerifyTemplateFirstNode(AuditModuleEnum.ComFileAudit.ToString());
//if (model != null)
//{
// doc.AuditCurAudit = model.VT_VerifyNode_Code;
//}
}
flag = mInstance.Update(doc);
}
else
{
doc.CreateTime = DateTime.Now;
doc.UpdateTime = DateTime.Now;
if (type == "nor")
{
doc.Msg_Stat = "Draft";
}
else
{
doc.Msg_Stat = "Normal";
////进入审核流程
//doc.AuditStat = "Auditing";
//var model = auditInstance.GetVerifyTemplateFirstNode(AuditModuleEnum.DocumentAudit.ToString());
//if (model != null)
//{
// doc.AuditCurAudit = model.VT_VerifyNode_Code;
//}
}
flag = mInstance.Add(doc);
//日志记录
//this.OpLog(this.GetControllerName(), "添加:单据类型" + puMain.PUM_RType + ",编码:" + puMain.PUM_RCode, addResult.ToString());
}
if (flag)
{
return(new JsonResult {
Data = new { result = "success", Msg = "数据更新成功！" }
});
}
else
{
return(new JsonResult {
Data = new { result = "fail", Msg = "数据更新失败！" }
});
}
}
/// <summary>
/// 获取所有的Bse_Message对象(即:一条记录
/// </summary>
public List <Bse_Message> GetAll()
{
List <Bse_Message> ret = new List <Bse_Message>();
string sql = "SELECT Msg_ID,Msg_Code,Msg_Content,Msg_iType,Msg_Type,Msg_Stat,Msg_IsShow,Msg_IsShowName,Msg_TypeName,Stat,CreateTime,UpdateTime,DeleteTime FROM Bse_Message where 1=1 AND ((Stat is null) or (Stat=0) ) order by Msg_ID desc ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Bse_Message bse_Message = new Bse_Message();
if (dr["Msg_ID"] != DBNull.Value)
{
bse_Message.Msg_ID = Convert.ToDecimal(dr["Msg_ID"]);
}
if (dr["Msg_Code"] != DBNull.Value)
{
bse_Message.Msg_Code = Convert.ToString(dr["Msg_Code"]);
}
if (dr["Msg_Content"] != DBNull.Value)
{
bse_Message.Msg_Content = Convert.ToString(dr["Msg_Content"]);
}
if (dr["Msg_iType"] != DBNull.Value)
{
bse_Message.Msg_iType = Convert.ToString(dr["Msg_iType"]);
}
if (dr["Msg_Type"] != DBNull.Value)
{
bse_Message.Msg_Type = Convert.ToString(dr["Msg_Type"]);
}
if (dr["Msg_Stat"] != DBNull.Value)
{
bse_Message.Msg_Stat = Convert.ToString(dr["Msg_Stat"]);
}
if (dr["Msg_IsShow"] != DBNull.Value)
{
bse_Message.Msg_IsShow = Convert.ToString(dr["Msg_IsShow"]);
}
if (dr["Msg_IsShowName"] != DBNull.Value)
{
bse_Message.Msg_IsShowName = Convert.ToString(dr["Msg_IsShowName"]);
}
if (dr["Msg_TypeName"] != DBNull.Value)
{
bse_Message.Msg_TypeName = Convert.ToString(dr["Msg_TypeName"]);
}
if (dr["Stat"] != DBNull.Value)
{
bse_Message.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["CreateTime"] != DBNull.Value)
{
bse_Message.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
}
if (dr["UpdateTime"] != DBNull.Value)
{
bse_Message.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
}
if (dr["DeleteTime"] != DBNull.Value)
{
bse_Message.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
}
ret.Add(bse_Message);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
/// <summary>
/// 获取指定的Bse_Message对象集合
/// </summary>
public List <Bse_Message> GetListByWhere(string strCondition)
{
List <Bse_Message> ret = new List <Bse_Message>();
string sql = "SELECT Msg_ID,Msg_Code,Msg_Content,Msg_iType,Msg_Type,Msg_Stat,Msg_IsShow,Msg_IsShowName,Msg_TypeName,Stat,CreateTime,UpdateTime,DeleteTime FROM Bse_Message WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if (!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'', '"'); //防sql注入
sql += strCondition;
}
sql += " ORDER BY Msg_ID DESC ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Bse_Message bse_Message = new Bse_Message();
if (dr["Msg_ID"] != DBNull.Value)
{
bse_Message.Msg_ID = Convert.ToDecimal(dr["Msg_ID"]);
}
if (dr["Msg_Code"] != DBNull.Value)
{
bse_Message.Msg_Code = Convert.ToString(dr["Msg_Code"]);
}
if (dr["Msg_Content"] != DBNull.Value)
{
bse_Message.Msg_Content = Convert.ToString(dr["Msg_Content"]);
}
if (dr["Msg_iType"] != DBNull.Value)
{
bse_Message.Msg_iType = Convert.ToString(dr["Msg_iType"]);
}
if (dr["Msg_Type"] != DBNull.Value)
{
bse_Message.Msg_Type = Convert.ToString(dr["Msg_Type"]);
}
if (dr["Msg_Stat"] != DBNull.Value)
{
bse_Message.Msg_Stat = Convert.ToString(dr["Msg_Stat"]);
}
if (dr["Msg_IsShow"] != DBNull.Value)
{
bse_Message.Msg_IsShow = Convert.ToString(dr["Msg_IsShow"]);
}
if (dr["Msg_IsShowName"] != DBNull.Value)
{
bse_Message.Msg_IsShowName = Convert.ToString(dr["Msg_IsShowName"]);
}
if (dr["Msg_TypeName"] != DBNull.Value)
{
bse_Message.Msg_TypeName = Convert.ToString(dr["Msg_TypeName"]);
}
if (dr["Stat"] != DBNull.Value)
{
bse_Message.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["CreateTime"] != DBNull.Value)
{
bse_Message.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
}
if (dr["UpdateTime"] != DBNull.Value)
{
bse_Message.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
}
if (dr["DeleteTime"] != DBNull.Value)
{
bse_Message.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
}
ret.Add(bse_Message);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
/// <summary>
/// 获取指定的Bse_Message对象(即:一条记录
/// </summary>
public Bse_Message GetByKey(decimal msg_ID)
{
Bse_Message bse_Message = new Bse_Message();
string sql = "SELECT Msg_ID,Msg_Code,Msg_Content,Msg_iType,Msg_Type,Msg_Stat,Msg_IsShow,Msg_IsShowName,Msg_TypeName,Stat,CreateTime,UpdateTime,DeleteTime FROM Bse_Message WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND Msg_ID=@Msg_ID ";
idb.AddParameter("@Msg_ID", msg_ID);
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
if (dr["Msg_ID"] != DBNull.Value)
{
bse_Message.Msg_ID = Convert.ToDecimal(dr["Msg_ID"]);
}
if (dr["Msg_Code"] != DBNull.Value)
{
bse_Message.Msg_Code = Convert.ToString(dr["Msg_Code"]);
}
if (dr["Msg_Content"] != DBNull.Value)
{
bse_Message.Msg_Content = Convert.ToString(dr["Msg_Content"]);
}
if (dr["Msg_iType"] != DBNull.Value)
{
bse_Message.Msg_iType = Convert.ToString(dr["Msg_iType"]);
}
if (dr["Msg_Type"] != DBNull.Value)
{
bse_Message.Msg_Type = Convert.ToString(dr["Msg_Type"]);
}
if (dr["Msg_Stat"] != DBNull.Value)
{
bse_Message.Msg_Stat = Convert.ToString(dr["Msg_Stat"]);
}
if (dr["Msg_IsShow"] != DBNull.Value)
{
bse_Message.Msg_IsShow = Convert.ToString(dr["Msg_IsShow"]);
}
if (dr["Msg_IsShowName"] != DBNull.Value)
{
bse_Message.Msg_IsShowName = Convert.ToString(dr["Msg_IsShowName"]);
}
if (dr["Msg_TypeName"] != DBNull.Value)
{
bse_Message.Msg_TypeName = Convert.ToString(dr["Msg_TypeName"]);
}
if (dr["Stat"] != DBNull.Value)
{
bse_Message.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["CreateTime"] != DBNull.Value)
{
bse_Message.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
}
if (dr["UpdateTime"] != DBNull.Value)
{
bse_Message.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
}
if (dr["DeleteTime"] != DBNull.Value)
{
bse_Message.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
}
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(bse_Message);
}
/// <summary>
/// 更新Bse_Message对象(即:一条记录
/// </summary>
public int Update(Bse_Message bse_Message)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Bse_Message SET ");
if (bse_Message.Msg_Code_IsChanged)
{
sbParameter.Append("Msg_Code=@Msg_Code, ");
}
if (bse_Message.Msg_Content_IsChanged)
{
sbParameter.Append("Msg_Content=@Msg_Content, ");
}
if (bse_Message.Msg_iType_IsChanged)
{
sbParameter.Append("Msg_iType=@Msg_iType, ");
}
if (bse_Message.Msg_Type_IsChanged)
{
sbParameter.Append("Msg_Type=@Msg_Type, ");
}
if (bse_Message.Msg_Stat_IsChanged)
{
sbParameter.Append("Msg_Stat=@Msg_Stat, ");
}
if (bse_Message.Msg_IsShow_IsChanged)
{
sbParameter.Append("Msg_IsShow=@Msg_IsShow, ");
}
if (bse_Message.Msg_IsShowName_IsChanged)
{
sbParameter.Append("Msg_IsShowName=@Msg_IsShowName, ");
}
if (bse_Message.Msg_TypeName_IsChanged)
{
sbParameter.Append("Msg_TypeName=@Msg_TypeName, ");
}
if (bse_Message.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (bse_Message.CreateTime_IsChanged)
{
sbParameter.Append("CreateTime=@CreateTime, ");
}
if (bse_Message.UpdateTime_IsChanged)
{
sbParameter.Append("UpdateTime=@UpdateTime, ");
}
if (bse_Message.DeleteTime_IsChanged)
{
sbParameter.Append("DeleteTime=@DeleteTime ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and Msg_ID=@Msg_ID; ");
string sql = sb.ToString();
if (bse_Message.Msg_Code_IsChanged)
{
if (string.IsNullOrEmpty(bse_Message.Msg_Code))
{
idb.AddParameter("@Msg_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_Code", bse_Message.Msg_Code);
}
}
if (bse_Message.Msg_Content_IsChanged)
{
if (string.IsNullOrEmpty(bse_Message.Msg_Content))
{
idb.AddParameter("@Msg_Content", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_Content", bse_Message.Msg_Content);
}
}
if (bse_Message.Msg_iType_IsChanged)
{
if (string.IsNullOrEmpty(bse_Message.Msg_iType))
{
idb.AddParameter("@Msg_iType", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_iType", bse_Message.Msg_iType);
}
}
if (bse_Message.Msg_Type_IsChanged)
{
if (string.IsNullOrEmpty(bse_Message.Msg_Type))
{
idb.AddParameter("@Msg_Type", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_Type", bse_Message.Msg_Type);
}
}
if (bse_Message.Msg_Stat_IsChanged)
{
if (string.IsNullOrEmpty(bse_Message.Msg_Stat))
{
idb.AddParameter("@Msg_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_Stat", bse_Message.Msg_Stat);
}
}
if (bse_Message.Msg_IsShow_IsChanged)
{
if (string.IsNullOrEmpty(bse_Message.Msg_IsShow))
{
idb.AddParameter("@Msg_IsShow", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_IsShow", bse_Message.Msg_IsShow);
}
}
if (bse_Message.Msg_IsShowName_IsChanged)
{
if (string.IsNullOrEmpty(bse_Message.Msg_IsShowName))
{
idb.AddParameter("@Msg_IsShowName", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_IsShowName", bse_Message.Msg_IsShowName);
}
}
if (bse_Message.Msg_TypeName_IsChanged)
{
if (string.IsNullOrEmpty(bse_Message.Msg_TypeName))
{
idb.AddParameter("@Msg_TypeName", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_TypeName", bse_Message.Msg_TypeName);
}
}
if (bse_Message.Stat_IsChanged)
{
if (bse_Message.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_Message.Stat);
}
}
if (bse_Message.CreateTime_IsChanged)
{
if (bse_Message.CreateTime == DateTime.MinValue)
{
idb.AddParameter("@CreateTime", DBNull.Value);
}
else
{
idb.AddParameter("@CreateTime", bse_Message.CreateTime);
}
}
if (bse_Message.UpdateTime_IsChanged)
{
if (bse_Message.UpdateTime == DateTime.MinValue)
{
idb.AddParameter("@UpdateTime", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateTime", bse_Message.UpdateTime);
}
}
if (bse_Message.DeleteTime_IsChanged)
{
if (bse_Message.DeleteTime == DateTime.MinValue)
{
idb.AddParameter("@DeleteTime", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteTime", bse_Message.DeleteTime);
}
}
idb.AddParameter("@Msg_ID", bse_Message.Msg_ID);
return(idb.ExeCmd(sql));
}
/// <summary>
/// 添加Bse_Message对象(即:一条记录)
/// </summary>
public int Add(Bse_Message bse_Message)
{
string sql = "INSERT INTO Bse_Message (Msg_Code,Msg_Content,Msg_iType,Msg_Type,Msg_Stat,Msg_IsShow,Msg_IsShowName,Msg_TypeName,Stat,CreateTime,UpdateTime,DeleteTime) VALUES (@Msg_Code,@Msg_Content,@Msg_iType,@Msg_Type,@Msg_Stat,@Msg_IsShow,@Msg_IsShowName,@Msg_TypeName,@Stat,@CreateTime,@UpdateTime,@DeleteTime)";
if (string.IsNullOrEmpty(bse_Message.Msg_Code))
{
idb.AddParameter("@Msg_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_Code", bse_Message.Msg_Code);
}
if (string.IsNullOrEmpty(bse_Message.Msg_Content))
{
idb.AddParameter("@Msg_Content", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_Content", bse_Message.Msg_Content);
}
if (string.IsNullOrEmpty(bse_Message.Msg_iType))
{
idb.AddParameter("@Msg_iType", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_iType", bse_Message.Msg_iType);
}
if (string.IsNullOrEmpty(bse_Message.Msg_Type))
{
idb.AddParameter("@Msg_Type", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_Type", bse_Message.Msg_Type);
}
if (string.IsNullOrEmpty(bse_Message.Msg_Stat))
{
idb.AddParameter("@Msg_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_Stat", bse_Message.Msg_Stat);
}
if (string.IsNullOrEmpty(bse_Message.Msg_IsShow))
{
idb.AddParameter("@Msg_IsShow", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_IsShow", bse_Message.Msg_IsShow);
}
if (string.IsNullOrEmpty(bse_Message.Msg_IsShowName))
{
idb.AddParameter("@Msg_IsShowName", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_IsShowName", bse_Message.Msg_IsShowName);
}
if (string.IsNullOrEmpty(bse_Message.Msg_TypeName))
{
idb.AddParameter("@Msg_TypeName", DBNull.Value);
}
else
{
idb.AddParameter("@Msg_TypeName", bse_Message.Msg_TypeName);
}
if (bse_Message.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_Message.Stat);
}
if (bse_Message.CreateTime == DateTime.MinValue)
{
idb.AddParameter("@CreateTime", DBNull.Value);
}
else
{
idb.AddParameter("@CreateTime", bse_Message.CreateTime);
}
if (bse_Message.UpdateTime == DateTime.MinValue)
{
idb.AddParameter("@UpdateTime", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateTime", bse_Message.UpdateTime);
}
if (bse_Message.DeleteTime == DateTime.MinValue)
{
idb.AddParameter("@DeleteTime", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteTime", bse_Message.DeleteTime);
}
return(idb.ExeCmd(sql));
}
