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