Beispiel #1
0
        public bool AddObject(Doc_Info info)
        {
            int result = 0;
            if (info != null)
            {

                result = instance.Add(info);

            }
            return result > 0 ? true : false;
        }
Beispiel #2
0
        public ActionResult Add()
        {
            Doc_Info info = new Doc_Info();
            info.Doc_Code = diInstance.GenerateDocCode();
            info.Doc_Creator = SessionConfig.UserId();
            info.Doc_CreatorName = SessionConfig.UserName();
            info.Doc_DpCode = SessionConfig.DeptCode();
            info.Doc_DpName = SessionConfig.DeptName();
            info.Doc_Date = DateTime.Now;
            GetbackUrl();

            return View(info);
        }
Beispiel #3
0
 public Doc_Info GetDocModelBySupplier(string code)
 {
     Doc_Info model = new Doc_Info();
     string where = string.Format(" AND Doc_Code='{0}'",code);
     List<Doc_Info> list = instance.GetListByWhere(where);
     if (list!=null && list.Count>0)
     {
         model = list[0];
     }
     else
     {
         model = null;
     }
     return model;
 }
Beispiel #4
0
 /// <summary>
 /// 获取实体数据
 /// </summary>
 /// <param name="strCondition"></param>
 /// <returns></returns>
 public Doc_Info GetModel(string strCondition)
 {
     List<Doc_Info> list = instance.GetListByWhere(strCondition);
     Doc_Info model = new Doc_Info();
     if (list != null && list.Count > 0)
     {
         model = list[0];
     }
     else
     {
         model = null;
     }
     return model;
 }
Beispiel #5
0
 /// <summary>
 /// 更新数据
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public bool Update(Doc_Info model)
 {
     bool result = false;
     int _rseult = instance.Update(model);
     if (_rseult > 0)
     {
         result = true;
     }
     return result;
 }
