예제 #1
0
        /// <summary>
        /// 退回预录入
        /// </summary>
        /// <returns></returns>
        private string BackS()
        {
            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("退回预录入失败,原因:奖助申请信息读取失败!");
            }
            if (head.DECLARE_TYPE.Equals(CValue.DECLARE_TYPE_R))
            {
                return("退回预录入失败,原因:该奖助申请目前正在撤销申请阶段!");
            }

            //退回到预录入
            string strUpSql = string.Format("UPDATE SHOOLAR_APPLY_HEAD SET RET_CHANNEL='A0000',POS_CODE='',STEP_NO='',AUDIT_POS_CODE='' WHERE SEQ_NO = '{0}' ", head.SEQ_NO);

            if (ds.ExecuteTxtNonQuery(strUpSql) > 0)
            {
                //往审批流转表中插入一条记录
                WKF_ClientLogHandleCLass.getInstance().InsertClientLog(head.SEQ_NO, CValue.DOC_TYPE_BDM03, CValue.DECLARE_TYPE_D, CValue.STEP_D3, CValue.RET_CHANNEL_D3020, CValue.ROLE_TYPE_X, user.User_Name, "在系统运维操作下进行了退回预录入操作。", CValue.FLAG_Y);
            }

            return(string.Empty);
        }
예제 #2
0
        private string ChangeLevel()
        {
            string msg = string.Empty;

            try
            {
                string oid     = Get("id");
                string chg_lvl = Get("level");
                if (oid.Length == 0)
                {
                    return("主键为空");
                }
                Dst_stu_apply apply = new Dst_stu_apply();
                apply.OID = oid;
                ds.RetrieveObject(apply);
                if (Convert(chg_lvl) >= Convert(apply.LEVEL_CODE))
                {
                    return("只能修改为更高等级");
                }

                string opinion = cod.GetDDLTextByValue("ddl_dst_opinion", chg_lvl);
                string strSql  = string.Format("UPDATE DST_STU_APPLY SET IS_CHG_LVL = 'Y', BATCH_NO = '{1}', LEVEL_CODE = '{2}', LEVEL1 = '{2}', LEVEL2 = '{2}', LEVEL3 = '{2}', OPINION1 = '{3}', OPINION2 = '{3}', OPINION3 = '{3}' WHERE OID = '{0}'", oid, param_info != null ? param_info.BATCH_NO : string.Empty, chg_lvl, opinion);
                if (ds.ExecuteTxtNonQuery(strSql) > 0)
                {
                    //插入一条修改记录
                    WKF_ClientLogHandleCLass.getInstance().InsertClientLog(apply.SEQ_NO, CValue.DOC_TYPE_BDM01, CValue.DECLARE_TYPE_C, string.Empty, "修改成功", user.User_Role, user.User_Name, Get("notes"), CValue.FLAG_Y);
                }
                else
                {
                    msg = "修改等级失败";
                }
            }
            catch (Exception ex)
            {
                msg = "修改等级失败";
                LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "修改等级出错:" + ex.ToString());
            }

            return(msg);
        }