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