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