Beispiel #6
0
        /// <summary>
        /// 插入数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Insert(Doc_Info model)
        {
            bool result = false;
            try
            {
                int _result = instance.Add(model);
                if (_result > 0)
                {
                    result = true;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return result;
        }
Beispiel #7
0
 public bool UpdateObject(Doc_Info doc)
 {
     if (instance.Update(doc) > 1)
     {
         return true;
     }
     return false;
 }
Beispiel #8
0
 /// <summary>
 /// 更新数据
 /// </summary>
 /// <param name='model'>实体</param>
 /// <returns>bool</returns>
 public bool Update(Doc_Info model, bool IsValid)
 {
     bool result = false;
     var e = new ModelExceptions();
     if (e.IsValid && IsValid)
     {
         int _rseult = instance.Update(model);
         if (_rseult > 0)
         {
             result = true;
         }
     }
     return result;
 }
Beispiel #9
0
 /// <summary>
 /// 插入数据
 /// </summary>
 /// <param name='model'>实体</param>
 /// <param name='model'>是否完成验证</param>
 /// <returns>bool</returns>
 public bool Insert(Doc_Info model, bool IsValid)
 {
     var e = new ModelExceptions();
     bool result = false;
     if (e.IsValid && IsValid)
     {
         //完成了验证,开始更新数据库了
         int _result = instance.Add(model);
         if (_result > 0)
         {
             result = true;
         }
     }
     return result;
 }
Beispiel #10
0
        public JsonResult DocOperation(FormCollection formCollect)
        {
            var flag = false;
            Doc_Info doc = new Doc_Info();
            bmHelper.BindFormToModel<Doc_Info>(doc, formCollect);
            string type = formCollect["optype"];
            int isback = 0;
            if (formCollect["formOper"] == "edit")
            {

                doc.UpdateTime = DateTime.Now;
                if (type == "nor")
                {
                    doc.Doc_Stat = "Draft";
                }
                else if (type == "submit")
                {
                    doc.Doc_Stat = "Normal";
                    //进入审核流程
                    doc.AuditStat = "Auditing";
                    var model = auditInstance.GetVerifyTemplateFirstNode(AuditModuleEnum.DocumentAudit.ToString());
                    if (model != null)
                    {
                        doc.AuditCurAudit = model.VT_VerifyNode_Code;
                    }
                }

                flag = diInstance.Update(doc);

                BLL.Bll_Comm.OpLog("CList_DocInfo", "DocOperation", string.Format("编辑公文:{0}", doc.Doc_Code));
            }
            else
            {
                isback = 1;
                //doc.Doc_Code = diInstance.GenerateDocCode();
                doc.Doc_Date = DateTime.Now;
                doc.CreateTime = DateTime.Now;
                doc.UpdateTime = DateTime.Now;
                if (type == "nor")
                {
                    doc.Doc_Stat = "Draft";
                }
                else
                {
                    doc.Doc_Stat = "Normal";
                    //进入审核流程
                    doc.AuditStat = "Auditing";
                    var model = auditInstance.GetVerifyTemplateFirstNode(AuditModuleEnum.DocumentAudit.ToString());
                    if (model != null)
                    {
                        doc.AuditCurAudit = model.VT_VerifyNode_Code;
                    }
                }

                flag = diInstance.AddObject(doc);

                BLL.Bll_Comm.OpLog("CList_DocInfo", "DocOperation", string.Format("添加公文:{0}", doc.Doc_Code));
                //日志记录
                //this.OpLog(this.GetControllerName(), "添加:单据类型" + puMain.PUM_RType + ",编码:" + puMain.PUM_RCode, addResult.ToString());

            }
            if (flag)
            {
                return Json(new { result = "success", isBack = isback, Msg = "数据更新成功!" }, "application/json");
            }
            else
            {
                return Json(new { result = "fail", Msg = "数据更新失败!" }, "application/json");
            }
        }
Beispiel #11
0
        /// <summary>
        /// 获取分发列表
        /// </summary>
        /// <param name="strCondition"></param>
        /// <returns></returns>
        public List<Doc_Info> GetListByWhereExtend(string strCondition)
        {
            List<Doc_Info> ret = new List<Doc_Info>();
            string sql = @"select * from (SELECT  Doc_ID,Doc_Code,Doc_Type,Doc_TypeName,Doc_No,Doc_IsBusyName
            ,Doc_IsBusy,Doc_Level,Doc_LevelName,Doc_Title
            ,Doc_Object,Doc_Cate,Doc_CateName
            ,Doc_Creator,Doc_CreatorName,Doc_DpCode
            ,Doc_DpName,Doc_MainTitle,Doc_CC,Doc_Content
            ,Doc_Date,Doc_Num,Doc_Opinion,Doc_Stat,Doc_RefDoc,di.Stat
            ,di.CreateTime,di.UpdateTime,di.DeleteTime,AuditStat,AuditCurAudit ,da.DA_Allot,da.DA_Module,da.DA_iType,(select top 1 dict_name from bse_dict where dict_key='IsHandle' and dict_code=isnull(da.DA_IsHandle,'NoHandle')) as IsHandle
            FROM Doc_Info di
            JOIN Doc_Allot da on di.Doc_Code=da.DA_DocCode and isnull(da.stat,0)=0 and isnull(di.stat,0)=0
            ) aa WHERE 1=1 ";
            if (!string.IsNullOrEmpty(strCondition))
            {
                strCondition.Replace('\'', '"'); //防sql注入
                sql += strCondition;
            }
            sql += " ORDER BY Doc_ID DESC ";
            SqlDataReader dr = null;
            try
            {
                dr = (SqlDataReader)idb.ReturnReader(sql);
                while (dr.Read())
                {
                    Doc_Info doc_Info = new Doc_Info();
                    if (dr["Doc_ID"] != DBNull.Value) doc_Info.Doc_ID = Convert.ToDecimal(dr["Doc_ID"]);
                    if (dr["Doc_Code"] != DBNull.Value) doc_Info.Doc_Code = Convert.ToString(dr["Doc_Code"]);
                    if (dr["Doc_Type"] != DBNull.Value) doc_Info.Doc_Type = Convert.ToString(dr["Doc_Type"]);
                    if (dr["Doc_TypeName"] != DBNull.Value) doc_Info.Doc_TypeName = Convert.ToString(dr["Doc_TypeName"]);
                    if (dr["Doc_No"] != DBNull.Value) doc_Info.Doc_No = Convert.ToString(dr["Doc_No"]);
                    if (dr["Doc_IsBusyName"] != DBNull.Value) doc_Info.Doc_IsBusyName = Convert.ToString(dr["Doc_IsBusyName"]);
                    if (dr["Doc_IsBusy"] != DBNull.Value) doc_Info.Doc_IsBusy = Convert.ToString(dr["Doc_IsBusy"]);
                    if (dr["Doc_Level"] != DBNull.Value) doc_Info.Doc_Level = Convert.ToString(dr["Doc_Level"]);
                    if (dr["Doc_LevelName"] != DBNull.Value) doc_Info.Doc_LevelName = Convert.ToString(dr["Doc_LevelName"]);
                    if (dr["Doc_Title"] != DBNull.Value) doc_Info.Doc_Title = Convert.ToString(dr["Doc_Title"]);
                    if (dr["Doc_Object"] != DBNull.Value) doc_Info.Doc_Object = Convert.ToString(dr["Doc_Object"]);
                    if (dr["Doc_Cate"] != DBNull.Value) doc_Info.Doc_Cate = Convert.ToString(dr["Doc_Cate"]);
                    if (dr["Doc_CateName"] != DBNull.Value) doc_Info.Doc_CateName = Convert.ToString(dr["Doc_CateName"]);
                    if (dr["Doc_Creator"] != DBNull.Value) doc_Info.Doc_Creator = Convert.ToString(dr["Doc_Creator"]);
                    if (dr["Doc_CreatorName"] != DBNull.Value) doc_Info.Doc_CreatorName = Convert.ToString(dr["Doc_CreatorName"]);
                    if (dr["Doc_DpCode"] != DBNull.Value) doc_Info.Doc_DpCode = Convert.ToString(dr["Doc_DpCode"]);
                    if (dr["Doc_DpName"] != DBNull.Value) doc_Info.Doc_DpName = Convert.ToString(dr["Doc_DpName"]);
                    if (dr["Doc_MainTitle"] != DBNull.Value) doc_Info.Doc_MainTitle = Convert.ToString(dr["Doc_MainTitle"]);
                    if (dr["Doc_CC"] != DBNull.Value) doc_Info.Doc_CC = Convert.ToString(dr["Doc_CC"]);
                    if (dr["Doc_Content"] != DBNull.Value) doc_Info.Doc_Content = Convert.ToString(dr["Doc_Content"]);
                    if (dr["Doc_Date"] != DBNull.Value) doc_Info.Doc_Date = Convert.ToDateTime(dr["Doc_Date"]);
                    if (dr["Doc_Num"] != DBNull.Value) doc_Info.Doc_Num = Convert.ToInt32(dr["Doc_Num"]);
                    if (dr["Doc_Opinion"] != DBNull.Value) doc_Info.Doc_Opinion = Convert.ToString(dr["Doc_Opinion"]);
                    if (dr["Doc_Stat"] != DBNull.Value) doc_Info.Doc_Stat = Convert.ToString(dr["Doc_Stat"]);
                    if (dr["Doc_RefDoc"] != DBNull.Value) doc_Info.Doc_RefDoc = Convert.ToString(dr["Doc_RefDoc"]);
                    if (dr["Stat"] != DBNull.Value) doc_Info.Stat = Convert.ToInt32(dr["Stat"]);
                    if (dr["CreateTime"] != DBNull.Value) doc_Info.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
                    if (dr["UpdateTime"] != DBNull.Value) doc_Info.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
                    if (dr["DeleteTime"] != DBNull.Value) doc_Info.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
                    if (dr["AuditStat"] != DBNull.Value) doc_Info.AuditStat = Convert.ToString(dr["AuditStat"]);
                    if (dr["AuditCurAudit"] != DBNull.Value) doc_Info.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]);
                    //扩展属性

                    if (dr["IsHandle"] != DBNull.Value) doc_Info.IsHandle = Convert.ToString(dr["IsHandle"]);

                    ret.Add(doc_Info);
                }
            }
            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;
        }
