Esempio n. 1
0
        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());
        }
Esempio n. 2
0
        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);
        }
Esempio n. 3
0
        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);
        }
Esempio n. 4
0
        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));
        }