private string GetStudentData() { string strNumber = Get("number"); if (string.IsNullOrEmpty(strNumber)) { return("学号为空"); } head = DstApplyHandleClass.getInstance().GetDst_stu_apply(new Dictionary <string, string> { { "NUMBER", strNumber }, { "SCHYEAR", sch_info.CURRENT_YEAR } }); if (head == null) { head = new Dst_stu_apply(); object o = ds.ExecuteTxtScalar(string.Format("SELECT OID FROM Basic_stu_info WHERE NUMBER = '{0}'", strNumber)); if (o != null && o.ToString().Trim().Length > 0) { stu.OID = o.ToString(); ds.RetrieveObject(stu); CreateNewData(); } else { return("获取学生基本信息失败!"); } } StringBuilder sb = new StringBuilder(); sb.Append("{"); foreach (var val in GetValue(head)) { sb.Append(Json.StringToJson(val.Value, val.Name)); sb.Append(","); } sb.Remove(sb.Length - 1, 1);//去掉最后一个逗号 sb.Append("},"); if (sb[sb.Length - 1].Equals(',')) { sb.Remove(sb.Length - 1, 1);//去掉最后一个逗号 } return(sb.ToString()); }
private string GetMultiAuditID() { string ids = string.Empty; #region 查询 Dictionary <string, string> param = new Dictionary <string, string>(); string filter = cod.GetDataFilterString(true, "OP_CODE", "CLASS", "COLLEGE"); if (filter.Length > 0) { param.Add(filter.Substring(4, filter.Length - 4), string.Empty); } param.Add(string.Format(DataFilterHandleClass.getInstance().Pend_DataFilter(user.User_Role, CValue.DOC_TYPE_BDM01)), string.Empty); if (!string.IsNullOrEmpty(Get("COLLEGE"))) { param.Add("COLLEGE", Get("COLLEGE")); } if (!string.IsNullOrEmpty(Get("MAJOR"))) { param.Add("MAJOR", Get("MAJOR")); } if (!string.IsNullOrEmpty(Get("CLASS"))) { param.Add("CLASS", Get("CLASS")); } if (!string.IsNullOrEmpty(Get("NAME"))) { param.Add(string.Format("NAME LIKE '%{0}%' ", HttpUtility.UrlDecode(Get("NAME"))), string.Empty); } if (!string.IsNullOrEmpty(Get("SCHYEAR"))) { param.Add("SCHYEAR", Get("SCHYEAR")); } if (!string.IsNullOrEmpty(Get("RET_CHANNEL"))) { param.Add("RET_CHANNEL", Get("RET_CHANNEL")); } if (!string.IsNullOrEmpty(Get("DECLARE_TYPE"))) { param.Add("DECLARE_TYPE", Get("DECLARE_TYPE")); } if (!string.IsNullOrEmpty(Get("LEVEL_CODE"))) { if (user.User_Role.Equals(CValue.ROLE_TYPE_F)) { } else if (user.User_Role.Equals(CValue.ROLE_TYPE_Y)) { param.Add("LEVEL1", Get("LEVEL_CODE")); } else if (user.User_Role.Equals(CValue.ROLE_TYPE_X)) { param.Add("LEVEL2", Get("LEVEL_CODE")); } else { param.Add("1", "2"); } } List <Dst_stu_apply> applyList = DstApplyHandleClass.getInstance().GetDst_stu_applyArray(param); if (applyList == null) { return("查询批量审批申请数据出错!"); } #endregion 查询 foreach (Dst_stu_apply apply in applyList) { ids += apply.OID + ","; } ids = ids.TrimEnd(','); return(ids); }
private string CheckOperate(string strFlag) { string result = string.Empty; string need = string.Empty; bool can = DstParamHandleClass.getInstance().IsCanApply(out result, out need); string oid = Get("id"); string number = Get("number"); if (!strFlag.Equals("add") && string.IsNullOrEmpty(oid)) { return("主键不能为空!"); } Dst_stu_apply apply = new Dst_stu_apply(); apply.OID = oid; ds.RetrieveObject(apply); if (strFlag.Equals("add")) { if (!can) { return("未开放申请,请联系管理员!"); } else { if (need.Equals("Y")) { object o = ds.ExecuteTxtScalar(string.Format("SELECT OID FROM DST_FAMILY_SITUA WHERE NUMBER='{0}' AND RET_CHANNEL='{1}'", number, CValue.RET_CHANNEL_A0010)); if (o == null || o.ToString().Length == 0) { result = "未完成家庭情况调查!"; } } } head = DstApplyHandleClass.getInstance().GetDst_stu_apply(new Dictionary <string, string> { { "NUMBER", number }, { "SCHYEAR", sch_info.CURRENT_YEAR } }); if (head != null) { result = "不允许重复申请!"; } return(result); } else if (strFlag.Equals("modi")) { if (!can) { return("未开放申请,请联系管理员!"); } if (!apply.BATCH_NO.Equals(param_info.BATCH_NO)) { if (apply.LEVEL_CODE.Length > 0 && !(apply.RET_CHANNEL.Equals(CValue.RET_CHANNEL_A0000))) { return("已有认定档次,不允许操作!"); } } else if (!(apply.RET_CHANNEL.Equals(CValue.RET_CHANNEL_A0000))) { return("该状态下不允许操作!"); } } else if (strFlag.Equals("decl")) { if (!can) { return("未开放申请,请联系管理员!"); } if (!apply.BATCH_NO.Equals(param_info.BATCH_NO)) { if (apply.LEVEL_CODE.Length > 0 && !(apply.RET_CHANNEL.Equals(CValue.RET_CHANNEL_A0000))) { return("已有认定档次,不允许操作!"); } } else if (!(apply.RET_CHANNEL.Equals(CValue.RET_CHANNEL_A0000))) { return("该状态下不允许操作!"); } result = CheckDeclare(apply.NUMBER); } else if (strFlag.Equals("del")) { if (!(apply.RET_CHANNEL.Equals(CValue.RET_CHANNEL_A0000))) { return("该状态下不允许操作!"); } } else if (strFlag.Equals("revoke")) { //辅导员审核前学生自行撤销 if (user.User_Role.Equals(CValue.ROLE_TYPE_S)) { if (apply.POS_CODE.Equals(CValue.ROLE_TYPE_F) && !apply.NUMBER.Equals(user.User_Id)) { return("非本人不允许进行操作!"); } if (!(apply.RET_CHANNEL.Equals(CValue.RET_CHANNEL_D1000) && apply.POS_CODE.Equals(CValue.ROLE_TYPE_F))) { return("该状态下不允许撤销!"); } } } return(result); }
private string CheckMulti() { #region 获得批量审核数据集合 Dictionary <string, string> param = new Dictionary <string, string>(); string filter = cod.GetDataFilterString(true, "OP_CODE", "CLASS", "COLLEGE"); if (filter.Length > 0) { param.Add(filter.Substring(4, filter.Length - 4), string.Empty); } param.Add(string.Format(DataFilterHandleClass.getInstance().Pend_DataFilter(user.User_Role, CValue.DOC_TYPE_BDM01)), string.Empty); if (!string.IsNullOrEmpty(Get("COLLEGE"))) { param.Add("COLLEGE", Get("COLLEGE")); } if (!string.IsNullOrEmpty(Get("MAJOR"))) { param.Add("MAJOR", Get("MAJOR")); } if (!string.IsNullOrEmpty(Get("CLASS"))) { param.Add("CLASS", Get("CLASS")); } if (!string.IsNullOrEmpty(Get("NAME"))) { param.Add(string.Format("NAME LIKE '%{0}%' ", HttpUtility.UrlDecode(Get("NAME"))), string.Empty); } if (!string.IsNullOrEmpty(Get("SCHYEAR"))) { param.Add("SCHYEAR", Get("SCHYEAR")); } if (!string.IsNullOrEmpty(Get("RET_CHANNEL"))) { param.Add("RET_CHANNEL", Get("RET_CHANNEL")); } if (!string.IsNullOrEmpty(Get("DECLARE_TYPE"))) { param.Add("DECLARE_TYPE", Get("DECLARE_TYPE")); } if (!string.IsNullOrEmpty(Get("LEVEL_CODE"))) { if (user.User_Role.Equals(CValue.ROLE_TYPE_F)) { } else if (user.User_Role.Equals(CValue.ROLE_TYPE_Y)) { param.Add("LEVEL1", Get("LEVEL_CODE")); } else if (user.User_Role.Equals(CValue.ROLE_TYPE_X)) { param.Add("LEVEL2", Get("LEVEL_CODE")); } else { param.Add("1", "2"); } } if (!string.IsNullOrEmpty(Get("NUMBER"))) { param.Add(string.Format("NUMBER LIKE '%{0}%' ", HttpUtility.UrlDecode(Get("NUMBER"))), string.Empty); } if (!string.IsNullOrEmpty(Get("BATCH_NO"))) { param.Add("BATCH_NO", Get("BATCH_NO")); } List <Dst_stu_apply> applyList = DstApplyHandleClass.getInstance().GetDst_stu_applyArray(param); if (applyList == null) { return("查询批量审批申请数据出错!"); } #endregion 获得批量审核数据集合 int i = 0; string ret_channel = string.Empty; string pos_code = string.Empty; string level = string.Empty; foreach (Dst_stu_apply apply in applyList) { if (apply.OID.Length == 0) { continue; } if (apply.POS_CODE.Equals(WKF_VLAUES.POST_CODE_F))//辅导员不允许批量审核 { return("不符合批量审核的条件!"); } if (!apply.DECLARE_TYPE.Equals(WKF_VLAUES.DECLARE_TYPE_D)) { return("不符合批量审核的条件,原因:选择的单据申请类型不一致!"); } if (i > 0 && !(apply.RET_CHANNEL.Equals(ret_channel) && apply.POS_CODE.Equals(pos_code))) { return("不符合批量审核的条件,原因:选择的单据审核状态不一致!"); } if (i > 0 && !level.Equals(user.User_Role.Equals(CValue.ROLE_TYPE_Y) ? apply.LEVEL1 : apply.LEVEL2)) { return("不符合批量审核的条件,原因:选择的单据前级推荐档次不一致!"); } ret_channel = apply.RET_CHANNEL; pos_code = apply.POS_CODE; if (user.User_Role.Equals(CValue.ROLE_TYPE_Y)) { level = apply.LEVEL1; } else if (user.User_Role.Equals(CValue.ROLE_TYPE_X)) { level = apply.LEVEL2; } i++; } return(string.Format("{0}^{1}", pos_code, level)); }