Beispiel #12
0
        /// <summary>
        /// 更新Doc_Info对象(即:一条记录
        /// </summary>
        public int Update(Doc_Info doc_Info)
        {
            StringBuilder sbParameter=new StringBuilder();
              StringBuilder sb=new StringBuilder();
              sb.Append(@"UPDATE       Doc_Info       SET ");
            if(doc_Info.Doc_Code_IsChanged){sbParameter.Append("Doc_Code=@Doc_Code, ");}
              if(doc_Info.Doc_Type_IsChanged){sbParameter.Append("Doc_Type=@Doc_Type, ");}
              if(doc_Info.Doc_TypeName_IsChanged){sbParameter.Append("Doc_TypeName=@Doc_TypeName, ");}
              if(doc_Info.Doc_No_IsChanged){sbParameter.Append("Doc_No=@Doc_No, ");}
              if(doc_Info.Doc_IsBusyName_IsChanged){sbParameter.Append("Doc_IsBusyName=@Doc_IsBusyName, ");}
              if(doc_Info.Doc_IsBusy_IsChanged){sbParameter.Append("Doc_IsBusy=@Doc_IsBusy, ");}
              if(doc_Info.Doc_Level_IsChanged){sbParameter.Append("Doc_Level=@Doc_Level, ");}
              if(doc_Info.Doc_LevelName_IsChanged){sbParameter.Append("Doc_LevelName=@Doc_LevelName, ");}
              if(doc_Info.Doc_Title_IsChanged){sbParameter.Append("Doc_Title=@Doc_Title, ");}
              if(doc_Info.Doc_Object_IsChanged){sbParameter.Append("Doc_Object=@Doc_Object, ");}
              if(doc_Info.Doc_Cate_IsChanged){sbParameter.Append("Doc_Cate=@Doc_Cate, ");}
              if(doc_Info.Doc_CateName_IsChanged){sbParameter.Append("Doc_CateName=@Doc_CateName, ");}
              if(doc_Info.Doc_Creator_IsChanged){sbParameter.Append("Doc_Creator=@Doc_Creator, ");}
              if(doc_Info.Doc_CreatorName_IsChanged){sbParameter.Append("Doc_CreatorName=@Doc_CreatorName, ");}
              if(doc_Info.Doc_DpCode_IsChanged){sbParameter.Append("Doc_DpCode=@Doc_DpCode, ");}
              if(doc_Info.Doc_DpName_IsChanged){sbParameter.Append("Doc_DpName=@Doc_DpName, ");}
              if(doc_Info.Doc_MainTitle_IsChanged){sbParameter.Append("Doc_MainTitle=@Doc_MainTitle, ");}
              if(doc_Info.Doc_CC_IsChanged){sbParameter.Append("Doc_CC=@Doc_CC, ");}
              if(doc_Info.Doc_Content_IsChanged){sbParameter.Append("Doc_Content=@Doc_Content, ");}
              if(doc_Info.Doc_Date_IsChanged){sbParameter.Append("Doc_Date=@Doc_Date, ");}
              if(doc_Info.Doc_Num_IsChanged){sbParameter.Append("Doc_Num=@Doc_Num, ");}
              if(doc_Info.Doc_Opinion_IsChanged){sbParameter.Append("Doc_Opinion=@Doc_Opinion, ");}
              if(doc_Info.Doc_Stat_IsChanged){sbParameter.Append("Doc_Stat=@Doc_Stat, ");}
              if(doc_Info.Doc_RefDoc_IsChanged){sbParameter.Append("Doc_RefDoc=@Doc_RefDoc, ");}
              if(doc_Info.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");}
              if(doc_Info.CreateTime_IsChanged){sbParameter.Append("CreateTime=@CreateTime, ");}
              if(doc_Info.UpdateTime_IsChanged){sbParameter.Append("UpdateTime=@UpdateTime, ");}
              if(doc_Info.DeleteTime_IsChanged){sbParameter.Append("DeleteTime=@DeleteTime, ");}
              if(doc_Info.AuditStat_IsChanged){sbParameter.Append("AuditStat=@AuditStat, ");}
              if(doc_Info.AuditCurAudit_IsChanged){sbParameter.Append("AuditCurAudit=@AuditCurAudit ");}
          sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
              sb.Append(      " WHERE 1=1 AND ((Stat is null) or (Stat=0))   and Doc_ID=@Doc_ID; " );
              string sql=sb.ToString();
             if(doc_Info.Doc_Code_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_Code))
             {
            idb.AddParameter("@Doc_Code", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Code", doc_Info.Doc_Code);
             }
              }
             if(doc_Info.Doc_Type_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_Type))
             {
            idb.AddParameter("@Doc_Type", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Type", doc_Info.Doc_Type);
             }
              }
             if(doc_Info.Doc_TypeName_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_TypeName))
             {
            idb.AddParameter("@Doc_TypeName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_TypeName", doc_Info.Doc_TypeName);
             }
              }
             if(doc_Info.Doc_No_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_No))
             {
            idb.AddParameter("@Doc_No", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_No", doc_Info.Doc_No);
             }
              }
             if(doc_Info.Doc_IsBusyName_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_IsBusyName))
             {
            idb.AddParameter("@Doc_IsBusyName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_IsBusyName", doc_Info.Doc_IsBusyName);
             }
              }
             if(doc_Info.Doc_IsBusy_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_IsBusy))
             {
            idb.AddParameter("@Doc_IsBusy", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_IsBusy", doc_Info.Doc_IsBusy);
             }
              }
             if(doc_Info.Doc_Level_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_Level))
             {
            idb.AddParameter("@Doc_Level", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Level", doc_Info.Doc_Level);
             }
              }
             if(doc_Info.Doc_LevelName_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_LevelName))
             {
            idb.AddParameter("@Doc_LevelName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_LevelName", doc_Info.Doc_LevelName);
             }
              }
             if(doc_Info.Doc_Title_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_Title))
             {
            idb.AddParameter("@Doc_Title", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Title", doc_Info.Doc_Title);
             }
              }
             if(doc_Info.Doc_Object_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_Object))
             {
            idb.AddParameter("@Doc_Object", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Object", doc_Info.Doc_Object);
             }
              }
             if(doc_Info.Doc_Cate_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_Cate))
             {
            idb.AddParameter("@Doc_Cate", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Cate", doc_Info.Doc_Cate);
             }
              }
             if(doc_Info.Doc_CateName_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_CateName))
             {
            idb.AddParameter("@Doc_CateName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_CateName", doc_Info.Doc_CateName);
             }
              }
             if(doc_Info.Doc_Creator_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_Creator))
             {
            idb.AddParameter("@Doc_Creator", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Creator", doc_Info.Doc_Creator);
             }
              }
             if(doc_Info.Doc_CreatorName_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_CreatorName))
             {
            idb.AddParameter("@Doc_CreatorName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_CreatorName", doc_Info.Doc_CreatorName);
             }
              }
             if(doc_Info.Doc_DpCode_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_DpCode))
             {
            idb.AddParameter("@Doc_DpCode", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_DpCode", doc_Info.Doc_DpCode);
             }
              }
             if(doc_Info.Doc_DpName_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_DpName))
             {
            idb.AddParameter("@Doc_DpName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_DpName", doc_Info.Doc_DpName);
             }
              }
             if(doc_Info.Doc_MainTitle_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_MainTitle))
             {
            idb.AddParameter("@Doc_MainTitle", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_MainTitle", doc_Info.Doc_MainTitle);
             }
              }
             if(doc_Info.Doc_CC_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_CC))
             {
            idb.AddParameter("@Doc_CC", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_CC", doc_Info.Doc_CC);
             }
              }
             if(doc_Info.Doc_Content_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_Content))
             {
            idb.AddParameter("@Doc_Content", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Content", doc_Info.Doc_Content);
             }
              }
             if(doc_Info.Doc_Date_IsChanged)
             {
             if (doc_Info.Doc_Date == DateTime.MinValue)
             {
            idb.AddParameter("@Doc_Date", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Date", doc_Info.Doc_Date);
             }
              }
             if(doc_Info.Doc_Num_IsChanged)
             {
             if (doc_Info.Doc_Num == 0)
             {
            idb.AddParameter("@Doc_Num", 0);
             }
             else
             {
            idb.AddParameter("@Doc_Num", doc_Info.Doc_Num);
             }
              }
             if(doc_Info.Doc_Opinion_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_Opinion))
             {
            idb.AddParameter("@Doc_Opinion", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Opinion", doc_Info.Doc_Opinion);
             }
              }
             if(doc_Info.Doc_Stat_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_Stat))
             {
            idb.AddParameter("@Doc_Stat", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Stat", doc_Info.Doc_Stat);
             }
              }
             if(doc_Info.Doc_RefDoc_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.Doc_RefDoc))
             {
            idb.AddParameter("@Doc_RefDoc", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_RefDoc", doc_Info.Doc_RefDoc);
             }
              }
             if(doc_Info.Stat_IsChanged)
             {
             if (doc_Info.Stat == 0)
             {
            idb.AddParameter("@Stat", 0);
             }
             else
             {
            idb.AddParameter("@Stat", doc_Info.Stat);
             }
              }
             if(doc_Info.CreateTime_IsChanged)
             {
             if (doc_Info.CreateTime == DateTime.MinValue)
             {
            idb.AddParameter("@CreateTime", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@CreateTime", doc_Info.CreateTime);
             }
              }
             if(doc_Info.UpdateTime_IsChanged)
             {
             if (doc_Info.UpdateTime == DateTime.MinValue)
             {
            idb.AddParameter("@UpdateTime", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@UpdateTime", doc_Info.UpdateTime);
             }
              }
             if(doc_Info.DeleteTime_IsChanged)
             {
             if (doc_Info.DeleteTime == DateTime.MinValue)
             {
            idb.AddParameter("@DeleteTime", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DeleteTime", doc_Info.DeleteTime);
             }
              }
             if(doc_Info.AuditStat_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.AuditStat))
             {
            idb.AddParameter("@AuditStat", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@AuditStat", doc_Info.AuditStat);
             }
              }
             if(doc_Info.AuditCurAudit_IsChanged)
             {
             if (string.IsNullOrEmpty(doc_Info.AuditCurAudit))
             {
            idb.AddParameter("@AuditCurAudit", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@AuditCurAudit", doc_Info.AuditCurAudit);
             }
              }

             idb.AddParameter("@Doc_ID", doc_Info.Doc_ID);

             return idb.ExeCmd(sql);
Beispiel #13
0
 /// <summary>
 /// 获取指定的Doc_Info对象集合
 /// </summary>
 public List<Doc_Info> GetListByWhere(string strCondition)
 {
     List<Doc_Info> ret = new List<Doc_Info>();
      string sql = "SELECT  Doc_ID,Doc_Code,Doc_Type,Doc_TypeName,Doc_No,Doc_IsBusyName,Doc_IsBusy,Doc_Level,Doc_LevelName,Doc_Title,Doc_Object,Doc_Cate,Doc_CateName,Doc_Creator,Doc_CreatorName,Doc_DpCode,Doc_DpName,Doc_MainTitle,Doc_CC,Doc_Content,Doc_Date,Doc_Num,Doc_Opinion,Doc_Stat,Doc_RefDoc,Stat,CreateTime,UpdateTime,DeleteTime,AuditStat,AuditCurAudit FROM Doc_Info WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
      if(!string.IsNullOrEmpty(strCondition))
      {
     strCondition.Replace('\'','"'); //防sql注入
     sql += strCondition ;
      }
       sql += " ORDER BY Doc_ID DESC ";
       SqlDataReader dr=null;
        try {
       dr=(SqlDataReader)idb.ReturnReader(sql);
      while(dr.Read())
      {
     Doc_Info doc_Info = new Doc_Info();
     if (dr["Doc_ID"] != DBNull.Value) doc_Info.Doc_ID = Convert.ToDecimal(dr["Doc_ID"]);
     if (dr["Doc_Code"] != DBNull.Value) doc_Info.Doc_Code = Convert.ToString(dr["Doc_Code"]);
     if (dr["Doc_Type"] != DBNull.Value) doc_Info.Doc_Type = Convert.ToString(dr["Doc_Type"]);
     if (dr["Doc_TypeName"] != DBNull.Value) doc_Info.Doc_TypeName = Convert.ToString(dr["Doc_TypeName"]);
     if (dr["Doc_No"] != DBNull.Value) doc_Info.Doc_No = Convert.ToString(dr["Doc_No"]);
     if (dr["Doc_IsBusyName"] != DBNull.Value) doc_Info.Doc_IsBusyName = Convert.ToString(dr["Doc_IsBusyName"]);
     if (dr["Doc_IsBusy"] != DBNull.Value) doc_Info.Doc_IsBusy = Convert.ToString(dr["Doc_IsBusy"]);
     if (dr["Doc_Level"] != DBNull.Value) doc_Info.Doc_Level = Convert.ToString(dr["Doc_Level"]);
     if (dr["Doc_LevelName"] != DBNull.Value) doc_Info.Doc_LevelName = Convert.ToString(dr["Doc_LevelName"]);
     if (dr["Doc_Title"] != DBNull.Value) doc_Info.Doc_Title = Convert.ToString(dr["Doc_Title"]);
     if (dr["Doc_Object"] != DBNull.Value) doc_Info.Doc_Object = Convert.ToString(dr["Doc_Object"]);
     if (dr["Doc_Cate"] != DBNull.Value) doc_Info.Doc_Cate = Convert.ToString(dr["Doc_Cate"]);
     if (dr["Doc_CateName"] != DBNull.Value) doc_Info.Doc_CateName = Convert.ToString(dr["Doc_CateName"]);
     if (dr["Doc_Creator"] != DBNull.Value) doc_Info.Doc_Creator = Convert.ToString(dr["Doc_Creator"]);
     if (dr["Doc_CreatorName"] != DBNull.Value) doc_Info.Doc_CreatorName = Convert.ToString(dr["Doc_CreatorName"]);
     if (dr["Doc_DpCode"] != DBNull.Value) doc_Info.Doc_DpCode = Convert.ToString(dr["Doc_DpCode"]);
     if (dr["Doc_DpName"] != DBNull.Value) doc_Info.Doc_DpName = Convert.ToString(dr["Doc_DpName"]);
     if (dr["Doc_MainTitle"] != DBNull.Value) doc_Info.Doc_MainTitle = Convert.ToString(dr["Doc_MainTitle"]);
     if (dr["Doc_CC"] != DBNull.Value) doc_Info.Doc_CC = Convert.ToString(dr["Doc_CC"]);
     if (dr["Doc_Content"] != DBNull.Value) doc_Info.Doc_Content = Convert.ToString(dr["Doc_Content"]);
     if (dr["Doc_Date"] != DBNull.Value) doc_Info.Doc_Date = Convert.ToDateTime(dr["Doc_Date"]);
     if (dr["Doc_Num"] != DBNull.Value) doc_Info.Doc_Num = Convert.ToInt32(dr["Doc_Num"]);
     if (dr["Doc_Opinion"] != DBNull.Value) doc_Info.Doc_Opinion = Convert.ToString(dr["Doc_Opinion"]);
     if (dr["Doc_Stat"] != DBNull.Value) doc_Info.Doc_Stat = Convert.ToString(dr["Doc_Stat"]);
     if (dr["Doc_RefDoc"] != DBNull.Value) doc_Info.Doc_RefDoc = Convert.ToString(dr["Doc_RefDoc"]);
     if (dr["Stat"] != DBNull.Value) doc_Info.Stat = Convert.ToInt32(dr["Stat"]);
     if (dr["CreateTime"] != DBNull.Value) doc_Info.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
     if (dr["UpdateTime"] != DBNull.Value) doc_Info.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
     if (dr["DeleteTime"] != DBNull.Value) doc_Info.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
     if (dr["AuditStat"] != DBNull.Value) doc_Info.AuditStat = Convert.ToString(dr["AuditStat"]);
     if (dr["AuditCurAudit"] != DBNull.Value) doc_Info.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]);
     ret.Add(doc_Info);
      }
       }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;
 }
Beispiel #14
0
        /// <summary>
        /// 获取指定的Doc_Info对象(即:一条记录
        /// </summary>
        public Doc_Info GetByKey(decimal doc_ID)
        {
            Doc_Info doc_Info = new Doc_Info();
             string sql = "SELECT  Doc_ID,Doc_Code,Doc_Type,Doc_TypeName,Doc_No,Doc_IsBusyName,Doc_IsBusy,Doc_Level,Doc_LevelName,Doc_Title,Doc_Object,Doc_Cate,Doc_CateName,Doc_Creator,Doc_CreatorName,Doc_DpCode,Doc_DpName,Doc_MainTitle,Doc_CC,Doc_Content,Doc_Date,Doc_Num,Doc_Opinion,Doc_Stat,Doc_RefDoc,Stat,CreateTime,UpdateTime,DeleteTime,AuditStat,AuditCurAudit FROM Doc_Info WHERE 1=1 AND ((Stat is null) or (Stat=0) )  AND Doc_ID=@Doc_ID ";
             idb.AddParameter("@Doc_ID", doc_ID);

              SqlDataReader dr=null;
               try {
              dr=(SqlDataReader)idb.ReturnReader(sql);
             while(dr.Read())
             {
            if (dr["Doc_ID"] != DBNull.Value) doc_Info.Doc_ID = Convert.ToDecimal(dr["Doc_ID"]);
            if (dr["Doc_Code"] != DBNull.Value) doc_Info.Doc_Code = Convert.ToString(dr["Doc_Code"]);
            if (dr["Doc_Type"] != DBNull.Value) doc_Info.Doc_Type = Convert.ToString(dr["Doc_Type"]);
            if (dr["Doc_TypeName"] != DBNull.Value) doc_Info.Doc_TypeName = Convert.ToString(dr["Doc_TypeName"]);
            if (dr["Doc_No"] != DBNull.Value) doc_Info.Doc_No = Convert.ToString(dr["Doc_No"]);
            if (dr["Doc_IsBusyName"] != DBNull.Value) doc_Info.Doc_IsBusyName = Convert.ToString(dr["Doc_IsBusyName"]);
            if (dr["Doc_IsBusy"] != DBNull.Value) doc_Info.Doc_IsBusy = Convert.ToString(dr["Doc_IsBusy"]);
            if (dr["Doc_Level"] != DBNull.Value) doc_Info.Doc_Level = Convert.ToString(dr["Doc_Level"]);
            if (dr["Doc_LevelName"] != DBNull.Value) doc_Info.Doc_LevelName = Convert.ToString(dr["Doc_LevelName"]);
            if (dr["Doc_Title"] != DBNull.Value) doc_Info.Doc_Title = Convert.ToString(dr["Doc_Title"]);
            if (dr["Doc_Object"] != DBNull.Value) doc_Info.Doc_Object = Convert.ToString(dr["Doc_Object"]);
            if (dr["Doc_Cate"] != DBNull.Value) doc_Info.Doc_Cate = Convert.ToString(dr["Doc_Cate"]);
            if (dr["Doc_CateName"] != DBNull.Value) doc_Info.Doc_CateName = Convert.ToString(dr["Doc_CateName"]);
            if (dr["Doc_Creator"] != DBNull.Value) doc_Info.Doc_Creator = Convert.ToString(dr["Doc_Creator"]);
            if (dr["Doc_CreatorName"] != DBNull.Value) doc_Info.Doc_CreatorName = Convert.ToString(dr["Doc_CreatorName"]);
            if (dr["Doc_DpCode"] != DBNull.Value) doc_Info.Doc_DpCode = Convert.ToString(dr["Doc_DpCode"]);
            if (dr["Doc_DpName"] != DBNull.Value) doc_Info.Doc_DpName = Convert.ToString(dr["Doc_DpName"]);
            if (dr["Doc_MainTitle"] != DBNull.Value) doc_Info.Doc_MainTitle = Convert.ToString(dr["Doc_MainTitle"]);
            if (dr["Doc_CC"] != DBNull.Value) doc_Info.Doc_CC = Convert.ToString(dr["Doc_CC"]);
            if (dr["Doc_Content"] != DBNull.Value) doc_Info.Doc_Content = Convert.ToString(dr["Doc_Content"]);
            if (dr["Doc_Date"] != DBNull.Value) doc_Info.Doc_Date = Convert.ToDateTime(dr["Doc_Date"]);
            if (dr["Doc_Num"] != DBNull.Value) doc_Info.Doc_Num = Convert.ToInt32(dr["Doc_Num"]);
            if (dr["Doc_Opinion"] != DBNull.Value) doc_Info.Doc_Opinion = Convert.ToString(dr["Doc_Opinion"]);
            if (dr["Doc_Stat"] != DBNull.Value) doc_Info.Doc_Stat = Convert.ToString(dr["Doc_Stat"]);
            if (dr["Doc_RefDoc"] != DBNull.Value) doc_Info.Doc_RefDoc = Convert.ToString(dr["Doc_RefDoc"]);
            if (dr["Stat"] != DBNull.Value) doc_Info.Stat = Convert.ToInt32(dr["Stat"]);
            if (dr["CreateTime"] != DBNull.Value) doc_Info.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
            if (dr["UpdateTime"] != DBNull.Value) doc_Info.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
            if (dr["DeleteTime"] != DBNull.Value) doc_Info.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
            if (dr["AuditStat"] != DBNull.Value) doc_Info.AuditStat = Convert.ToString(dr["AuditStat"]);
            if (dr["AuditCurAudit"] != DBNull.Value) doc_Info.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]);
             }
              }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 doc_Info;
        }
