private void checkDocUploadfiles(Doc_Info NewData, Doc_Info OldData) { if (OldData == null) { OldData = new Doc_Info(); } string Prefix = string.Empty; Prefix = "DocPic"; if (sessionData.trading.UploadFiles.Keys.Contains(Prefix)) { if (string.Compare("DELETE", sessionData.trading.UploadFiles[Prefix], true) == 0) { NewData.pic = string.Empty; } else { NewData.pic = CopyFile(sessionData.trading.UploadFiles[Prefix]); } } else { NewData.pic = OldData.pic; } }
public int Update(int DocId, Doc_Info data, List <string> columns) { using (var db = new DBExecutor().GetDatabase()) { return(db.Update(data, DocId, columns)); } }
public int Update(Doc_Info data) { using (var db = new DBExecutor().GetDatabase()) { return(db.Update(data)); } }
public bool UpdateObject(Doc_Info doc) { if (instance.Update(doc) > 1) { return(true); } return(false); }
public bool AddObject(Doc_Info info) { int result = 0; if (info != null) { result = instance.Add(info); } return(result > 0 ? true : false); }
public ActionResult Delete(string id) { Doc_Info doc = diInstance.GetModel(string.Format("AND Doc_Code='{0}'", id)); doc.Stat = 1; diInstance.UpdateObject(doc); BLL.Bll_Comm.OpLog("CListDoc_Info", "Doc_Info", string.Format("删除公文:{0}", id)); return(Json(new { result = "success", message = "成功" }, "text/json")); }
/// <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); }
/// <summary> /// 更新数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Update(Doc_Info model) { bool result = false; var e = new ModelExceptions(); int _rseult = instance.Update(model); if (_rseult > 0) { result = true; } return(result); }
public int Insert(Doc_Info data) { using (var db = new DBExecutor().GetDatabase()) { int NewID = 0; var result = db.Insert(data); if (result != null) { int.TryParse(result.ToString(), out NewID); } return(NewID); } }
public int Insert(Doc_Info data) { int newID = 0; try { newID = new Doc_Repo().Insert(data); } catch (Exception ex) { log.Exception(ex); } return(newID); }
/// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</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); }
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)); }
/// <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); }
/// <summary> /// 逻辑删除数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Delete(string Code) { bool result = false; List <Doc_Info> list = instance.GetListByWhere(" AND Menu_Code='" + Code + "'"); if (list.Count > 0) { Doc_Info model = list[0]; //model.Stat = 1; int _rseult = instance.Update(model); if (_rseult > 0) { result = true; } } return(result); }
/// <summary> /// 逻辑删除数据 /// </summary> /// <param name='model'>model</param> /// <returns>bool</returns> public bool Delete(string Condition) { bool result = false; List <Doc_Info> list = instance.GetListByWhere(Condition); if (list.Count > 0) { Doc_Info model = list[0]; model.Stat = 1; int _rseult = instance.Update(model); if (_rseult > 0) { result = true; } } return(result); }
/// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</returns> public Doc_Info GetModels(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); }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</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); }
public JsonResult SaveDoc(Doc_Info data) { if (data.conf_date == DateTime.MinValue) { DateTime newdt = DateTime.MinValue; DateTime.TryParse("1974/01/01", out newdt); data.conf_date = newdt; } //data.DeptName = getDeptName(sessionData.trading.Dept.Value); ResultBase result = new ResultBase(); result.setMessage("Done"); if (data.IsActive == 1) { //審核專用 var verdata = DocMan.GetBySN(data.DocId); verdata.IsActive = 1; verdata.VerifiedDate = DateTime.Now; DocMan.Update(verdata); return(Json(result, JsonRequestBehavior.DenyGet)); } else { //一但有任何異動,自動下架 data.IsActive = 0; } if (string.IsNullOrEmpty(data.DeptName) || data.DeptName.StartsWith("請選擇")) { result.setErrorMessage("門診類別為必選"); } if (string.IsNullOrEmpty(data.CostName) || data.CostName.StartsWith("請選擇")) { result.setErrorMessage("科別為必選"); } if (string.IsNullOrEmpty(data.DocName)) { result.setErrorMessage("醫師中文名字不得為空白"); } if (string.IsNullOrEmpty(data.DocCode)) { result.setErrorMessage("醫師員編不得為空白"); } if (string.IsNullOrEmpty(data.MainMajor1)) { result.setErrorMessage("主治項目不得為空白"); } if (string.IsNullOrEmpty(data.school)) { result.setErrorMessage("學歷不得為空白"); } if (string.IsNullOrEmpty(data.career)) { result.setErrorMessage("經歷不得為空白"); } if (string.IsNullOrEmpty(data.ncareer)) { result.setErrorMessage("現職不得為空白"); } if (string.IsNullOrEmpty(data.school)) { result.setErrorMessage("學歷不得為空白"); } if (string.IsNullOrEmpty(data.otime)) { //result.setErrorMessage("門診時段不得為空白"); } if (result.JsonReturnCode > -1) { data.Dept = data.DeptName; data.DeptName = getDeptName(EnumHelper.GetEnumByName <WS_Dept_type>(data.Dept)); data.Cost = sessionData.trading.CostId; data.LastUpdate = DateTime.Now; data.LastUpdator = sessionData.trading.LoginId; var olddata = DocMan.GetBySN(data.DocId); checkDocUploadfiles(data, olddata); if (string.IsNullOrEmpty(data.pic)) { result.setErrorMessage("醫師照片必需上傳"); } else { if (data.DocId > 0) { DocMan.Update(data); } else { DocMan.Insert(data); } } } return(Json(result, JsonRequestBehavior.DenyGet)); }
/// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</returns> public Doc_Info GetModel(int id) { Doc_Info model = instance.GetByKey(id); return(model); }
/// <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); }
public bool Update(int DocId, Doc_Info data, List <string> columns) { return(new Doc_Repo().Update(DocId, data, columns) > 0); }
public bool Update(Doc_Info data) { return(new Doc_Repo().Update(data) > 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")); } }