/// <summary>
/// 获得页面数据
/// </summary>
/// <param name="model"></param>
private void GetPageValue(Peer_coun_head model)
{
string strCounId = ComHandleClass.getInstance().ByStuNumberGetCounCode(user.User_Id);
Basic_coun_info coun = CounHandleClass.getInstance().GetCounInfo_Obj(strCounId);
if (coun != null)
{
model.COUN_ID = coun.ENO;
model.COUN_NAME = coun.NAME;
model.COUN_DEPARTMENT = coun.DEPARTMENT;
}
Basic_stu_info stu = StuHandleClass.getInstance().GetStuInfo_Obj(user.User_Id);
if (stu != null)
{
model.STU_NAME = stu.NAME;
model.STU_NUMBER = stu.NUMBER;
model.XY = stu.COLLEGE;
model.ZY = stu.MAJOR;
model.GRADE = stu.EDULENTH;
model.CLASS_CODE = stu.CLASS;
}
Peer_project_head peer = PeerInfoHandleClass.getInstance().GetPeerInfoHead(Post("hidPeerSeqNo"));
if (peer != null)
{
model.PEER_SEQ_NO = peer.SEQ_NO;
model.PEER_NAME = peer.PEER_NAME;
model.PEER_YEAR = peer.PEER_YEAR;
}
model.OP_TIME = GetDateLongFormater();
}
public void InitStudentInfo(Basic_stu_info stuInfo)
{
number = stuInfo.NUMBER;
name = stuInfo.NAME;
us_name = stuInfo.US_NAME;
idcardno = stuInfo.IDCARDNO;
sex = cod.GetDDLTextByValue("ddl_xb", stuInfo.SEX);
heigth = stuInfo.HEIGTH;
weigth = stuInfo.WEIGTH;
genius = stuInfo.GENIUS;
health = stuInfo.HEALTH;
stutype = cod.GetDDLTextByValue("ddl_basic_stu_type", stuInfo.STUTYPE);
enrolling = cod.GetDDLTextByValue("ddl_rxfs", stuInfo.ENROLLING);
email = stuInfo.EMAIL;
qq = stuInfo.QQNUM;
birthday = stuInfo.GARDE;
grade = stuInfo.EDULENTH;
xy = cod.GetDDLTextByValue("ddl_department", stuInfo.COLLEGE);
zy = cod.GetDDLTextByValue("ddl_zy", stuInfo.MAJOR);
classname = cod.GetDDLTextByValue("ddl_class", stuInfo.CLASS);
system = cod.GetDDLTextByValue("ddl_edu_system", stuInfo.SYSTEM);
nation = cod.GetDDLTextByValue("ddl_mz", stuInfo.NATION);
polistatus = cod.GetDDLTextByValue("ddl_zzmm", stuInfo.POLISTATUS);
entertime = stuInfo.ENTERTIME;
register = cod.GetDDLTextByValue("ddl_xjzt", stuInfo.REGISTER);
nativeplace = ComHandleClass.getInstance().ConvertAddress(stuInfo.NATIVEPLACE);
stuplace = ComHandleClass.getInstance().ConvertAddress(stuInfo.STUPLACE);
address = ComHandleClass.getInstance().ConvertAddress(stuInfo.ADDRESS);
registplace = ComHandleClass.getInstance().ConvertAddress(stuInfo.REGISTPLACE);
}
private void GetPrintData(string oid)
{
#region 奖助申请信息
//奖助申请信息
head.OID = oid;
ds.RetrieveObject(head);
if (head == null)
{
return;
}
strPrintCode = ComHandleClass.getInstance().GetStuWorNo(head.STU_NUMBER, head.PROJECT_YEAR);
head.XY = cod.GetDDLTextByValue("ddl_department", head.XY);
head.ZY = cod.GetDDLTextByValue("ddl_zy", head.ZY);
head.STUDY_LEVEL = cod.GetDDLTextByValue("ddl_apply_study_level", head.STUDY_LEVEL);
//大文本数据
if (ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO) != null)
{
txt = ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO);
}
#endregion 奖助申请信息
#region 学生基础信息
//学生基础信息
if (StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER) != null)
{
stu = StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER);
stu.NATION = cod.GetDDLTextByValue("ddl_mz", stu.NATION);
stu.SYSTEM = cod.GetDDLTextByValue("ddl_edu_system", stu.SYSTEM);
}
#endregion 学生基础信息
}
private string SubmitData()
{
string saveResult = SaveData();
if (saveResult.Length > 0)
{
string msg = "";
bool result = WKF_ExternalInterface.getInstance().WKF_BusDeclare(head.DOC_TYPE, head.SEQ_NO, user.User_Id, user.User_Role, "", out msg);
if (!result)
{
return("提交失败！");
}
else
{
//提交时，清除推荐档次、推荐理由
head.LEVEL_CODE = string.Empty;
head.LEVEL1 = string.Empty;
head.OPINION1 = string.Empty;
head.LEVEL2 = string.Empty;
head.OPINION2 = string.Empty;
head.LEVEL3 = string.Empty;
head.OPINION3 = string.Empty;
head.AUDIT_POS_CODE = string.Empty;
//提交时，插入一条文档编号
ComHandleClass.getInstance().InsertIntoBasicStuWordNo(head.NUMBER, head.SCHYEAR);
head.SERIAL_NO = ComHandleClass.getInstance().GetStuWorNo(head.NUMBER, head.SCHYEAR);
ds.UpdateObject(head);
return("");
}
}
else
{
return("提交失败");
}
}
/// <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>
/// <param name="project"></param>
/// <param name="strStuType"></param>
private void InsertIntoLifeApplyData(Shoolar_project_head project, string strStuType)
{
if (strStuType.Contains("Y"))
{
strStuType += ",P";
}
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add(string.Format(" STUTYPE IN ({0}) ", ComHandleClass.getInstance().GetNoRepeatAndNoEmptyStringSql(strStuType)), string.Empty);
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 strDelHead = string.Format("DELETE FROM SHOOLAR_APPLY_HEAD WHERE PROJECT_SEQ_NO = '{0}' AND STU_NUMBER = '{1}' ", project.SEQ_NO, stu.NUMBER);
ds.ExecuteTxtNonQuery(strDelHead);
Shoolar_apply_head head = InsertIntoApplyHead(project, stu);
//删除重复数据，再插入
string strDelChk = string.Format("DELETE FROM SHOOLAR_APPLY_CHECK WHERE SEQ_NO = '{0}' ", head.SEQ_NO);
ds.ExecuteTxtNonQuery(strDelChk);
ProjectCheckHandleClass.getInstance().InsertIntoCheckInfo(head.SEQ_NO, head.STU_IDCARDNO, head.STU_BANKCODE);
}
}
private string DeclData()
{
string msg = SaveData();
if (msg.Length > 0)
{
var oid = Post("OID");
if (string.IsNullOrEmpty(oid))
{
return("主键为空，不允许提交");
}
head.OID = oid;
ds.RetrieveObject(head);
msg = CheckFamilyInfo(head.SEQ_NO) + CheckMembers(head.SEQ_NO);
if (msg.Length > 0)
{
return(msg);
}
//学生个人信息是否审核通过
if (!ComHandleClass.getInstance().IsPassStudentModify(head.NUMBER))
{
return("个人信息修改未审核通过，不允许提交");
}
//家庭调查表提交后不需要流转
Wkf_rule_queue rule = WKF_RuleQueueHandleCLass.getInstance().GetCurrRule(HQ.Model.CValue.DOC_TYPE_BDM04, WKF_VLAUES.DECLARE_TYPE_D, HQ.Model.CValue.STEP_A0, HQ.Model.CValue.RET_CHANNEL_A0010, user.User_Role);
if (rule == null)
{
msg = "没有权限提交";
}
else
{
head.OP_CODE = user.User_Id;
head.OP_NAME = user.User_Name;
head.OP_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
head.DECL_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//提交时，插入一条文档编号
ComHandleClass.getInstance().InsertIntoBasicStuWordNo(head.NUMBER, head.SCHYEAR);
head.SERIAL_NO = ComHandleClass.getInstance().GetStuWorNo(head.NUMBER, head.SCHYEAR);
head.RET_CHANNEL = HQ.Model.CValue.RET_CHANNEL_A0010;
ds.UpdateObject(head);
//增加一条记录
if (!FamilySurveyHandleClass.getInstance().CreateRecord(head))
{
msg = "提交成功，但生成调查记录失败";
}
}
}
else
{
msg = "提交失败";
}
return(msg);
}
/// <summary>
/// 获得带班辅导员姓名
/// </summary>
/// <param name="CLASS"></param>
/// <returns></returns>
private string GetCOUN(string CLASS)
{
string COUN = ComHandleClass.getInstance().ByClassCodeGetCounName(CLASS);
if (string.IsNullOrWhiteSpace(COUN))
{
return(string.Empty);
}
return(COUN);
}
/// <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 GetCounName()
{
string CounCode = ComHandleClass.getInstance().ByStuNumberGetCounCode(user.User_Id);
string CounName = string.Empty;
Basic_coun_info coun = CounHandleClass.getInstance().GetCounInfo_Obj(CounCode);
if (coun != null)
{
CounName = coun.NAME;
}
return(CounName);
}
/// <summary>
/// 绑定界面信息
/// </summary>
protected void Bind()
{
string OID = Request.QueryString["id"];
if (!string.IsNullOrEmpty(OID))
{
head.OID = OID;
ds.RetrieveObject(head);
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("SEQ_NO", head.SEQ_NO);
Shoolar_apply_head apply_head = ProjectApplyHandleClass.getInstance().GetApplyHeadInfo(param);
strPrintCode = ComHandleClass.getInstance().GetStuWorNo(apply_head.STU_NUMBER, apply_head.PROJECT_YEAR);
img_url = head.FILE_DIRECTORY + "/" + head.FILE_SAVE_NAME;
}
}
private string GetApplyData(string oid)
{
if (string.IsNullOrEmpty(oid))
{
return("{}");
}
Hashtable ddl = new Hashtable();
ddl["SEX"] = "ddl_xb";
ddl["COLLEGE"] = "ddl_department";
ddl["MAJOR"] = "ddl_zy";
ddl["CLASS"] = "ddl_class";
ddl["NATION"] = "ddl_mz";
ddl["POLISTATUS"] = "ddl_zzmm";
DataTable dt = ds.ExecuteTxtDataTable(string.Format("SELECT * FROM DST_FAMILY_SITUA WHERE OID = '{0}' ", oid));
if (dt == null || dt.Rows.Count == 0)
{
return("{}");
}
else
{
cod.ConvertTabDdl(dt, ddl);
dt.Columns.Add("PROVINCE", Type.GetType("System.String"));
dt.Columns.Add("CITY", Type.GetType("System.String"));
dt.Columns.Add("COUNTY", Type.GetType("System.String"));
dt.Columns.Add("ADD_STREET", Type.GetType("System.String"));
foreach (DataRow dr in dt.Rows)
{
dr["PROVINCE"] = ComHandleClass.getInstance().GetAddrSplit(dr["ADDRESS"].ToString(), 0);
dr["CITY"] = ComHandleClass.getInstance().GetAddrSplit(dr["ADDRESS"].ToString(), 1);
dr["COUNTY"] = ComHandleClass.getInstance().GetAddrSplit(dr["ADDRESS"].ToString(), 2);
dr["ADD_STREET"] = ComHandleClass.getInstance().GetAddrSplit(dr["ADDRESS"].ToString(), 3);
dr["ADDRESS"] = ComHandleClass.getInstance().ConvertAddress(dr["ADDRESS"].ToString());
dr["IS_ORPHAN"] = dr["IS_ORPHAN"].ToString().Equals("Y") ? "1" : "0";
dr["IS_SINGLE"] = dr["IS_SINGLE"].ToString().Equals("Y") ? "1" : "0";
dr["IS_DISABLED"] = dr["IS_DISABLED"].ToString().Equals("Y") ? "1" : "0";
dr["IS_MARTYRS"] = dr["IS_MARTYRS"].ToString().Equals("Y") ? "1" : "0";
dr["IS_OTHER"] = dr["IS_OTHER"].ToString().Equals("Y") ? "1" : "0";
dr["IS_DESTITUTE"] = dr["IS_DESTITUTE"].ToString().Equals("Y") ? "1" : "0";
}
}
return(Json.DatatableToJson(dt));
}
/// <summary>
/// 判断是否满足评议条件：是学生并且有辅导员
/// </summary>
/// <returns></returns>
private string ChkIsCanPeer()
{
Basic_stu_info stu = StuHandleClass.getInstance().GetStuInfo_Obj(user.User_Id);
if (stu == null)
{
return("该用户不是学生，无法进行辅导员评议！");
}
string strCounId = ComHandleClass.getInstance().ByStuNumberGetCounCode(user.User_Id);
if (strCounId.Length == 0)
{
return("该学生所属的班级没有设置辅导员，无法进行辅导员评议！");
}
return(string.Empty);
}
/// <summary>
/// 通过学号判断是否是辅导员所带班级的学生
/// </summary>
/// <returns></returns>
private string ChkStuInfo()
{
Basic_stu_info info = StuHandleClass.getInstance().GetStuInfo_Obj(Get("stuno"));
if (info == null)
{
return(string.Empty);
}
ComHandleClass chc = new ComHandleClass();
string strFClass = chc.ByFGetClassCode(user.User_Id);
if (!strFClass.Contains(info.CLASS))
{
return("录入的学号不是所带班级的学生，请确认！");
}
return(string.Empty);
}
/// <summary>
/// 批量退回核对信息
/// </summary>
/// <returns></returns>
private string MultiBack()
{
try
{
if (string.IsNullOrEmpty(Post("SELECT_OID")))
{
return("未选择数据项！");
}
if (string.IsNullOrEmpty(Get("backtype")) || string.IsNullOrEmpty(Get("step")))
{
return("操作类型或者核对阶段为空！");
}
string strWhere = ComHandleClass.getInstance().GetNoRepeatAndNoEmptyStringSql(Post("SELECT_OID"));
string strSQL = string.Empty;
string strSQL_1 = string.Empty;
switch (Get("backtype"))
{
case "N": //退回学生未核对
strSQL = string.Format("UPDATE INSUR_APPLY_CHECK SET S_CHECK_CODE ='',S_CHECK_NAME ='',S_CHECK_TIME='',F_CHECK_CODE='',F_CHECK_NAME='',F_CHECK_TIME='',Y_CHECK_CODE='',Y_CHECK_NAME='',Y_CHECK_TIME='',CHECK_STEP='',IS_REFUND='N',REFUND_NOTES='',REFUND_INSUR_NAME='',BACK_CODE='{1}',BACK_NAME='{2}',BACK_TIME='{3}' WHERE OID IN ({0}) AND CHECK_STEP='{4}' ", strWhere, user.User_Id, user.User_Name, GetDateLongFormater(), Get("step"));
ds.ExecuteTxtNonQuery(strSQL);
break;
case "1": //退回学生已核对
strSQL = string.Format("UPDATE INSUR_APPLY_CHECK SET F_CHECK_CODE='',F_CHECK_NAME='',F_CHECK_TIME='',Y_CHECK_CODE='',Y_CHECK_NAME='',Y_CHECK_TIME='',CHECK_STEP='',IS_REFUND='N',REFUND_NOTES='',REFUND_INSUR_NAME='',BACK_CODE='{1}',BACK_NAME='{2}',BACK_TIME='{3}' WHERE OID IN ({0}) AND S_CHECK_CODE = '' AND CHECK_STEP='{4}' ", strWhere, user.User_Id, user.User_Name, GetDateLongFormater(), Get("step"));
ds.ExecuteTxtNonQuery(strSQL);
strSQL_1 = string.Format("UPDATE INSUR_APPLY_CHECK SET F_CHECK_CODE='',F_CHECK_NAME='',F_CHECK_TIME='',Y_CHECK_CODE='',Y_CHECK_NAME='',Y_CHECK_TIME='',CHECK_STEP='1',IS_REFUND='N',REFUND_NOTES='',REFUND_INSUR_NAME='',BACK_CODE='{1}',BACK_NAME='{2}',BACK_TIME='{3}' WHERE OID IN ({0}) AND S_CHECK_CODE != '' AND CHECK_STEP='{4}' ", strWhere, user.User_Id, user.User_Name, GetDateLongFormater(), Get("step"));
ds.ExecuteTxtNonQuery(strSQL_1);
break;
case "2": //退回辅导员已核对
strSQL = string.Format("UPDATE INSUR_APPLY_CHECK SET Y_CHECK_CODE='',Y_CHECK_NAME='',Y_CHECK_TIME='',CHECK_STEP='2',BACK_CODE='{1}',BACK_NAME='{2}',BACK_TIME='{3}' WHERE OID IN ({0}) AND CHECK_STEP='{4}' ", strWhere, user.User_Id, user.User_Name, GetDateLongFormater(), Get("step"));
ds.ExecuteTxtNonQuery(strSQL);
break;
}
return(string.Format("批量退回成功！"));
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "保险核对信息批量核对出错：" + ex.ToString());
return("批量退回失败！");
}
}
/// <summary>
/// 获取辅导员所带班级HTML
/// </summary>
/// <returns></returns>
private string GetFdyClassData()
{
string strSQL = string.Format("SELECT CLASSCODE AS VALUE, CLASSNAME AS TEXT FROM BASIC_CLASS_INFO WHERE 1=1 ");
string strWhere = string.Empty;
string strOrder = " ORDER BY CLASSCODE ASC ";
ComHandleClass chc = new ComHandleClass();
if (user.User_Role.Equals("S"))
{
strWhere += string.Format(" AND CLASSCODE = '{0}' ", chc.BySGetClassCode(user.User_Id));
}
//用户角色是辅导员的，只能看到所带班级的数据
if (user.User_Role.Equals("F"))
{
string strFClass = chc.GetNoRepeatAndNoEmptyStringSql(chc.ByFGetClassCode(user.User_Id));
if (!string.IsNullOrEmpty(strFClass))
{
strWhere += string.Format(" AND CLASSCODE IN ({0})", strFClass);
}
else
{
strWhere += string.Format(" AND 1=2 ", strFClass);
}
}
strSQL = strSQL + strWhere + strOrder;
DataTable dt = ds.ExecuteTxtDataTable(strSQL);
StringBuilder sbHtml = new StringBuilder();
foreach (DataRow row in dt.Rows)
{
if (row == null)
{
continue;
}
sbHtml.Append("<div class=\"form-group col-sm-12\">");
sbHtml.Append("<div class=\"col-sm-8\">");
sbHtml.Append("<input name=\"fdy_class\" id=\"" + row["VALUE"].ToString() + "\" type=\"checkbox\" value=\"" + row["VALUE"].ToString() + "\" class=\"flat-red\"/> <label for=\"" + row["VALUE"].ToString() + "\">" + row["TEXT"].ToString() + "</label> ");
sbHtml.Append("</div>");
sbHtml.Append("</div>");
}
return(sbHtml.ToString());
}
public void InitCounInfo(Basic_coun_info counInfo)
{
eno = counInfo.ENO;
name = counInfo.NAME;
idcardno = counInfo.IDCARDNO;
sex = cod.GetDDLTextByValue("ddl_xb", counInfo.SEX);
email = counInfo.EMAIL;
mobilenum = counInfo.MOBILENUM;
officephone = counInfo.OFFICEPHONE;
birthday = counInfo.GARDE;
department = cod.GetDDLTextByValue("ddl_all_department", counInfo.COLLEGE);
zy = cod.GetDDLTextByValue("ddl_zy", counInfo.MAJOR);
nation = cod.GetDDLTextByValue("ddl_mz", counInfo.NATION);
polistatus = cod.GetDDLTextByValue("ddl_zzmm", counInfo.POLISTATUS);
entertime = counInfo.ENTERTIME;
porjob = counInfo.PORJOB;
nativeplace = ComHandleClass.getInstance().ConvertAddress(counInfo.NATIVEPLACE);
address = ComHandleClass.getInstance().ConvertAddress(counInfo.ADDRESS);
}
/// <summary>
/// 选择时加载学院HTML
/// </summary>
/// <returns></returns>
private string AddManager()
{
try
{
#region 排除重复学院
if (string.IsNullOrEmpty(Post("hidAllMGR")))
{
return(string.Empty);
}
string strSel = ComHandleClass.getInstance().GetNoRepeatAndNoEmptyStringSql(Post("hidAllMGR"));
#endregion 排除重复学院
#region 学院HTML
string strSQL = string.Format("SELECT USER_ID, USER_NAME FROM UA_USER WHERE USER_ID IN ({0})", strSel);
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=\"MANAGER\" id=\"" + row["USER_ID"].ToString() + "\" type=\"checkbox\" value=\"" + row["USER_ID"].ToString() + "\" class=\"flat-red\"/> <label for=\"" + row["USER_ID"].ToString() + "\">" + row["USER_NAME"].ToString() + "</label> ");
}
return(sbHtml.ToString());
#endregion 学院HTML
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_WARN, "单位信息管理，管理员加载失败：" + ex.ToString());
return(string.Empty);
}
}
/// <summary>
/// 选择时加载学院HTML
/// </summary>
/// <returns></returns>
private string GetXy_Add()
{
try
{
#region 排除重复学院
if (string.IsNullOrEmpty(Post("hidAllXy")))
{
return(string.Empty);
}
string strSel = ComHandleClass.getInstance().GetNoRepeatAndNoEmptyStringSql(Post("hidAllXy"));
#endregion 排除重复学院
#region 学院HTML
string strSQL = string.Format("SELECT dw, mc FROM t_xt_department WHERE dw IN ({0}) ", strSel);
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=\"ua_xy\" id=\"" + row["dw"].ToString() + "\" type=\"checkbox\" value=\"" + row["dw"].ToString() + "\" class=\"flat-red\"/> <label for=\"" + row["dw"].ToString() + "\">" + row["mc"].ToString() + "</label> ");
}
return(sbHtml.ToString());
#endregion 学院HTML
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_WARN, "用户信息管理，学院加载失败：" + ex.ToString());
return(string.Empty);
}
}
/// <summary>
///保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
try
{
//先删除数据再新增
string strSQL = string.Format("DELETE FROM SHOOLAR_APPLY_TXT WHERE SEQ_NO = '{0}' ", Get("seq_no"));
if (ds.ExecuteTxtNonQuery(strSQL) < 0)
{
return("保存大文本数据失败！");
}
var inserttrcn = ImplementFactory.GetInsertTransaction <Shoolar_apply_txt>("Shoolar_apply_txtInsertTransaction");
Shoolar_apply_txt head = new Shoolar_apply_txt();
head.OID = Guid.NewGuid().ToString();
head.SEQ_NO = Get("seq_no");
inserttrcn.EntityList.Add(head);
if (!inserttrcn.Commit())
{
return("保存大文本数据失败！");
}
//重新保存界面的文本数据
StringBuilder strTxt = new StringBuilder();
strTxt.AppendFormat("APPLY_REASON = '{0}', ", Post("APPLY_REASON")); //申请理由
strTxt.AppendFormat("SKILL_INFO = '{0}', ", Post("SKILL_INFO")); //英语、计算机过级情况
strTxt.AppendFormat("PUBLISH_INFO = '{0}', ", Post("PUBLISH_INFO")); //论文发表、获得专利等情况
strTxt.AppendFormat("MOTTO = '{0}', ", Post("MOTTO")); //人生格言
strTxt.AppendFormat("TEACHER_INFO = '{0}', ", Post("TEACHER_INFO")); //师长点评
strTxt.AppendFormat("MODEL_INFO = '{0}' ", Post("MODEL_INFO")); //事迹正文
if (!ComHandleClass.getInstance().UpdateTextContent(Get("seq_no"), "SEQ_NO", strTxt.ToString(), "SHOOLAR_APPLY_TXT"))
{
return("保存大文本数据失败！");
}
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "奖助申请，保存大文本数据失败：" + ex.ToString());
return(string.Empty);
}
}
/// <summary>
/// 选择时加载专业HTML
/// </summary>
/// <returns></returns>
private string GetZy_Add()
{
try
{
#region 排除重复专业
if (string.IsNullOrEmpty(Post("hidAllZy")))
{
return(string.Empty);
}
string strSel = ComHandleClass.getInstance().GetNoRepeatAndNoEmptyStringSql(Post("hidAllZy"));
#endregion 排除重复专业
#region 专业HTML
string strSQL = string.Format("SELECT zy, mc FROM t_jx_zy WHERE zy IN ({0}) ", strSel);
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"].ToString() + "\" type=\"checkbox\" value=\"" + row["zy"].ToString() + "\" class=\"flat-red\"/> <label for=\"" + row["zy"].ToString() + "\">" + row["mc"].ToString() + "</label> ");
}
return(sbHtml.ToString());
#endregion 专业HTML
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_WARN, "奖助项目设置，选择时加载专业HTML，出错：" + ex.ToString());
return(string.Empty);
}
}
/// <summary>
/// 修改密码事件
/// </summary>
/// <returns></returns>
private string Save()
{
try
{
Ua_user head = new Ua_user();
head.USER_ID = user.User_Id;
ds.RetrieveObject(head);
head.LOGIN_PW = Post("new_pw");
ds.UpdateObject(head);
UpCookie();
ComHandleClass.getInstance().SendMailUseGmail(Post("send_email").Trim(), "学生资助信息管理系统密码修改", string.Format("您在 {0} 时，修改了学生资助信息管理系统的登录密码，新登录密码为：{1}", GetDateLongFormater(), Post("new_pw")));
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "学生资助信息管理系统密码修改，失败：" + ex.ToString());
return(string.Format("密码修改失败！"));
}
}
/// <summary>
/// 拆班操作
/// </summary>
/// <returns></returns>
private string ChaiClass()
{
try
{
if (string.IsNullOrEmpty(Get("classcode")) || string.IsNullOrEmpty(Get("chai_num")))
{
return("班级代码或者拆班个人不能为空！");
}
int nChai = cod.ChangeInt(Get("chai_num"));
Basic_class_info classInfo = new Basic_class_info();
classInfo.CLASSCODE = Get("classcode");
ds.RetrieveObject(classInfo);
if (classInfo == null)
{
return("班级代码获取班级信息为空！");
}
for (int i = 0; i < nChai; i++)
{
Basic_class_info classInfo_chai = new Basic_class_info();
classInfo_chai.CLASSCODE = ComHandleClass.getInstance().GetClassCode(classInfo.STU_TYPE, classInfo.XY, classInfo.ZY, classInfo.GRADE);
ds.RetrieveObject(classInfo_chai);
classInfo_chai.PARENT_CLASSCODE = Get("classcode");
classInfo_chai.CLASSNAME = GetClassName_Chai(classInfo.CLASSCODE, classInfo.CLASSNAME);
classInfo_chai.XY = classInfo.XY;
classInfo_chai.ZY = classInfo.ZY;
classInfo_chai.GRADE = classInfo.GRADE;
classInfo_chai.STU_TYPE = classInfo.STU_TYPE;
classInfo_chai.OP_CODE = user.User_Id;
classInfo_chai.OP_NAME = user.User_Name;
classInfo_chai.OP_TIME = GetDateLongFormater();
ds.UpdateObject(classInfo_chai);
}
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "拆班失败：" + ex.ToString());
return("拆班失败！");
}
}
private string GetApplyData()
{
if (string.IsNullOrEmpty(Get("id")))
{
return("{}");
}
string number = string.Empty;
Hashtable ddl = new Hashtable();
ddl["SCHYEAR"] = "ddl_year_type";
ddl["SEX"] = "ddl_xb";
ddl["COLLEGE"] = "ddl_department";
ddl["MAJOR"] = "ddl_zy";
ddl["CLASS"] = "ddl_class";
ddl["NATION"] = "ddl_mz";
ddl["POLISTATUS"] = "ddl_zzmm";
DataTable dt = ds.ExecuteTxtDataTable(string.Format("SELECT *, '' AS PRE_LEVEL FROM DST_STU_APPLY WHERE OID = '{0}' ", Get("id")));
if (dt == null || dt.Rows.Count == 0)
{
return("{}");
}
else
{
cod.ConvertTabDdl(dt, ddl);
foreach (DataRow dr in dt.Rows)
{
number = dr["NUMBER"].ToString();
dr["PRE_LEVEL"] = ConverPreLevel(dr["POS_CODE"].ToString(), dr["LEVEL1"].ToString(), dr["LEVEL2"].ToString());
dr["HOME_ADDRESS"] = ComHandleClass.getInstance().ConvertAddress(dr["HOME_ADDRESS"].ToString());
if (dr["RET_CHANNEL"].ToString().Equals(CValue.RET_CHANNEL_A0000))
{
dr["ANNUAL_INCOME"] = comTran.ToDecimal(GetIncome(number, "year"));
dr["MONTHLY_INCOME"] = comTran.ToDecimal(GetIncome(number, "month"));
}
}
}
return(Json.DatatableToJson(dt));
}
/// <summary>
/// 查询批量审核数据集合
/// </summary>
/// <returns></returns>
private DataTable GetMultiCheckData()
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("SELECT T.*,ROW_NUMBER() OVER(ORDER BY T.CHK_TIME DESC) RN ");
strSql.AppendFormat("FROM( ");
strSql.AppendFormat("SELECT A.*, ");
strSql.AppendFormat("A.PROJECT_CLASS AS PROJECT_CLASS_NAME, ");
strSql.AppendFormat("A.PROJECT_TYPE AS PROJECT_TYPE_NAME, ");
strSql.AppendFormat("A.PROJECT_YEAR AS PROJECT_YEAR_NAME, ");
strSql.AppendFormat("A.XY AS XY_NAME, ");
strSql.AppendFormat("A.ZY AS ZY_NAME, ");
strSql.AppendFormat("A.CLASS_CODE AS CLASS_CODE_NAME, ");
strSql.AppendFormat("B.OID AS CHECK_OID, ");
strSql.AppendFormat("B.OLD_IDCARDNO,B.OLD_BANKCODE, ");
strSql.AppendFormat("B.NEW_IDCARDNO,B.NEW_BANKCODE, ");
strSql.AppendFormat("B.CHECK_STEP,B.CHECK_STEP AS CHECK_STEP_NAME, ");
strSql.AppendFormat("B.S_CHECK_TIME,B.F_CHECK_TIME,B.Y_CHECK_TIME ");
strSql.AppendFormat("FROM (SELECT A.*,B.CHECK_START, B.CHECK_END FROM SHOOLAR_APPLY_HEAD A LEFT JOIN SHOOLAR_PROJECT_HEAD B ");
strSql.AppendFormat("ON A.PROJECT_SEQ_NO = B.SEQ_NO) A ");
strSql.AppendFormat("LEFT JOIN SHOOLAR_APPLY_CHECK B ");
strSql.AppendFormat("ON A.SEQ_NO = B.SEQ_NO ");
strSql.AppendFormat(") T WHERE 1=1 ");
strSql.AppendFormat("AND T.RET_CHANNEL = 'D4000' ");
//ZZ 20180324 修改：由于现在线下项目也需要线上核对 所以这个过滤条件先去掉
//strSql.AppendFormat("AND T.PROJECT_CLASS != 'OUTLINE' ");//排除线下的项目
strSql.AppendFormat(cod.GetDataFilterString(true, "STU_NUMBER", "CLASS_CODE", "XY"));
strSql.AppendFormat(GetSearchWhere_MultiCheck());
//ZZ 20171107 ：新增
if (!user.User_Role.Equals(CValue.ROLE_TYPE_X))//不是校级管理员时，都需要经过勾选过滤
{
string strSelectIds = ComHandleClass.getInstance().GetNoRepeatAndNoEmptyStringSql(Post("SELECT_OID"));
if (strSelectIds.Length > 0)
{
strSql.AppendFormat("AND T.OID IN ({0}) ", strSelectIds);
}
}
return(ds.ExecuteTxtDataTable(strSql.ToString()));
}
/// <summary>
/// 获得信息接收人
/// </summary>
/// <returns></returns>
private Dictionary <string, string> GetAccpter()
{
if (string.IsNullOrEmpty(Post("hidAllUser")))
{
return(null);
}
#region 排除重复用户
if (string.IsNullOrEmpty(Post("hidAllUser")))
{
return(null);
}
string strSel = ComHandleClass.getInstance().GetNoRepeatAndNoEmptyStringSql(Post("hidAllUser"));
#endregion 排除重复用户
#region 接收人
Dictionary <string, string> resultIDic = new Dictionary <string, string>();
string strSQL = string.Format("SELECT USER_ID, USER_NAME FROM UA_USER WHERE USER_ID IN ({0}) ", strSel);
DataTable dt = ds.ExecuteTxtDataTable(strSQL);
if (dt == null)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
if (row == null)
{
continue;
}
resultIDic.Add(row["USER_ID"].ToString(), row["USER_NAME"].ToString());
}
return(resultIDic);
#endregion 接收人
}
/// <summary>
/// 获得所选专业
/// </summary>
/// <returns></returns>
private Dictionary <string, string> GetZy()
{
if (string.IsNullOrEmpty(Post("hidAllZy")))
{
return(null);
}
#region 排除重复专业
if (string.IsNullOrEmpty(Post("hidAllZy")))
{
return(null);
}
string strSel = ComHandleClass.getInstance().GetNoRepeatAndNoEmptyStringSql(Post("hidAllZy"));
#endregion 排除重复专业
#region 专业
Dictionary <string, string> resultIDic = new Dictionary <string, string>();
string strSQL = string.Format("SELECT zy, mc FROM t_jx_zy WHERE zy IN ({0}) ", strSel);
DataTable dt = ds.ExecuteTxtDataTable(strSQL);
if (dt == null)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
if (row == null)
{
continue;
}
resultIDic.Add(row["zy"].ToString(), row["mc"].ToString());
}
return(resultIDic);
#endregion 专业
}
/// <summary>
/// 查找不符合的SEQ_NO单据
/// </summary>
/// <returns></returns>
private string GetNotFitSeqNo(string where)
{
string strResult = string.Empty;
string strSQL = string.Format("SELECT * FROM SHOOLAR_APPLY_HEAD WHERE RET_CHANNEL IN ('{0}','{1}') {2}", CValue.RET_CHANNEL_D2010, CValue.RET_CHANNEL_D4000, where);
DataTable dt = ds.ExecuteTxtDataTable(strSQL);
if (dt == null || dt.Rows.Count == 0)
{
return(ComHandleClass.getInstance().GetNoRepeatAndNoEmptyStringSql(strResult));
}
foreach (DataRow row in dt.Rows)
{
if (row == null)
{
continue;
}
if (GetIsFitLimit(row["STU_NUMBER"].ToString(), row["PROJECT_SEQ_NO"].ToString()).Equals(CValue.FLAG_N))
{
strResult += row["SEQ_NO"].ToString() + ",";
}
}
return(ComHandleClass.getInstance().GetNoRepeatAndNoEmptyStringSql(strResult));
}
/// <summary>
/// 通过学院、专业、年级获得所属班级
/// </summary>
/// <returns></returns>
private string Get_Class()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT CLASSCODE AS VALUE,CLASSNAME AS TEXT FROM BASIC_CLASS_INFO ");
strSql.Append("WHERE 1=1 ");
//ZZ 20171024 修改：由于研究生与本科生班级规则不同，所有查询有所改变
if (!string.IsNullOrEmpty(Get("xy_code")))
{
strSql.AppendFormat("AND XY = '{0}' ", Get("xy_code"));
}
if (!string.IsNullOrEmpty(Get("zy_code")))
{
strSql.AppendFormat("AND (ZY = '{0}' OR ZY = '') ", Get("zy_code"));
}
if (!string.IsNullOrEmpty(Get("grade_code")))
{
strSql.AppendFormat("AND GRADE = '{0}' ", Get("grade_code"));
}
if (!user.User_Id.Equals(ApplicationSettings.Get("AdminUser").ToString()))
{
if (user.User_Role.Equals("F"))
{
string strFClass = ComHandleClass.getInstance().ByFGetClassCode(user.User_Id);
if (strFClass.Length > 0)
{
strSql.AppendFormat("AND CLASSCODE IN ({0}) ", ComHandleClass.getInstance().GetNoRepeatAndNoEmptyStringSql(strFClass));
}
}
}
strSql.Append("ORDER BY CLASSCODE ASC ");
comdata cod = new comdata();
return(cod.GetComboxJsonStr(ds.ExecuteTxtDataTable(strSql.ToString())));
}