Beispiel #15
0
        /// <summary>
        /// 添加Doc_Info对象(即:一条记录)
        /// </summary>
        public object AddWithReturn(Doc_Info doc_Info)
        {
            string sql = "INSERT INTO Doc_Info (Doc_Code,Doc_Type,Doc_TypeName,Doc_No,Doc_IsBusyName,Doc_IsBusy,Doc_Level,Doc_LevelName,Doc_Title,Doc_Object,Doc_Cate,Doc_CateName,Doc_Creator,Doc_CreatorName,Doc_DpCode,Doc_DpName,Doc_MainTitle,Doc_CC,Doc_Content,Doc_Date,Doc_Num,Doc_Opinion,Doc_Stat,Doc_RefDoc,Stat,CreateTime,UpdateTime,DeleteTime,AuditStat,AuditCurAudit) VALUES (@Doc_Code,@Doc_Type,@Doc_TypeName,@Doc_No,@Doc_IsBusyName,@Doc_IsBusy,@Doc_Level,@Doc_LevelName,@Doc_Title,@Doc_Object,@Doc_Cate,@Doc_CateName,@Doc_Creator,@Doc_CreatorName,@Doc_DpCode,@Doc_DpName,@Doc_MainTitle,@Doc_CC,@Doc_Content,@Doc_Date,@Doc_Num,@Doc_Opinion,@Doc_Stat,@Doc_RefDoc,@Stat,@CreateTime,@UpdateTime,@DeleteTime,@AuditStat,@AuditCurAudit);SELECT @@IDENTITY AS ReturnID;";
             if (string.IsNullOrEmpty(doc_Info.Doc_Code))
             {
            idb.AddParameter("@Doc_Code", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Code", doc_Info.Doc_Code);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_Type))
             {
            idb.AddParameter("@Doc_Type", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Type", doc_Info.Doc_Type);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_TypeName))
             {
            idb.AddParameter("@Doc_TypeName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_TypeName", doc_Info.Doc_TypeName);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_No))
             {
            idb.AddParameter("@Doc_No", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_No", doc_Info.Doc_No);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_IsBusyName))
             {
            idb.AddParameter("@Doc_IsBusyName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_IsBusyName", doc_Info.Doc_IsBusyName);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_IsBusy))
             {
            idb.AddParameter("@Doc_IsBusy", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_IsBusy", doc_Info.Doc_IsBusy);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_Level))
             {
            idb.AddParameter("@Doc_Level", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Level", doc_Info.Doc_Level);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_LevelName))
             {
            idb.AddParameter("@Doc_LevelName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_LevelName", doc_Info.Doc_LevelName);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_Title))
             {
            idb.AddParameter("@Doc_Title", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Title", doc_Info.Doc_Title);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_Object))
             {
            idb.AddParameter("@Doc_Object", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Object", doc_Info.Doc_Object);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_Cate))
             {
            idb.AddParameter("@Doc_Cate", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Cate", doc_Info.Doc_Cate);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_CateName))
             {
            idb.AddParameter("@Doc_CateName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_CateName", doc_Info.Doc_CateName);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_Creator))
             {
            idb.AddParameter("@Doc_Creator", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Creator", doc_Info.Doc_Creator);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_CreatorName))
             {
            idb.AddParameter("@Doc_CreatorName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_CreatorName", doc_Info.Doc_CreatorName);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_DpCode))
             {
            idb.AddParameter("@Doc_DpCode", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_DpCode", doc_Info.Doc_DpCode);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_DpName))
             {
            idb.AddParameter("@Doc_DpName", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_DpName", doc_Info.Doc_DpName);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_MainTitle))
             {
            idb.AddParameter("@Doc_MainTitle", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_MainTitle", doc_Info.Doc_MainTitle);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_CC))
             {
            idb.AddParameter("@Doc_CC", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_CC", doc_Info.Doc_CC);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_Content))
             {
            idb.AddParameter("@Doc_Content", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Content", doc_Info.Doc_Content);
             }
             if (doc_Info.Doc_Date == DateTime.MinValue)
             {
            idb.AddParameter("@Doc_Date", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Date", doc_Info.Doc_Date);
             }
             if (doc_Info.Doc_Num == 0)
             {
            idb.AddParameter("@Doc_Num", 0);
             }
             else
             {
            idb.AddParameter("@Doc_Num", doc_Info.Doc_Num);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_Opinion))
             {
            idb.AddParameter("@Doc_Opinion", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Opinion", doc_Info.Doc_Opinion);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_Stat))
             {
            idb.AddParameter("@Doc_Stat", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_Stat", doc_Info.Doc_Stat);
             }
             if (string.IsNullOrEmpty(doc_Info.Doc_RefDoc))
             {
            idb.AddParameter("@Doc_RefDoc", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@Doc_RefDoc", doc_Info.Doc_RefDoc);
             }
             if (doc_Info.Stat == 0)
             {
            idb.AddParameter("@Stat", 0);
             }
             else
             {
            idb.AddParameter("@Stat", doc_Info.Stat);
             }
             if (doc_Info.CreateTime == DateTime.MinValue)
             {
            idb.AddParameter("@CreateTime", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@CreateTime", doc_Info.CreateTime);
             }
             if (doc_Info.UpdateTime == DateTime.MinValue)
             {
            idb.AddParameter("@UpdateTime", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@UpdateTime", doc_Info.UpdateTime);
             }
             if (doc_Info.DeleteTime == DateTime.MinValue)
             {
            idb.AddParameter("@DeleteTime", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@DeleteTime", doc_Info.DeleteTime);
             }
             if (string.IsNullOrEmpty(doc_Info.AuditStat))
             {
            idb.AddParameter("@AuditStat", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@AuditStat", doc_Info.AuditStat);
             }
             if (string.IsNullOrEmpty(doc_Info.AuditCurAudit))
             {
            idb.AddParameter("@AuditCurAudit", DBNull.Value);
             }
             else
             {
            idb.AddParameter("@AuditCurAudit", doc_Info.AuditCurAudit);
             }

             return idb.ReturnValue(sql);
        }