/// <summary> /// 保存数据 /// </summary> /// <returns></returns> private string SaveData() { try { //保存前,通过班级名称删除现有数据 string strSqlDel = string.Format("DELETE FROM BASIC_CLASS_INFO WHERE CLASSNAME = '{0}' AND XY = '{1}' ", Post("CLASSNAME"), Post("XY")); ds.ExecuteTxtNonQuery(strSqlDel); string strClassCode = ComHandleClass.getInstance().GetClassCode(Post("STU_TYPE"), Post("XY"), Post("ZY"), Post("GRADE")); if (strClassCode.Length == 0) { return(string.Empty); } Basic_class_info head = new Basic_class_info(); head.CLASSCODE = strClassCode; ds.RetrieveObject(head); head.CLASSNAME = Post("CLASSNAME").Trim(); head.XY = Post("XY"); head.ZY = Post("ZY"); head.GRADE = Post("GRADE"); head.STU_TYPE = Post("STU_TYPE"); head.OP_CODE = user.User_Id; head.OP_NAME = user.User_Name; head.OP_TIME = GetDateLongFormater(); ds.UpdateObject(head); return(head.CLASSCODE); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "班级保存失败:" + ex.ToString()); return(string.Empty); } }
/// <summary> /// 同步获奖情况数据 /// </summary> /// <returns></returns> private string SynchroData() { string strMsg = string.Empty; try { if (string.IsNullOrEmpty(Get("seq_no"))) { return(string.Format("奖助申请单据编号为空!")); } //先删除数据再新增 string strSQL1 = string.Format("DELETE FROM SHOOLAR_APPLY_REWARD WHERE SEQ_NO = '{0}' ", Get("seq_no")); if (ds.ExecuteTxtNonQuery(strSQL1) < 0) { return("同步获奖情况数据失败!"); } ProjectApplyHandleClass.getInstance().InsertInto_apply_reward(Get("seq_no"), out strMsg); if (strMsg.Length > 0) { return(strMsg); } return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "奖助申请,同步获奖情况数据失败:" + ex.ToString()); return("同步获奖情况数据失败!"); } }
/// <summary> /// 保存数据 /// </summary> /// <returns></returns> private string SaveData() { try { Qz_job_proof_set head = new Qz_job_proof_set(); head.OID = Post("OID"); if (head.OID == "") { head.OID = Guid.NewGuid().ToString(); } ds.RetrieveObject(head); head.SCH_YEAR = Post("SCH_YEAR"); head.SCH_TERM = Post("SCH_TERM"); head.YEAR_MONTH = Post("YEAR_MONTH"); head.IS_ENABLE = Post("IS_ENABLE"); head.DECLARE_START_TIME = Post("DECLARE_START_TIME"); head.DECLARE_END_TIME = Post("DECLARE_END_TIME"); head.OP_CODE = user.User_Id; head.OP_NAME = user.User_Name; head.OP_TIME = ComTranClass.getInstance().GetCurrLongDateTime(); ds.UpdateObject(head); //把其他设置改为不启用 if (head.IS_ENABLE.Equals(CValue.FLAG_Y)) { ds.ExecuteTxtNonQuery(string.Format("UPDATE QZ_JOB_PROOF_SET SET IS_ENABLE = 'N' WHERE OID != '{0}'", head.OID)); } return(head.OID); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "保存劳酬凭据基本设置出错:" + ex.ToString()); return(string.Empty); } }
/// <summary> /// 通过传入的主键编码删除数据 /// </summary> /// <returns></returns> private string DeleteData() { try { if (string.IsNullOrEmpty(Get("id"))) { return("主键为空,不允许删除操作"); } var model = new Messge_info(); model.OID = Get("id"); ds.RetrieveObject(model); bool bDel = false; var transaction = ImplementFactory.GetDeleteTransaction <Messge_info>("Messge_infoDeleteTransaction"); transaction.EntityList.Add(model); bDel = transaction.Commit(); if (!bDel) { return("删除失败!"); } return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "删除消息,出错:" + ex.ToString()); return("删除失败!"); } }
/// <summary> /// 自动生成数据 /// </summary> /// <returns></returns> private string AutoData() { try { string insur_seq_no = Post("insur_seq_no"); if (string.IsNullOrWhiteSpace(insur_seq_no)) { return("自动生成保险申请数据失败:参数不能为空!"); } Dictionary <string, string> param_pro_head = new Dictionary <string, string>(); param_pro_head.Add("SEQ_NO", insur_seq_no); Insur_project_head project = InsurHandleClass.getInstance().GetInsurProjectHeadInfo(param_pro_head); if (project == null) { return("自动生成保险申请数据失败:项目信息为空!"); } //当为“医保”的时候,判断是否设置了 保险期限、金额 if (project.INSUR_TYPE.Equals("A")) { if (project.INSUR_LIMITDATE.Length == 0 || project.INSUR_MONEY.ToString().Length == 0) { return("自动生成保险申请数据失败:项目信息中承保期限、金额设置不能为空!"); } } Dictionary <string, string> param = new Dictionary <string, string>(); List <Basic_stu_info> stuList = StuHandleClass.getInstance().GetStuInfoArray(param); if (stuList == null) { return("自动生成保险申请数据失败!"); } foreach (Basic_stu_info stu in stuList) { if (stu == null) { continue; } //删除相同学号的数据 string strSelectSql = string.Format("SELECT SEQ_NO FROM INSUR_PROJECT_APPLY WHERE INSUR_SEQ_NO = '{0}' AND STU_NUMBER = '{1}' ", insur_seq_no, stu.NUMBER); DataTable dt = ds.ExecuteTxtDataTable(strSelectSql); if (dt != null && dt.Rows.Count != 0) { string strDeleteSql_Head = string.Format("DELETE FROM INSUR_PROJECT_APPLY WHERE SEQ_NO = '{0}' ", dt.Rows[0]["SEQ_NO"].ToString()); string strDeleteSql_Check = string.Format("DELETE FROM INSUR_APPLY_CHECK WHERE SEQ_NO = '{0}' ", dt.Rows[0]["SEQ_NO"].ToString()); ds.ExecuteTxtNonQuery(strDeleteSql_Head); ds.ExecuteTxtNonQuery(strDeleteSql_Check); } //插入申请数据 Insur_project_apply head = InsertIntoApplyHead(project, stu); //插入预先核对信息 InsertIntoCheckInfo(head.SEQ_NO, head.INSUR_LIMITDATE, head.INSUR_MONEY); } return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "自动生成保险申请数据,出错:" + ex.ToString()); return("自动生成保险申请数据失败!"); } }
/// <summary> /// 编辑时首次加载专业HTML /// </summary> /// <returns></returns> private string GetZy_Edit() { try { if (string.IsNullOrEmpty(Get("seq_no"))) { return(string.Empty); } string strSQL = string.Format("SELECT ZY_ID, ZY_NAME FROM SHOOLAR_PROJECT_LIMIT_ZY WHERE SEQ_NO = '{0}' ", Get("seq_no")); DataTable dt = ds.ExecuteTxtDataTable(strSQL); if (dt == null) { return(string.Empty); } StringBuilder sbHtml = new StringBuilder(); foreach (DataRow row in dt.Rows) { if (row == null) { continue; } sbHtml.Append("<input name=\"limit_zy\" id=\"" + row["ZY_ID"].ToString() + "\" type=\"checkbox\" value=\"" + row["ZY_ID"].ToString() + "\" class=\"flat-red\"/> <label for=\"" + row["ZY_ID"].ToString() + "\">" + row["ZY_NAME"].ToString() + "</label> "); } return(sbHtml.ToString()); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_WARN, "奖助项目设置,编辑时首次加载专业HTML,出错:" + ex.ToString()); return(string.Empty); } }
/// <summary> /// 导入操作 /// </summary> /// <param name="userfile"></param> protected void DoImport(HtmlInputFile userfile) { try { string fileName = string.Empty; string fileExtension = string.Empty; string physical_path = string.Empty; UploadFile(userfile, ref physical_path);//SaveAs有问题,改为通过文件流上传 20170302 by elh ///将文件转成文件流的形式 using (Stream stream = new FileStream(physical_path, FileMode.Open, FileAccess.Read)) { ///excel第一个标签页 string strMsg = string.Empty; DataTable dtExcel = ImportDataTableFromExcel(stream, 0, out strMsg); if (strMsg.Length > 0) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "导入出错:" + strMsg); } if (dtExcel != null && dtExcel.Rows.Count > 0) { ReadExcelData(dtExcel); } } } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "导入出错:" + ex.ToString()); string alert_msg = string.Format("{{\"content\":\"{0}\", \"duration\":6,\"type\": \"danger\"}}", ex.Message); doJavaScript(cod.GetJScript("easyAlert.timeShow", alert_msg)); } }
/// <summary> /// 编辑时首次加载接收人HTML /// </summary> /// <returns></returns> private string GetAccpter_Edit() { try { if (string.IsNullOrEmpty(Get("id"))) { return(string.Empty); } string strSQL = string.Format("SELECT ACCPTER_CODE, ACCPTER_NAME FROM MESSGE_ACCPTER WHERE MSG_OID = '{0}' ", Get("id")); DataTable dt = ds.ExecuteTxtDataTable(strSQL); if (dt == null) { return(string.Empty); } StringBuilder sbHtml = new StringBuilder(); foreach (DataRow row in dt.Rows) { if (row == null) { continue; } sbHtml.Append("<input name=\"accpter_user\" id=\"" + row["ACCPTER_CODE"].ToString() + "\" type=\"checkbox\" value=\"" + row["ACCPTER_CODE"].ToString() + "\" class=\"flat-red\"/> <label for=\"" + row["ACCPTER_CODE"].ToString() + "\">" + row["ACCPTER_NAME"].ToString() + "</label> "); } return(sbHtml.ToString()); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_WARN, "编辑时首次加载接收人HTML,出错:" + ex.ToString()); return(string.Empty); } }
/// <summary> /// 删除数据 /// </summary> /// <returns></returns> private string DeleteData() { try { string[] strs = Post("SELECT_OID").Split(','); for (int i = 0; i < strs.Length; i++) { if (strs[i].Length == 0) { continue; } var model = new Makeup_project_apply(); model.OID = strs[i].ToString(); ds.RetrieveObject(model); bool bDel = false; var transaction = ImplementFactory.GetDeleteTransaction <Makeup_project_apply>("Makeup_project_applyDeleteTransaction"); transaction.EntityList.Add(model); bDel = transaction.Commit(); if (!bDel) { return("删除失败!"); } } return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "删除学费补偿学费补偿申请数据,出错:" + ex.ToString()); return("删除失败!"); } }
/// <summary> /// 删除主表的时候连带子表的数据也一并删除 /// </summary> /// <returns></returns> private string DeleteData() { try { if (string.IsNullOrEmpty(Get("id"))) { return("OID为空,不允许删除操作"); } Peer_project_head head = new Peer_project_head(); head.OID = Get("id"); ds.RetrieveObject(head); var transaction = ImplementFactory.GetDeleteTransaction <Peer_project_head>("Peer_project_headDeleteTransaction"); transaction.EntityList.Add(head); //已经改写了Commit方法,提交删除操作时会同时把:表体对应数据删除 if (transaction.Commit()) { return(string.Empty); } return("删除失败!"); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "评议项目设置,删除,出错:" + ex.ToString()); return("删除失败!"); } }
/// <summary> /// 加载单位管理员HTML /// </summary> /// <returns></returns> private string GetManager() { try { if (string.IsNullOrEmpty(Get("dw"))) { return(string.Empty); } string strSQL = string.Format("SELECT MANAGER FROM T_XT_DEPARTMENT WHERE DW = '{0}' ", Get("dw")); string strCode = ds.ExecuteTxtScalar(strSQL).ToString(); if (string.IsNullOrEmpty(strCode)) { return(string.Empty); } string[] arrCode = strCode.Split(new char[] { ',' }); StringBuilder sbHtml = new StringBuilder(); foreach (string code in arrCode) { if (string.IsNullOrEmpty(code)) { continue; } sbHtml.Append("<input name=\"MANAGER\" id=\"" + code + "\" type=\"checkbox\" value=\"" + code + "\" class=\"flat-red\"/> <label for=\"" + code + "\">" + cod.GetDDLTextByValue("ddl_ua_user", code) + "</label> "); } return(sbHtml.ToString()); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_WARN, ex.ToString()); return(string.Empty); } }
/// <summary> /// 删除数据 /// </summary> /// <returns></returns> private string DeleteData() { try { string[] strs = Get("ids").Split(','); for (int i = 0; i < strs.Length; i++) { if (strs[i].Length == 0) { continue; } var model = new Insur_project_apply(); model.OID = strs[i].ToString(); ds.RetrieveObject(model); model.INSUR_NUMBER = ""; model.INSUR_COMPANY = ""; model.INSUR_HANLDMAN = ""; model.INSUR_HANLDMAN_PHONE = ""; ds.UpdateObject(model); } return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "保险申请删除,出错:" + ex.ToString()); return("删除失败!"); } }
/// <summary> /// 导入excel转成table的值到对应表中 /// </summary> /// <param name="table"></param> private void ReadExcelData(DataTable table) { try { string result = string.Empty; string reChkMsg = ProcessData(table); if (reChkMsg.Length > 0) { result += string.Format("导入失败!excel中的数据不正确!具体如下:{0}", reChkMsg); } if (result.Length > 0) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "上传文件出错:" + result); string alert_msg = string.Format("{{\"content\":\"{0}\", \"duration\":6,\"type\": \"danger\"}}", result); doJavaScript(cod.GetJScript("easyAlert.timeShow", alert_msg)); } else { doJavaScript(cod.GetJScript("ListRefresh", string.Empty));//刷新列表 string alert_msg = string.Format("{{\"content\":\"{0}\", \"duration\":2,\"type\": \"danger\"}}", "上传成功!"); doJavaScript(cod.GetJScript("easyAlert.timeShow", alert_msg)); } } catch (Exception e) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "上传文件出错:" + e.ToString()); string alert_msg = string.Format("{{\"content\":\"{0}\", \"duration\":6,\"type\": \"danger\"}}", e.Message); doJavaScript(cod.GetJScript("easyAlert.timeShow", alert_msg)); } }
/// <summary> /// 撤销申请操作 /// </summary> /// <returns></returns> private string SubmitRevokeData() { try { if (string.IsNullOrEmpty(Get("doc_type"))) { return("单据类型不能为空!"); } if (string.IsNullOrEmpty(Get("seq_no"))) { return("单据编号不能为空!"); } string msg = string.Empty; bool bResult = WKF_ExternalInterface.getInstance().WKF_RevokeDeclare(Get("doc_type"), Get("seq_no"), user.User_Id, user.User_Role, Post("revokeMsg"), Get("nj"), Get("xy"), Get("bj"), Get("zy"), true, out msg); if (!bResult) { return(string.Format("撤销申请失败,原因:{0}", msg)); } return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_WARN, "撤销申请操作,出错:" + ex.ToString()); return("撤销申请失败!"); } }
/// <summary> /// 删除操作 /// </summary> /// <param name="id"></param> /// <returns></returns> private string Delete() { try { string[] strs = Get("ids").Split(','); for (int i = 0; i < strs.Length; i++) { if (strs[i].Length == 0) { continue; } var model = new Score_rank_info(); model.OID = strs[i].ToString(); ds.RetrieveObject(model); bool bDel = false; var transaction = ImplementFactory.GetDeleteTransaction <Score_rank_info>("Score_rank_infoDeleteTransaction"); transaction.EntityList.Add(model); bDel = transaction.Commit(); if (!bDel) { return("删除失败!"); } } return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "删除成绩信息失败:" + ex.ToString()); return("删除失败!"); } }
/// <summary> /// 是否可以进行撤销申请 /// </summary> /// <returns></returns> private string IsCanRevokeDeclare() { try { if (string.IsNullOrEmpty(Get("doc_type"))) { return("单据类型不能为空!"); } if (string.IsNullOrEmpty(Get("seq_no"))) { return("单据编号不能为空!"); } string strOut = WKF_ExternalInterface.getInstance().ChkRevoke(Get("doc_type"), Get("seq_no"), user.User_Role); if (string.IsNullOrEmpty(strOut)) { return(string.Empty); } else { return(strOut); } } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_WARN, "是否可以进行撤销申请,出错:" + ex.ToString()); return("不符合撤销申请要求!"); } }
/// <summary> /// 保存数据 /// </summary> /// <returns></returns> private string SaveData() { try { Qz_job_manage_set head = new Qz_job_manage_set(); head.OID = Post("OID"); if (head.OID == "") { head.OID = Guid.NewGuid().ToString(); } ds.RetrieveObject(head); head.SCH_YEAR = Post("SCH_YEAR"); head.SCH_TERM = Post("SCH_TERM"); head.IS_ENABLE = Post("IS_ENABLE"); head.DECLARE_START_TIME = Post("DECLARE_START_TIME"); head.DECLARE_END_TIME = Post("DECLARE_END_TIME"); head.REWARD_STD_B = comTran.ToDecimal(Post("REWARD_STD_B")); head.REWARD_UNIT_B = Post("REWARD_UNIT_B"); head.REWARD_STD_Y = comTran.ToDecimal(Post("REWARD_STD_Y")); head.REWARD_UNIT_Y = Post("REWARD_UNIT_Y"); head.OP_CODE = user.User_Id; head.OP_NAME = user.User_Name; head.OP_TIME = ComTranClass.getInstance().GetCurrLongDateTime(); ds.UpdateObject(head); return(head.OID); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "保存岗位申报基本设置出错:" + ex.ToString()); return(string.Empty); } }
/// <summary> /// 保存 /// </summary> /// <returns></returns> private string SaveData() { try { Score_rank_queue head = new Score_rank_queue(); head.OID = Guid.NewGuid().ToString(); ds.RetrieveObject(head); head.STU_TYPE = Post("STU_TYPE"); head.YEAR = Post("YEAR"); head.GRADE = Post("GRADE"); head.CLASSCODE = Post("CLASSCODE"); head.HANDLE_STATUS = "N"; head.CREATE_TIME = GetDateLongFormater(); head.CREATE_USER = user.User_Name; head.CREATE_USER_ID = user.User_Id; head.CREATE_TYPE = "M"; ds.UpdateObject(head); return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "新增计算排名队列失败:" + ex.ToString()); return("新增计算排名队列失败!"); } }
/// <summary> /// 删除数据 /// </summary> /// <returns></returns> private string DeleteData() { try { if (string.IsNullOrEmpty(Request.QueryString["id"])) { return("OID为空,不允许删除操作"); } Question_info head = new Question_info(); head.OID = Request.QueryString["id"].ToString(); ds.RetrieveObject(head); var transaction = ImplementFactory.GetDeleteTransaction <Question_info>("Question_infoDeleteTransaction"); transaction.EntityList.Add(head); if (!transaction.Commit()) { return("删除失败!"); } return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "问题反馈删除失败:" + ex.ToString()); return("删除失败!"); } }
/// <summary> /// 保存数据 /// </summary> /// <returns></returns> private string SaveData() { try { T_xt_department head = new T_xt_department(); head.DW = Post("DW").Trim(); ds.RetrieveObject(head); head.MC = Post("MC").Trim(); head.LX = Post("LX"); head.ZT = Post("ZT"); head.YWMC = Post("YWMC"); head.BZ = Post("BZ"); head.SEQUENCE = cod.ChangeInt(Post("SEQUENCE")); head.MANAGER = Post("hidAllMGR").TrimEnd(','); //管理员 head.ADDRESS = Post("ADDRESS"); //联系地址 ds.UpdateObject(head); //记录操作日志 return(head.DW); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "保存学院信息出错:" + ex.ToString()); return(string.Empty); } }
/// <summary> /// 编辑时首次加载学院HTML /// </summary> /// <returns></returns> private string GetXy_Edit() { try { if (string.IsNullOrEmpty(Get("user_id"))) { return(string.Empty); } string strSQL = string.Format("SELECT XY_CODE FROM UA_USER WHERE USER_ID = '{0}' ", Get("user_id")); string strXy = ds.ExecuteTxtScalar(strSQL).ToString(); if (string.IsNullOrEmpty(strXy)) { return(string.Empty); } string[] arrXy = strXy.Split(new char[] { ',' }); StringBuilder sbHtml = new StringBuilder(); foreach (string xy in arrXy) { if (string.IsNullOrEmpty(xy)) { continue; } sbHtml.Append("<input name=\"ua_xy\" id=\"" + xy + "\" type=\"checkbox\" value=\"" + xy + "\" class=\"flat-red\"/> <label for=\"" + xy + "\">" + cod.GetDDLTextByValue("ddl_all_department", xy) + "</label> "); } return(sbHtml.ToString()); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_WARN, ex.ToString()); return(string.Empty); } }
/// <summary> /// 删除数据 /// </summary> /// <returns></returns> private string DeleteData() { try { if (string.IsNullOrEmpty(Request.QueryString["id"])) { return("OID为空,不允许删除操作"); } Shoolar_apply_study_list head = new Shoolar_apply_study_list(); head.OID = Request.QueryString["id"].ToString(); ds.RetrieveObject(head); var transaction = ImplementFactory.GetDeleteTransaction <Shoolar_apply_study_list>("Shoolar_apply_study_listDeleteTransaction"); transaction.EntityList.Add(head); if (!transaction.Commit()) { return("删除失败!"); } return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_WARN, "奖助申请,删除学习科目数据失败:" + ex.ToString()); return("删除失败!"); } }
/// <summary> /// 保存数据 /// </summary> /// <returns></returns> private string SaveData() { try { Ua_user head = new Ua_user(); head.USER_ID = Post("USER_ID").Trim(); ds.RetrieveObject(head); head.USER_NAME = Post("USER_NAME"); head.USER_TYPE = Post("USER_TYPE"); head.XY_CODE = Post("hidAllXy"); head.STU_TYPE = Post("STU_TYPE"); head.IS_ASSISTANT = Post("IS_ASSISTANT"); head.LOGIN_PW = Post("LOGIN_PW"); if (Post("hidUserRoles").ToString().Length > 0) { head.USER_ROLE = Post("hidUserRoles").TrimEnd(new char[] { ',' }); } else { head.USER_ROLE = Post("hidUserRoles"); } head.CREATE_TIME = GetDateLongFormater(); head.CREATE_CODE = user.User_Id; head.CREATE_NAME = user.User_Name; ds.UpdateObject(head); return(head.USER_ID); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "用户保存失败:" + ex.ToString()); return(string.Empty); } }
private string GetNotice() { try { if (string.IsNullOrEmpty(Get("id"))) { return(string.Empty); } Notice_info head = new Notice_info(); head.OID = Get("id"); ds.RetrieveObject(head); StringBuilder json = new StringBuilder();//用来存放Json的 json.Append("{"); json.Append(Json.StringToJson(head.TITLE, "TITLE")); json.Append(","); json.Append(Json.StringToJson(head.SUB_TITLE, "SUB_TITLE")); json.Append(","); json.Append(Json.StringToJson(head.FUNCTION_ID, "FUNCTION_ID")); json.Append(","); json.Append(Json.StringToJson(head.START_TIME, "START_TIME")); json.Append(","); json.Append(Json.StringToJson(head.END_TIME, "END_TIME")); json.Append(","); json.Append(Json.StringToJson(head.ROLEID, "ROLEID")); json.Append("}"); return(json.ToString()); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "奖助项目设置,获得公告信息,出错:" + ex.ToString()); return(string.Empty); } }
/// <summary> /// 保存数据 /// </summary> /// <returns></returns> private string SaveData() { try { if (string.IsNullOrEmpty(Post("OID"))) { return("主键不能为空!"); } Insur_project_head model = new Insur_project_head(); model.OID = Post("OID"); ds.RetrieveObject(model); #region 发送信息核对信息 string strMsgOid = string.Empty; if (model.CHECK_MSG_ID.Length == 0) { strMsgOid = SendMsg(model.SEQ_NO); } else { //删除相关信息数据 string strDelMsgSql = string.Format("DELETE FROM MESSGE_INFO WHERE OID = '{0}' ", model.CHECK_MSG_ID); string strDelMsg_ListSql = string.Format("DELETE FROM MESSGE_ACCPTER WHERE MSG_OID = '{0}' ", model.CHECK_MSG_ID); ds.ExecuteTxtNonQuery(strDelMsgSql); ds.ExecuteTxtNonQuery(strDelMsg_ListSql); //重新发送信息 strMsgOid = SendMsg(model.SEQ_NO); } #endregion 发送信息核对信息 #region 保存信息核对 if (strMsgOid.Length > 0) { //清除核对信息 model.CHECK_START = Post("CHECK_START"); model.CHECK_END = Post("CHECK_END"); model.CHECK_IS_SEND = CValue.FLAG_Y; model.CHECK_MSG_ID = strMsgOid; model.CHECK_OP_CODE = user.User_Id; model.CHECK_OP_NAME = user.User_Name; model.CHECK_OP_TIME = GetDateLongFormater(); ds.UpdateObject(model); } #endregion 保存信息核对 return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "保存保险项目数据,出错:" + ex.ToString()); return("保存失败!"); } }
/// <summary> /// 提交数据 /// </summary> /// <returns></returns> private string SubmitData() { try { #region 基础校验 if (string.IsNullOrEmpty(Get("id"))) { return("请先保存数据之后再进行提交!"); } Shoolar_apply_head head = new Shoolar_apply_head(); head.OID = Get("id"); ds.RetrieveObject(head); if (head == null) { return("读取奖助申请信息出错,不允许提交!"); } #endregion 基础校验 string strMsg = string.Empty; string strOpNotes = string.Format("提交奖助申请操作"); if (!WKF_ExternalInterface.getInstance().WKF_BusDeclare(head.DOC_TYPE, head.SEQ_NO, user.User_Id, user.User_Role, strOpNotes, out strMsg)) { return(strMsg); } #region 往信息核对表中插入一条记录 //首先判断是否已经存在数据,已经存在不需要再次插入 string strSql = string.Format("SELECT COUNT(1) AS COUNT_NUM FROM SHOOLAR_APPLY_CHECK WHERE SEQ_NO = '{0}' ", head.SEQ_NO); int nCount = cod.ChangeInt(ds.ExecuteTxtScalar(strSql).ToString()); if (nCount == 0) { //提交成功之后,往信息核对表中插入一条记录 ProjectCheckHandleClass.getInstance().InsertIntoCheckInfo(head.SEQ_NO, head.STU_IDCARDNO, head.STU_BANKCODE); } #endregion 往信息核对表中插入一条记录 #region 申请时,插入一条文档编号 ComHandleClass.getInstance().InsertIntoBasicStuWordNo(head.STU_NUMBER, head.PROJECT_YEAR); #endregion 申请时,插入一条文档编号 return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "提交奖助申请信息,出错:" + ex.ToString()); return("提交失败!"); } }
/// <summary> /// 保存数据 /// </summary> /// <returns></returns> private string SaveData() { try { Basic_coun_info head = new Basic_coun_info(); head.OID = Post("OID"); if (head.OID.Length == 0) { head.OID = Guid.NewGuid().ToString(); head.SEQ_NO = HQ.InterfaceService.BusDataDeclareTransaction.getInstance().GetSeq_no("COU01"); } ds.RetrieveObject(head); head.ENO = Post("ENO"); head.NAME = Post("NAME"); head.SEX = Post("SEX"); head.HOMENUM = Post("HOMENUM"); head.POLISTATUS = Post("POLISTATUS"); head.GARDE = Post("GARDE"); head.ENTERTIME = Post("ENTERTIME"); head.ADDRESS = Post("ADDRESS"); head.MOBILENUM = Post("MOBILENUM"); head.EMAIL = Post("EMAIL"); head.UNIVE = Post("UNIVE"); head.FIXHPONE = Post("FIXHPONE"); head.MAJOR = Post("MAJOR"); head.PORJOB = Post("PORJOB"); head.POSTADDRESS = Post("POSTADDRESS"); head.OFFICEPHONE = Post("OFFICEPHONE"); head.FAX = Post("FAX"); head.NATIVEPLACE = Post("NATIVEPLACE"); head.NATION = Post("NATION"); head.DEPARTMENT = Post("DEPARTMENT"); head.IDCARDNO = Post("IDCARDNO"); head.OPER = user.User_Name; head.OPTIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ds.UpdateObject(head); if (string.IsNullOrEmpty(Post("OID"))) { LogDBHandleClass.getInstance().LogOperation(head.SEQ_NO, "辅导员基础信息管理", CValue.LOG_ACTION_TYPE_3, CValue.LOG_RECORD_TYPE_1, string.Format("新增辅导员信息:辅导员{0},姓名{1}", head.ENO, head.NAME), user.User_Id, user.User_Name, user.UserLoginIP); } else { LogDBHandleClass.getInstance().LogOperation(head.SEQ_NO, "辅导员基础信息管理", CValue.LOG_ACTION_TYPE_4, CValue.LOG_RECORD_TYPE_1, string.Format("修改辅导员信息:辅导员{0},姓名{1}", head.ENO, head.NAME), user.User_Id, user.User_Name, user.UserLoginIP); } InsertOrUpUser(head); return(head.OID); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "保存/更新辅导员数据,出错:" + ex.ToString()); return(string.Empty); } }
/// <summary> /// 调用易班取消授权接口(oauth/revoke_token)帮助开发者主动取消用户的授权 /// </summary> private void RevokeToken(YbSDK.Api.OauthApi oauthApi, string strAccess_token, string strUserId, string strUserName) { //退出时,调用易班取消授权接口(oauth/revoke_token)帮助开发者主动取消用户的授权 string strUrl = "https://openapi.yiban.cn/oauth/revoke_token"; string strParam = "client_id=" + oauthApi.context.Config.AppId + "&access_token=" + strAccess_token; string strResult = HttpMethods.HttpPost(strUrl, strParam);//返回状态说明:200-已注销、500-注销失败 if (!strResult.Contains("200")) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "取消用户" + strUserId + strUserName + "的授权失败!"); } }
/// <summary> /// 提交操作 /// </summary> /// <returns></returns> private string SaveData() { try { if (string.IsNullOrEmpty(Post("hidOid"))) { head.OID = Guid.NewGuid().ToString(); head.SEQ_NO = GetSeq_no(); GetValue(head); head.DOC_TYPE = this.Doc_type; head.DECL_NUMBER = user.User_Id; head.DECL_TIME = GetDateLongFormater(); var inserttrcn = ImplementFactory.GetInsertTransaction <Ua_class_group>("Ua_class_groupInsertTransaction"); inserttrcn.EntityList.Add(head); if (!inserttrcn.Commit()) { return("提交失败!"); } } else { head.OID = Post("hidOid"); ds.RetrieveObject(head); GetValue(head); head.DECL_NUMBER = user.User_Id; head.DECL_TIME = GetDateLongFormater(); var updatetrcn = ImplementFactory.GetUpdateTransaction <Ua_class_group>("Ua_class_groupUpdateTransaction", user.User_Name); if (!updatetrcn.Commit(head)) { return("提交失败!"); } } //提交编班申请 string strOpNotes = string.Format("提交编班申请操作"); string strMsg = string.Empty; if (!WKF_ExternalInterface.getInstance().WKF_BusDeclare(head.DOC_TYPE, head.SEQ_NO, user.User_Name, user.User_Role, strOpNotes, out strMsg)) { //20171017 ZZ 新增:由于编班没有暂存功能,所以编班提交失败或者没有权限提交,需要删除生成的数据。 string strDelSql = string.Format("DELETE FROM UA_CLASS_GROUP WHERE SEQ_NO = '{0}' ", head.SEQ_NO); ds.ExecuteTxtNonQuery(strDelSql); return(string.Format("编班提交失败,原因:{0}", strMsg)); } return(string.Empty); } catch (Exception ex) { //20171017 ZZ 新增:由于编班没有暂存功能,所以编班提交失败或者没有权限提交,需要删除生成的数据。 string strDelSql = string.Format("DELETE FROM UA_CLASS_GROUP WHERE SEQ_NO = '{0}' ", head.SEQ_NO); ds.ExecuteTxtNonQuery(strDelSql); LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "编班提交失败,原因:" + ex.ToString()); return("提交失败!"); } }
/// <summary> /// 保存附件 /// </summary> /// <param name="strFileName"></param> /// <param name="strFileDirectory"></param> /// <returns></returns> protected bool SaveFile(string strFileName, string strFileDirectory) { try { bool res = false; Insur_apply_check_file head = new Insur_apply_check_file(); if (string.IsNullOrEmpty(hidOid_File.Value)) { head.OID = Guid.NewGuid().ToString(); ds.RetrieveObject(head); head.SEQ_NO = hidRelationSeqNo_File.Value; head.FILE_TYPE = hidFile_FILE_TYPE.Value; head.FILE_NAME = hidFile_FILE_NAME.Value; head.FILE_SAVE_NAME = strFileName; strFileDirectory = strFileDirectory.Replace(@"\", @"/");//将字符串中所有反斜杠\替换成正斜杠/ head.FILE_DIRECTORY = strFileDirectory; var inserttrcn = ImplementFactory.GetInsertTransaction <Insur_apply_check_file>("Insur_apply_check_fileInsertTransaction"); inserttrcn.EntityList.Add(head); res = inserttrcn.Commit(); } else { head.OID = hidOid_File.Value; ds.RetrieveObject(head); head.FILE_TYPE = hidFile_FILE_TYPE.Value; head.FILE_NAME = hidFile_FILE_NAME.Value; head.FILE_SAVE_NAME = strFileName; strFileDirectory = strFileDirectory.Replace(@"\", @"/");//将字符串中所有反斜杠\替换成正斜杠/ head.FILE_DIRECTORY = strFileDirectory; var updatetrcn = ImplementFactory.GetUpdateTransaction <Insur_apply_check_file>("Insur_apply_check_fileUpdateTransaction", user.User_Name); res = updatetrcn.Commit(head); } if (res) { //保存核对表头的参保人员类型 Insur_apply_check check = InsurHandleClass.getInstance().GetApplyCheckInfo(head.SEQ_NO); if (check != null) { ds.RetrieveObject(check); check.APPLY_TYPE = hidFile_FILE_TYPE.Value; ds.UpdateObject(check); } } return(res); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "公告附件上传失败:" + ex.ToString()); return(false); } }