public static string GetStandard(string strValue)
{
TSysDictVo objtd = new TSysDictVo();
objtd.DICT_TYPE = "STANDARD_TYPE";
objtd.DICT_CODE = strValue;
objtd = new TSysDictLogic().Details(objtd);
return(objtd.DICT_TEXT);
}
/// <summary>
/// 加载数据
/// </summary>
/// <returns></returns>
public string frmLoadData()
{
TSysDictVo TSysDictVo = new TSysDictVo();
TSysDictVo.PARENT_CODE = Request["PARENT_CODE"].ToString();
DataTable dt = new TSysDictLogic().SelectByTable(TSysDictVo);
return(DataTableToJson(dt));
}
/// <summary>
/// 获得标准类型
/// </summary>
/// <returns></returns>
public string getStandardInfo()
{
TSysDictVo objtd = new TSysDictVo();
objtd.DICT_TYPE = "STANDARD_TYPE";
DataTable dt = new TSysDictLogic().SelectByTable(objtd);
return(DataTableToJson(dt));
}
/// <summary>
/// 获取部门
/// </summary>
/// <returns></returns>
protected string getDept()
{
List <TSysDictVo> objDict = new TSysDictLogic().GetDataDictListByType("dept");
objDict.Insert(0, new TSysDictVo()
{
DICT_TEXT = "所有", DICT_CODE = ""
});
return(ToJson(objDict));
}
public static List <object> GetDeptItems()
{
List <object> listResult = new List <object>();
DataTable dt = new DataTable();
TSysDictVo objVo = new TSysDictVo();
objVo.DICT_TYPE = "dept";
dt = new TSysDictLogic().SelectByTable(objVo);
listResult = LigerGridSelectDataToJson(dt, dt.Rows.Count);
return(listResult);
}
public static List <object> GetMonitorValue()
{
List <object> reslut = new List <object>();
DataTable dtSt = new DataTable();
TSysDictVo objtd = new TSysDictVo();
objtd.DICT_TYPE = "MONITOR_VALUE_TYPE";
dtSt = new TSysDictLogic().SelectByTable(objtd);
reslut = LigerGridSelectDataToJson(dtSt, dtSt.Rows.Count);
//reslut = gridDataToJson(dtSt, dtSt.Rows.Count, objtd);
return(reslut);
}
public static List <object> GetOpreator()
{
List <object> reslut = new List <object>();
DataTable dtSt = new DataTable();
TSysDictVo objtd = new TSysDictVo();
objtd.DICT_TYPE = "logic_operator";
dtSt = new TSysDictLogic().SelectByTable(objtd);
reslut = LigerGridSelectDataToJson(dtSt, dtSt.Rows.Count);
//reslut = gridDataToJson(dtSt, dtSt.Rows.Count, objtd);
return(reslut);
}
public static string GetDict(string strType, string strCode)
{
if (!string.IsNullOrEmpty(strCode))
{
TSysDictVo objtd = new TSysDictVo();
objtd.DICT_TYPE = strType;
objtd.DICT_CODE = strCode;
objtd = new TSysDictLogic().Details(objtd);
return(objtd.DICT_TEXT);
}
return("");
}
public static string sortData(string strValue)
{
bool isSuccess = new TSysDictLogic().updateByTransaction(strValue);
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
/// <summary>
/// 获取字典项下拉控件Json数据
/// </summary>
/// <returns></returns>
protected string GetDictJsonForSearch()
{
//字典项类型
string strDictType = Request.QueryString["dict_type"];
List <TSysDictVo> listDict = new TSysDictLogic().GetAutoLoadDataListByType(strDictType);
//插入全部
listDict.Insert(0, new TSysDictVo()
{
DICT_TEXT = "全部", DICT_CODE = ""
});
return(ToJson(listDict));
}
public static string deleteData(string strValue)
{
bool isSuccess = new TSysDictLogic().deleteByTransaction(strValue);
if (isSuccess)
{
new PageBase().WriteLog("删除字典项数据", "", new UserLogInfo().UserInfo.USER_NAME + "删除字典项数据" + strValue);
return("1");
}
else
{
return("0");
}
}
/// <summary>
/// 获取字典项数据
/// </summary>
/// <returns></returns>
protected string getDictInfo()
{
TSysDictVo TSysDictVo = new TSysDictVo();
//如果不是系统超级管理员登陆，则显示部分字典项
if (new PageBase().LogInfo.UserInfo.ID != "000000001")
{
TSysDictVo.IS_HIDE = "0";
}
DataTable dt = new TSysDictLogic().SelectByTable(TSysDictVo);
return(DataTableToJson(dt));
}
/// <summary>
/// 获取监测类别
/// </summary>
/// <param name="iIndex"></param>
/// <param name="iCount"></param>
/// <returns></returns>
public void GetMonitorsDutys( )
{
DataTable dtSt = new DataTable();
DataTable dtDict = new DataTable();
TBaseMonitorTypeInfoVo objtd = new TBaseMonitorTypeInfoVo();
objtd.IS_DEL = "0";
dtSt = new TBaseMonitorTypeInfoLogic().SelectByTable(objtd);
TSysDictVo objDit = new TSysDictVo();
objDit.DICT_TYPE = "duty_other";
dtDict = new TSysDictLogic().SelectByTable(objDit);
if (dtSt.Rows.Count > 0)
{
int Sum = 0;
foreach (DataRow drr in dtSt.Rows)
{
Sum++;
nodes = "{ Id:'" + drr["ID"].ToString() + "',pId:'0',Code:'" + drr["ID"] + "',Name:'" + drr["MONITOR_TYPE_NAME"] + "'";
if (Sum == 1)
{
nodes += " ,open:true},\r\n";
}
else
{
nodes += " },\r\n";
}
for (int i = 0; i < dtDict.Rows.Count; i++)
{
nodes += "{ Id:'" + dtDict.Rows[i]["ID"] + "',pId:'" + drr["ID"] + "',Code:'" + dtDict.Rows[i]["DICT_CODE"].ToString() + "',Name:'" + dtDict.Rows[i]["DICT_TEXT"].ToString() + "'";
if (i == dtDict.Rows.Count - 1)
{
nodes += "}\r\n";
}
else
{
nodes += "},\r\n";
}
}
treenodes.Add(nodes);
}
}
string rootNode = "{ Id:'0',pId:'',Code:'0',Name:'监测类别岗位职责集合',open:true},";
varNodes = "[" + rootNode + "" + String.Join(",\r\n", treenodes.ToArray()) + "]";
}
bool IWFStepRules.BuildAndValidateBusinessData(out string strMsg)
{
//这里是验证组件和业务数据的地方
strMsg = "";
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(this.TASK_ID.Value);
string strAcceptance = new TSysDictLogic().GetDictNameByDictCodeAndType("acceptance_code", "dict_system_base");//默认的固定验收监测类别
if (objTask.CONTRACT_TYPE == strAcceptance)
{
wfControl.SetMoreDealUserFlag = true;//自定义任务接收人
if (!string.IsNullOrEmpty(this.PROJECT_ID.Value))
{
wfControl.MoreDealUserForAdd(this.PROJECT_ID.Value);
return(true);
}
else
{
strMsg = "该项目无项目负责人，请联系管理员！";
return(false);
}
}
// 环境质量类别特殊处理 直接完成流程
if (ValidateEnvMonitor(this.TASK_ID.Value))
{
//更改监测任务状态
objTask.TASK_STATUS = "12";
objTask.FINISH_DATE = DateTime.Now.ToString();
if (new TMisMonitorTaskLogic().Edit(objTask))
{
WriteLog("完成监测任务", "", LogInfo.UserInfo.ID + "完成监测任务" + objTask.ID);
}
//销毁的处理方法
//调用页面基类的处理方法即可
string strWfInstID = new i3.BusinessLogic.Sys.WF.TWfInstControlLogic().Details(new TWfInstControlVo()
{
WF_SERVICE_CODE = objTask.CONTRACT_CODE,
WF_SERVICE_NAME = objTask.PROJECT_NAME
}).ID;
if (new PageBaseForWF().WFOperateForKillBySSZ(strWfInstID))//终止整个任务流程
{
LigerDialogAlert("任务已结束！", "success");
}
//Response.Redirect(ViewState["BeforePageUrl"].ToString());
return(true);
}
return(true);
}
/// <summary>
/// 获取部门信息
/// </summary>
/// <returns></returns>
protected string getDeptInfo()
{
int intTotalCount = 0;
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
TSysDictVo objDict = new TSysDictVo();
objDict.DICT_TYPE = "dept";
intTotalCount = new TSysDictLogic().GetSelectResultCount(objDict);
return(CreateToJson(new TSysDictLogic().SelectByTable(objDict, 0, 0), intTotalCount));
}
public static string getDeptName(string strValue)
{
string strResults = "";
List <TSysDictVo> lstDict = new TSysDictLogic().GetDataDictListByType("dept");
TSysPostVo objVo = new TSysPostLogic().Details(strValue);
for (int j = 0; j < lstDict.Count; j++)
{
if (lstDict[j].DICT_CODE == objVo.POST_DEPT_ID)
{
strResults = lstDict[j].DICT_TEXT;
}
}
return(strResults);
}
/// <summary>
/// 获取对应字典项类型的字典项text和code
/// </summary>
/// <param name="strDictType">字典项类型</param>
/// <returns>字典项字符串“text,code|text,code|text,code”</returns>
private string Get_Post_Dict(string strDictType)
{
string strResult = "";
TSysDictVo objDictVo = new TSysDictVo();
objDictVo.DICT_TYPE = strDictType;
objDictVo.SORT_FIELD = TSysDictVo.ORDER_ID_FIELD;
objDictVo.SORT_TYPE = ConstValues.SortType.ASC;
DataTable dt = new TSysDictLogic().SelectByTable(objDictVo, 0, 0);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
strResult += (strResult.Length > 0 ? "|" : "") + dr[TSysDictVo.DICT_CODE_FIELD].ToString() + "," + dr[TSysDictVo.DICT_TEXT_FIELD].ToString();
}
return(strResult);
}
public static string AcceptanceFilter(string strValue)
{
//读取配置中的固定验收监测编码
string strAcceptanceCode = new TSysDictLogic().GetDictNameByDictCodeAndType("acceptance_code", "dict_system_base");
// 判断是否是验收监测
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(strValue);
if (Equals(strAcceptanceCode, objTask.CONTRACT_TYPE))
{
DataTable dtProjecter = new TMisMonitorTaskLogic().GetProjectID(strValue);
if (dtProjecter.Rows.Count > 0)
{
if (Equals(dtProjecter.Rows[0]["ID"].ToString(), new PageBase().LogInfo.UserInfo.ID))
{
return("true");
}
}
}
return("false");
}
/// <summary>
/// 根据监测类别获取天气项目
/// </summary>
/// <returns>Json</returns>
protected string GetWeatherInfo()
{
string strDictType = "";
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(this.SUBTASK_ID.Value);
if (objSubtask.MONITOR_ID == "000000004")
{
strDictType = "noise_weather";
}
else
{
strDictType = "gerenal_weather";
}
TSysDictVo objDict = new TSysDictVo();
objDict.DICT_TYPE = strDictType;
objDict.SORT_FIELD = TSysDictVo.ORDER_ID_FIELD;
DataTable dt = new TSysDictLogic().SelectByTable(objDict, 0, 0);
return(DataTableToJson(dt));
}
/// <summary>
/// 根据监测类别获取天气项目
/// </summary>
/// <returns>Json</returns>
protected string GetWeatherInfo()
{
string strDictType = "";
if (this.MONITOR_ID.Value.Trim() == "000000004")
{
strDictType = "noise_weather";
}
else
{
strDictType = "gerenal_weather";
}
TSysDictVo objDict = new TSysDictVo();
objDict.DICT_TYPE = strDictType;
objDict.SORT_FIELD = TSysDictVo.ORDER_ID_FIELD;
DataTable dt = new TSysDictLogic().SelectByTable(objDict, 0, 0);
return(DataTableToJson(dt));
}
public static string editData(string id, string strDictType, string strDictCode, string strDictName, string strRemark)
{
TSysDictVo TSysDictVo = new TSysDictVo();
TSysDictVo.ID = id;
TSysDictVo.DICT_TYPE = HttpContext.Current.Server.UrlDecode(strDictType);
TSysDictVo.DICT_TEXT = HttpContext.Current.Server.UrlDecode(strDictName);
TSysDictVo.DICT_CODE = HttpContext.Current.Server.UrlDecode(strDictCode);
TSysDictVo.REMARK = strRemark;
bool isSuccess = new TSysDictLogic().Edit(TSysDictVo);
if (isSuccess)
{
new PageBase().WriteLog("编辑字典项数据", "", new UserLogInfo().UserInfo.USER_NAME + "编辑字典项数据" + TSysDictVo.ID);
return("1");
}
else
{
return("0");
}
}
/// <summary>
/// 获取部门信息
/// </summary>
protected void getDeptInfo()
{
DataTable dt = new TSysDictLogic().SelectByTable(new TSysDictVo()
{
DICT_TYPE = "dept",
SORT_FIELD = TSysDictVo.ORDER_ID_FIELD,
SORT_TYPE = SortDirection.Ascending.ToString()
});
//插入一条 全部部门
if (dt.Rows.Count > 0)
{
DataRow dr = dt.NewRow();
dr["DICT_TEXT"] = "所有部门";
dr["DICT_CODE"] = "";
dt.Rows.InsertAt(dr, 0);
}
string strJson = CreateToJson(dt, dt.Rows.Count);
Response.Write(strJson);
Response.End();
}
public static string getContractType(string strValue)
{
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(strValue);
//委托类别
string strContractType = new TSysDictLogic().GetDictNameByDictCodeAndType(objTask.CONTRACT_TYPE, "Contract_Type");
if (!string.IsNullOrEmpty(strContractType))
{
return(strContractType);
}
else//环境质量类别处理
{
DataTable dtSubtask = new TMisMonitorSubtaskLogic().getMonitorByTask(strValue);
if (dtSubtask.Rows.Count > 0)
{
string strEnvType = new TSysDictLogic().GetDictNameByDictCodeAndType(dtSubtask.Rows[0][TMisMonitorSubtaskVo.MONITOR_ID_FIELD].ToString(), "EnvTypes");
if (!string.IsNullOrEmpty(strEnvType))
{
return(strEnvType);
}
}
}
return("");
}
protected void Page_Load(object sender, EventArgs e)
{
var workID = Request.QueryString["WorkID"]; //当前流程ID
var fid = Request.QueryString["FID"]; //父流程ID
workID = workID ?? Int32.MinValue.ToString(); //如果为空会查询出记录，所以查询时workID不能为空
//结果
string strResult = "";
if (!string.IsNullOrEmpty(workID))
{
TMisMonitorTaskVo objTaskVo = new TMisMonitorTaskVo();
objTaskVo.CCFLOW_ID1 = workID;
objTaskVo = new TMisMonitorTaskLogic().Details(objTaskVo);
//监测任务ID
this.ID.Value = objTaskVo.ID;
//委托书ID
this.ContractID.Value = new TMisMonitorTaskLogic().Details(this.ID.Value).CONTRACT_ID;
//报告ID
this.reportId.Value = new TRptFileLogic().getNewReportByContractID(this.ID.Value).ID;
}
if (!string.IsNullOrEmpty(Request.QueryString["task_id"]))
{
//监测任务ID
this.ID.Value = Request.QueryString["task_id"].ToString();
//委托书ID
this.ContractID.Value = new TMisMonitorTaskLogic().Details(this.ID.Value).CONTRACT_ID;
//报告ID
this.reportId.Value = new TRptFileLogic().getNewReportByContractID(this.ID.Value).ID;
}
//获取委托书信息
if (!string.IsNullOrEmpty(Request.QueryString["type"]) && Request.QueryString["type"] == "getContractInfo")
{
strResult = GetContractInfo();
Response.Write(strResult);
Response.End();
}
//获取委托书信息 非编制
if (!string.IsNullOrEmpty(Request.QueryString["type"]) && Request.QueryString["type"] == "getContractInfoForView")
{
strResult = GetContractInfo();
Response.Write(strResult);
Response.End();
}
//获取委托单位信息
if (!string.IsNullOrEmpty(Request.QueryString["type"]) && Request.QueryString["type"] == "getClientInfo")
{
strResult = GetClientInfo();
Response.Write(strResult);
Response.End();
}
//获取受检单位信息
if (!string.IsNullOrEmpty(Request.QueryString["type"]) && Request.QueryString["type"] == "getTestedInfo")
{
strResult = GetTestedInfo();
Response.Write(strResult);
Response.End();
}
//获取样品
if (!string.IsNullOrEmpty(Request.QueryString["type"]) && Request.QueryString["type"] == "getSampleInfo")
{
strResult = GetSampleInfo();
Response.Write(strResult);
Response.End();
}
//获取项目
if (!string.IsNullOrEmpty(Request.QueryString["type"]) && Request.QueryString["type"] == "getItemInfo")
{
strResult = GetItemInfoBySampleID();
Response.Write(strResult);
Response.End();
}
//判断是否存在报告
if (!string.IsNullOrEmpty(Request.QueryString["action"]) && Request.QueryString["action"] == "ReportStatus")
{
strResult = ReportExists();
Response.Write(strResult);
Response.End();
}
//报告类型
if (Request["type"] != null && Request["type"].ToString() == "getTemplate")
{
strResult = getTemplate();
Response.Write(strResult);
Response.End();
}
//辅助报告类型
if (Request["type"] != null && Request["type"].ToString() == "getReportTemplate")
{
strResult = getReportTemplate();
Response.Write(strResult);
Response.End();
}
//切换模板
if (!string.IsNullOrEmpty(Request.QueryString["action"]) && Request.QueryString["action"] == "changeTem")
{
SetReportTemplateNull();
}
//监测类别
if (!string.IsNullOrEmpty(Request.QueryString["type"]) && Request.QueryString["type"] == "getMonitorType")
{
strResult = getMonitorType();
Response.Write(strResult);
Response.End();
}
//委托类别
if (!string.IsNullOrEmpty(Request.QueryString["type"]) && Request.QueryString["type"] == "getDictName")
{
strResult = new TSysDictLogic().GetDictNameByDictCodeAndType(Request.QueryString["strCode"], Request.QueryString["strType"]);
Response.Write(strResult);
Response.End();
}
//监测任务监测类别
if (!string.IsNullOrEmpty(Request.QueryString["type"]) && Request.QueryString["type"] == "getItemType")
{
strResult = getTaskMonitorType(this.ID.Value);
Response.Write(strResult);
Response.End();
}
//报告生成同时保存业务数据
if (!string.IsNullOrEmpty(Request.QueryString["type"]) && Request.QueryString["type"] == "saveinfo")
{
strResult = SaveData();
Response.Write(strResult);
Response.End();
}
//获取模板ID
if (!string.IsNullOrEmpty(Request.QueryString["type"]) && Request.QueryString["type"] == "getTemId")
{
strResult = getTemId(Request.QueryString["code"]);
Response.Write(strResult);
Response.End();
}
if (!IsPostBack)
{
}
}
/// <summary>
/// 获得委托书信息
/// </summary>
/// <returns></returns>
protected string GetContractInfo()
{
TMisContractVo objContractInfo = new TMisContractVo();
objContractInfo.ID = this.hdnContracID.Value;
objContractInfo.CONTRACT_STATUS = "9";
objContractInfo = new TMisContractLogic().Details(objContractInfo);
//签订日期 格式
try
{
objContractInfo.ASKING_DATE = DateTime.Parse(objContractInfo.ASKING_DATE).ToString("yyyy-MM-dd");
}
catch { }
//备注信息组装
string strRemark = "";
//同意分包
if (objContractInfo.AGREE_OUTSOURCING == "1")
{
string strDictText = new TSysDictLogic().GetDictNameByDictCodeAndType("accept_subpackage", "Contract_Remarks");
strRemark += strDictText.Length > 0 ? strDictText + ";" : "";
}
//同意监测方法
if (objContractInfo.AGREE_METHOD == "1")
{
string strDictText = new TSysDictLogic().GetDictNameByDictCodeAndType("accept_useMonitorMethod", "Contract_Remarks");
strRemark += strDictText.Length > 0 ? strDictText + ";" : "";
}
//同意使用非标准方法
if (objContractInfo.AGREE_NONSTANDARD == "1")
{
string strDictText = new TSysDictLogic().GetDictNameByDictCodeAndType("accept_usenonstandard", "Contract_Remarks");
strRemark += strDictText.Length > 0 ? strDictText + ";" : "";
}
//同意其他
if (objContractInfo.AGREE_OTHER == "1")
{
string strDictText = new TSysDictLogic().GetDictNameByDictCodeAndType("accept_other", "Contract_Remarks");
strRemark += strDictText.Length > 0 ? strDictText + ";" : "";
}
if (strRemark.Length > 0)
{
strRemark = strRemark.Remove(strRemark.LastIndexOf(";"));
}
objContractInfo.REMARK1 = strRemark;
//添加监测类型
string strMonitorType = ""; //合同类型字符串
if (objContractInfo.TEST_TYPES.Length > 0) //所有监测类型
{
string[] strTestType = objContractInfo.TEST_TYPES.Split(';');
foreach (string str in strTestType)
{
if (str.Length > 0)
{
//监测类别名称
string strTypeName = new TBaseMonitorTypeInfoLogic().Details(str).MONITOR_TYPE_NAME;
strMonitorType += strTypeName.Length > 0 ? strTypeName + "," : "";
}
}
}
strMonitorType = strMonitorType.Length > 0 ? strMonitorType.Remove(strMonitorType.LastIndexOf(",")) : "";
objContractInfo.TEST_TYPES = strMonitorType;
return(ToJson(objContractInfo));
}
/// <summary>
/// 获取采用的标准项的上下限
/// </summary>
/// <param name="strItemID">项目ID</param>
/// <param name="strConditionID">条件项ID</param>
/// <param name="strUp">上限</param>
/// <param name="strLow">下限</param>
protected void getStandardValue(string strItemID, string strConditionID, ref string strUp, ref string strLow, ref string strConditionType)
{
TBaseEvaluationConItemVo objConItemVo = new TBaseEvaluationConItemVo();
objConItemVo.ITEM_ID = strItemID;
objConItemVo.CONDITION_ID = strConditionID;
objConItemVo.IS_DEL = "0";
objConItemVo = new TBaseEvaluationConItemLogic().Details(objConItemVo);
//上限处理
if (objConItemVo.DISCHARGE_UPPER.Length > 0)
{
//上限单位
string strUnit = new TSysDictLogic().GetDictNameByDictCodeAndType(objConItemVo.UPPER_OPERATOR, "logic_operator");
if (strUnit.Length > 0)
{
if (strUnit.IndexOf("≤") >= 0)
{
strUnit = "<=";
}
else if (strUnit.IndexOf("≥") >= 0)
{
strUnit = ">=";
}
}
if (objConItemVo.DISCHARGE_UPPER.Contains(","))
{
string[] strValue = objConItemVo.DISCHARGE_UPPER.Split(',');
foreach (string str in strValue)
{
if (str.Length > 0)
{
strUp += (strUnit + str) + ",";
}
}
if (strUp.Length > 0)
{
strUp = strUp.Remove(strUp.LastIndexOf(","));
}
}
else
{
strUp = strUnit + objConItemVo.DISCHARGE_UPPER;
}
}
//下限处理
if (objConItemVo.DISCHARGE_LOWER.Length > 0)
{
//下限单位
string strUnit = new TSysDictLogic().GetDictNameByDictCodeAndType(objConItemVo.LOWER_OPERATOR, "logic_operator");
if (strUnit.Length > 0)
{
if (strUnit.IndexOf("≤") >= 0)
{
strUnit = "<=";
}
else if (strUnit.IndexOf("≥") >= 0)
{
strUnit = ">=";
}
}
if (objConItemVo.DISCHARGE_LOWER.Contains(","))
{
string[] strValue = objConItemVo.DISCHARGE_LOWER.Split(',');
foreach (string str in strValue)
{
if (str.Length > 0)
{
strLow += (strUnit + str) + ",";
}
}
if (strLow.Length > 0)
{
strLow = strLow.Remove(strLow.LastIndexOf(","));
}
}
else
{
strLow = strUnit + objConItemVo.DISCHARGE_LOWER;
}
}
strConditionType = new TBaseEvaluationInfoLogic().Details(new TBaseEvaluationConInfoLogic().Details(strConditionID).STANDARD_ID).STANDARD_TYPE;
}
//保存数据
private static string SaveData(string strID, string strMessageTitle, string strSendBy, string strSendDate, string strAcceptType,
string strAcceptRealNames, string strAcceptUserIDs, string strAcceptDeptNames, string strAcceptDeptIDs, string strMessageContent, string strUserID)
{
string strSendByName = strSendBy;
TSysUserVo objUserFrom = new TSysUserVo();
objUserFrom.ID = strSendBy;
DataTable dtUserSender = new TSysUserLogic().SelectByTable_ByDept(objUserFrom, 0, 0);
if (dtUserSender.Rows.Count > 0)
{
strSendByName = dtUserSender.Rows[0]["REAL_NAME"].ToString();
}
bool isSuccess = true;
strAcceptRealNames = strAcceptRealNames.Trim();
strAcceptUserIDs = strAcceptUserIDs.Trim();
strAcceptDeptNames = strAcceptDeptNames.Trim();
strAcceptDeptIDs = strAcceptDeptIDs.Trim();
#region 消息查看--编辑消息阅读状态
if (strID.Length > 0)
{
TOaMessageInfoReceiveVo objReceive = new TOaMessageInfoReceiveVo();
objReceive.IS_READ = "0";
objReceive.MESSAGE_ID = strID;
objReceive.RECEIVER = strUserID;
objReceive = new TOaMessageInfoReceiveLogic().Details(objReceive);
if (objReceive.ID.Length > 0)
{
objReceive.IS_READ = "1";
if (new TOaMessageInfoReceiveLogic().Edit(objReceive))
{
new PageBase().WriteLog("编辑消息阅读状态", "", new UserLogInfo().UserInfo.USER_NAME + "编辑消息阅读状态" + objReceive.ID);
}
return("1");
}
}
#endregion
DataTable dtDept = new TSysDictLogic().SelectByTable(new TSysDictVo()
{
DICT_TYPE = "dept"
});
strAcceptDeptNames = strAcceptDeptNames.Replace(";", "，");
string[] arrAccDeptName = strAcceptDeptNames.Split('，');
for (int i = 0; i < arrAccDeptName.Length; i++)
{
if (arrAccDeptName[i].Length > 0)
{
DataRow[] drDept = dtDept.Select("DICT_TEXT='" + arrAccDeptName[i] + "'");
if (drDept.Length > 0)
{
strAcceptDeptIDs += (strAcceptDeptIDs.Length > 0 ? "," : "") + drDept[0]["DICT_CODE"];
}
}
}
#region 清空对应的几个接收信息表，冗余操作，但可以防止错误
if (strID.Length > 0)
{
//消息接收人表
TOaMessageInfoManVo objMessageMan = new TOaMessageInfoManVo();
objMessageMan.MESSAGE_ID = strID;
if (new TOaMessageInfoManLogic().Delete(objMessageMan))
{
new PageBase().WriteLog("删除消息接收人", "", new UserLogInfo().UserInfo.USER_NAME + "删除消息接收人" + objMessageMan.ID);
}
//消息阅读状态表
TOaMessageInfoReceiveVo objMessageReceive = new TOaMessageInfoReceiveVo();
objMessageReceive.MESSAGE_ID = strID;
if (new TOaMessageInfoReceiveLogic().Delete(objMessageReceive))
{
new PageBase().WriteLog("删除消息阅读状态", "", new UserLogInfo().UserInfo.USER_NAME + "删除消息阅读状态" + objMessageReceive.ID);
}
//消息接收部门表
TOaMessageInfoDeptVo objMessageDept = new TOaMessageInfoDeptVo();
objMessageDept.MESSAGE_ID = strID;
if (new TOaMessageInfoDeptLogic().Delete(objMessageDept))
{
new PageBase().WriteLog("删除消息接收部门", "", new UserLogInfo().UserInfo.USER_NAME + "删除消息接收部门" + objMessageDept.ID);
}
}
#endregion
string strSQL = "";
#region 新增消息
if (strID.Length > 0)
{
strSQL = "update T_OA_MESSAGE_INFO set MESSAGE_TITLE='{0}',SEND_BY='{1}',SEND_DATE='{2}',ACCEPT_TYPE='{3}',";
strSQL += "ACCEPT_REALNAMES='{4}',ACCEPT_USERIDS='{5}',ACCEPT_DEPTNAMES='{6}',ACCEPT_DEPTIDS='{7}',";
strSQL += "MESSAGE_CONTENT='{8}'";
strSQL += " where ID='{9}'";
strSQL = string.Format(strSQL, strMessageTitle, strSendBy, strSendDate, (strAcceptType == "全站") ? "1" : "2",
strAcceptRealNames.TrimEnd('，'), strAcceptUserIDs.TrimEnd(','), strAcceptDeptNames, strAcceptDeptIDs,
strMessageContent, strID);
}
else
{
strID = GetSerialNumber("t_oa_messageinfo_id");
strSQL = "insert into T_OA_MESSAGE_INFO (ID,MESSAGE_TITLE,SEND_BY,SEND_DATE,ACCEPT_TYPE,ACCEPT_REALNAMES,ACCEPT_USERIDS,ACCEPT_DEPTNAMES,ACCEPT_DEPTIDS,MESSAGE_CONTENT)";
strSQL += " values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')";
strSQL = string.Format(strSQL, strID, strMessageTitle, strSendBy, strSendDate, (strAcceptType == "全站") ? "1" : "2",
strAcceptRealNames.TrimEnd('，'), strAcceptUserIDs.TrimEnd(','), strAcceptDeptNames, strAcceptDeptIDs,
strMessageContent);
}
#endregion
string strAccUserIDs = "";
if (strAcceptType == "全站")//全站
{
TSysUserVo objUser = new TSysUserVo();
objUser.IS_DEL = "0";
objUser.IS_HIDE = "0";
objUser.IS_USE = "1";
DataTable dtUser = new TSysUserLogic().SelectByTable(objUser);
for (int j = 0; j < dtUser.Rows.Count; j++)
{
// by yinchengyi 2014-10-23 T_OA_MESSAGE_INFO_MAN 没用
//strSQL += "\r\n";
//strSQL += "insert into T_OA_MESSAGE_INFO_MAN (ID,MESSAGE_ID,RECEIVER_ID)";
//strSQL += " values('{0}','{1}','{2}')";
//strSQL = string.Format(strSQL, GetSerialNumber("t_oa_messageinfoman_id"), strID, dtUser.Rows[j]["ID"].ToString());
string strErrMsg = cInstanceMsgHandle.SendMsg(strSendByName, dtUser.Rows[j]["REAL_NAME"].ToString(), dtUser.Rows[j]["PHONE_MOBILE"].ToString().Trim(), strMessageContent);
strSQL += "\r\n";
strSQL += "insert into T_OA_MESSAGE_INFO_RECEIVE (ID,MESSAGE_ID,RECEIVER,IS_READ,REMARK3)";
strSQL += " values('{0}','{1}','{2}','{3}','{4}')";
strSQL = string.Format(strSQL, GetSerialNumber("t_oa_messageinfodel_id"), strID, dtUser.Rows[j]["ID"].ToString(), "0", strErrMsg);
strAccUserIDs += (strAccUserIDs.Length > 0 ? "," : "") + dtUser.Rows[j]["ID"].ToString();
}
}
else//按部门，按个人分配消息
{
// by yinchengyi 2014-10-23 T_OA_MESSAGE_INFO_MAN 没用
//for (int i = 0; i < strAcceptUserIDs.Split(',').Length; i++)
//{
// if (strAcceptUserIDs.Split(',')[i].Length > 0)
// {
// strSQL += "\r\n";
// strSQL += "insert into T_OA_MESSAGE_INFO_MAN (ID,MESSAGE_ID,RECEIVER_ID)";
// strSQL += " values('{0}','{1}','{2}')";
// strSQL = string.Format(strSQL, GetSerialNumber("t_oa_messageinfoman_id"), strID, strAcceptUserIDs.Split(',')[i]);
// }
//}
// by yinchengyi 2014-10-23 T_OA_MESSAGE_INFO_DEPT 没用
//for (int i = 0; i < strAcceptDeptIDs.Split(',').Length; i++)
//{
// if (strAcceptDeptIDs.Split(',')[i].Length > 0)
// {
// strSQL += "\r\n";
// strSQL += "insert into T_OA_MESSAGE_INFO_DEPT (ID,MESSAGE_ID,DEPT_ID)";
// strSQL += " values('{0}','{1}','{2}')";
// strSQL = string.Format(strSQL, GetSerialNumber("t_oa_messageinfodept_id"), strID, strAcceptDeptIDs.Split(',')[i]);
// }
//}
//部门人员添加
if (strAcceptDeptIDs.Length > 0)
{
TSysUserVo objUser = new TSysUserVo();
objUser.IS_DEL = "0";
objUser.REMARK4 = strAcceptDeptIDs.Replace(",", "','");
DataTable dtUserByDept = new TSysUserLogic().SelectByTable_ByDept(objUser, 0, 0);
for (int j = 0; j < dtUserByDept.Rows.Count; j++)
{
if (!strAcceptUserIDs.Contains(dtUserByDept.Rows[j]["ID"].ToString()))
{
strAcceptUserIDs += (strAcceptUserIDs.Length > 0 ? "," : "") + dtUserByDept.Rows[j]["ID"].ToString();
}
}
}
for (int i = 0; i < strAcceptUserIDs.Split(',').Length; i++)
{
if (strAcceptUserIDs.Split(',')[i].Length > 0)
{
TSysUserVo objUser = new TSysUserVo();
objUser.ID = strAcceptUserIDs.Split(',')[i];
DataTable dtUserByDept = new TSysUserLogic().SelectByTable_ByDept(objUser, 0, 0);
string strErrMsg = "unknown user";
if (dtUserByDept.Rows.Count > 0)
{
strErrMsg = cInstanceMsgHandle.SendMsg(strSendByName, dtUserByDept.Rows[0]["REAL_NAME"].ToString(), dtUserByDept.Rows[0]["PHONE_MOBILE"].ToString().Trim(), strMessageContent);
}
strSQL += "\r\n";
strSQL += "insert into T_OA_MESSAGE_INFO_RECEIVE (ID,MESSAGE_ID,RECEIVER,IS_READ,REMARK3)";
strSQL += " values('{0}','{1}','{2}','{3}','{4}')";
strSQL = string.Format(strSQL, GetSerialNumber("t_oa_messageinfodel_id"), strID, strAcceptUserIDs.Split(',')[i], "0", strErrMsg);
}
}
strAccUserIDs += (strAccUserIDs.Length > 0 ? "," : "") + strAcceptUserIDs;
}
//if (strAccUserIDs.Length > 0)
//{
// string strErrMsg = "";
// //new SendMobileMsg().AutoSenMobilMsg(strMessageContent, strSendBy, strAccUserIDs, true, "", ref strErrMsg);
//}
#region 消息体
isSuccess = SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false;
if (isSuccess)
{
if (strID.Length > 0)
{
new PageBase().WriteLog("编辑短消息信息", "", new UserLogInfo().UserInfo.USER_NAME + "编辑短消息信息" + strID);
}
else
{
new PageBase().WriteLog("添加短消息信息", "", new UserLogInfo().UserInfo.USER_NAME + "添加短消息信息" + strID);
}
}
#endregion
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
