Ejemplo n.º 1
0
        /// <summary>
        /// 保存数据
        /// </summary>
        /// <returns></returns>
        private string SaveData()
        {
            string            oid     = Post("hidOid_Content");
            bool              res     = false;
            Peer_project_list notboth = new Peer_project_list();

            if (string.IsNullOrEmpty(oid))
            {
                oid = notboth.OID = Guid.NewGuid().ToString();
                ds.RetrieveObject(notboth);
                notboth.SEQ_NO       = Post("hidSeqNo_Content");
                notboth.SEQUEUE      = cod.ChangeInt(Post("SEQUEUE"));
                notboth.PEER_CONTENT = Post("PEER_CONTENT");
                var inserttrcn = ImplementFactory.GetInsertTransaction <Peer_project_list>("Peer_project_listInsertTransaction");
                inserttrcn.EntityList.Add(notboth);
                res = inserttrcn.Commit();
            }
            else
            {
                notboth.OID = oid;
                ds.RetrieveObject(notboth);
                notboth.SEQUEUE      = cod.ChangeInt(Post("SEQUEUE"));
                notboth.PEER_CONTENT = Post("PEER_CONTENT");
                var updatetrcn = ImplementFactory.GetUpdateTransaction <Peer_project_list>("Peer_project_listUpdateTransaction", user.User_Name);
                res = updatetrcn.Commit(notboth);
            }
            if (res)
            {
                return(oid);
            }
            else
            {
                return(string.Empty);
            }
        }
Ejemplo n.º 2
0
        /// <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("删除失败!");
            }
        }
Ejemplo n.º 3
0
        private string DeleteData()
        {
            var oid = Get("id");

            if (string.IsNullOrEmpty(oid))
            {
                return("主键为空,不允许删除操作");
            }

            head.OID = oid;
            ds.RetrieveObject(head);

            bool bDel        = false;
            var  transaction = ImplementFactory.GetDeleteTransaction <Qz_job_manage>("Qz_job_manageDeleteTransaction");

            transaction.EntityList.Add(head);
            bDel = transaction.Commit();

            if (!bDel)
            {
                return("删除失败!");
            }
            else
            {
                return(string.Empty);
            }
        }
Ejemplo n.º 4
0
        private string DeleteWorkDetail()
        {
            var oid = Get("id");

            if (string.IsNullOrEmpty(oid))
            {
                return("主键为空,不允许删除操作");
            }

            Qz_job_proof_list list = new Qz_job_proof_list();

            list.OID = oid;
            ds.RetrieveObject(list);

            bool bDel        = false;
            var  transaction = ImplementFactory.GetDeleteTransaction <Qz_job_proof_list>("Qz_job_proof_listDeleteTransaction");

            transaction.EntityList.Add(list);
            bDel = transaction.Commit();

            if (!bDel)
            {
                return(string.Empty);
            }
            else
            {
                decimal reward = JobProofHandleClass.getInstance().CalculateReward(list.SEQ_NO);
                ds.ExecuteTxtNonQuery(string.Format("UPDATE QZ_JOB_PROOF_HEAD SET REWARD = {1} WHERE SEQ_NO = '{0}'", list.SEQ_NO, reward));
                return(Math.Round(reward, 2).ToString());
            }
        }
Ejemplo n.º 5
0
        private string CheckOnly(string oid, string schyear, string batch)
        {
            if (string.IsNullOrEmpty(schyear) || string.IsNullOrEmpty(batch))
            {
                return("请输入必填项!");
            }
            Dictionary <string, string> param = new Dictionary <string, string>()
            {
                { "SCHYEAR", schyear },
                { "BATCH_NO", batch }
            };

            if (oid.Length > 0)
            {
                param.Add(string.Format("OID NOT IN ('{0}')", oid), string.Empty);
            }
            var selectTran = ImplementFactory.GetSelectTransaction <Dst_param_info>("Dst_param_infoSelectTransaction", param);
            var selectList = selectTran.SelectAll();

            if (selectList == null || selectList.Count <= 0)
            {
                return(string.Empty);
            }
            return("该学年该批次设置已存在!");
        }
Ejemplo n.º 6
0
        private string CheckOnly()
        {
            string oid      = Get("oid");
            string sch_year = Get("year");
            string sch_term = Get("term");

            if (string.IsNullOrEmpty(sch_year) || string.IsNullOrEmpty(sch_term))
            {
                return("请输入必填项!");
            }
            Dictionary <string, string> param = new Dictionary <string, string>()
            {
                { "SCH_YEAR", sch_year },
                { "SCH_TERM", sch_term }
            };

            if (oid.Length > 0)
            {
                param.Add(string.Format("OID NOT IN ('{0}')", oid), string.Empty);
            }
            var selectTran = ImplementFactory.GetSelectTransaction <Qz_job_manage_set>("Qz_job_manage_setSelectTransaction", param);
            var selectList = selectTran.SelectAll();

            if (selectList == null || selectList.Count <= 0)
            {
                return(string.Empty);
            }
            return("该学年、学期设置已存在!");
        }
Ejemplo n.º 7
0
        /// <summary>
        /// 删除主表数据并且把子表数据也删除
        /// </summary>
        /// <returns></returns>
        private string DeleteData()
        {
            var code = Post("OID");

            if (string.IsNullOrEmpty(code))
            {
                return("主键为空,不允许删除操作");
            }

            var model = new Dst_level_info();

            model.OID = code;
            ds.RetrieveObject(model);

            bool bDel        = false;
            var  transaction = ImplementFactory.GetDeleteTransaction <Dst_level_info>("Dst_level_infoDeleteTransaction");

            transaction.EntityList.Add(model);
            bDel = transaction.Commit();
            if (bDel)
            {
                return("");
            }
            return("删除失败!");
        }
Ejemplo n.º 8
0
        /// <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("删除失败!");
            }
        }
Ejemplo n.º 9
0
 protected override SelectTransaction <Shoolar_apply_head> GetSelectTransaction()
 {
     //运维界面:不符合奖助申请条件学生名单
     //只查询 学院审核通过、学校审核通过 的数据,因为在辅导员审核、学院审核的时候 已经做了当前项目限制条件的过滤筛选
     param.Add(string.Format(" RET_CHANNEL IN ('{0}','{1}') ", CValue.RET_CHANNEL_D2010, CValue.RET_CHANNEL_D4000), string.Empty);
     return(ImplementFactory.GetSelectTransaction <Shoolar_apply_head>("Shoolar_apply_headSelectTransaction", param));
 }
Ejemplo n.º 10
0
        /// <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("删除失败!");
            }
        }
Ejemplo n.º 11
0
        private string DeleteData()
        {
            var code = Get("id");

            if (string.IsNullOrEmpty(code))
            {
                return("主键为空,不允许删除操作");
            }

            head.OID = code;
            ds.RetrieveObject(head);

            bool bDel        = false;
            var  transaction = ImplementFactory.GetDeleteTransaction <Dst_stu_apply>("Dst_stu_applyDeleteTransaction");

            transaction.EntityList.Add(head);
            bDel = transaction.Commit();

            if (!bDel)
            {
                return("删除失败!");
            }
            else
            {
                return("");
            }
        }
Ejemplo n.º 12
0
        private string DeleteGrant()
        {
            Dst_stu_grant grant = new Dst_stu_grant();
            var           code  = Get("id");

            if (string.IsNullOrEmpty(code))
            {
                return("主键为空,不允许删除操作");
            }

            grant.OID = code;
            ds.RetrieveObject(grant);

            bool bDel        = false;
            var  transaction = ImplementFactory.GetDeleteTransaction <Dst_stu_grant>("Dst_stu_grantDeleteTransaction");

            transaction.EntityList.Add(grant);
            bDel = transaction.Commit();

            if (!bDel)
            {
                return("删除失败!");
            }
            else
            {
                return("");
            }
        }
Ejemplo n.º 13
0
        private bool CreateNewData()
        {
            head.NUMBER         = stu.NUMBER;
            head.NAME           = stu.NAME;
            head.SEX            = stu.SEX;
            head.BIRTH_DATE     = stu.GARDE;
            head.NATION         = stu.NATION;
            head.IDCARDNO       = stu.IDCARDNO;
            head.POLISTATUS     = stu.POLISTATUS;
            head.COLLEGE        = stu.COLLEGE;
            head.MAJOR          = stu.MAJOR;
            head.CLASS          = stu.CLASS;
            head.GRADE          = stu.EDULENTH;
            head.TELEPHONE      = stu.MOBILENUM;
            head.HOME_ADDRESS   = stu.ADDRESS;
            head.HOME_PHONE     = stu.HOMENUM;
            head.SCHYEAR        = sch_info.CURRENT_YEAR;
            head.OID            = Guid.NewGuid().ToString();
            head.SEQ_NO         = GetSeq_no();
            head.DOC_TYPE       = this.Doc_type;
            head.RET_CHANNEL    = Ret_Channel_A0000;
            head.DECLARE_TYPE   = WKF_VLAUES.DECLARE_TYPE_D;
            head.OP_TIME        = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            head.OP_CODE        = user.User_Id;
            head.OP_NAME        = user.User_Name;
            head.ANNUAL_INCOME  = GetIncome(head.NUMBER, "year");
            head.MONTHLY_INCOME = GetIncome(head.NUMBER, "month");
            var inserttrcn = ImplementFactory.GetInsertTransaction <Dst_stu_apply>("Dst_stu_applyInsertTransaction");

            inserttrcn.EntityList.Add(head);
            return(inserttrcn.Commit());
        }
Ejemplo n.º 14
0
        /// <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("删除失败!");
            }
        }
Ejemplo n.º 15
0
        private string DeleteMember()
        {
            bool   bDel = false;
            string oid  = Get("oid");

            if (string.IsNullOrEmpty(oid))
            {
                return("主键为空,不允许删除!");
            }

            Dst_family_members m = new Dst_family_members();

            m.OID = oid;
            ds.RetrieveObject(m);
            var transaction = ImplementFactory.GetDeleteTransaction <Dst_family_members>("Dst_family_membersDeleteTransaction");

            transaction.EntityList.Add(m);
            bDel = transaction.Commit();
            if (bDel)
            {
                string msg;
                if (!FamilySurveyHandleClass.getInstance().CalculateIncome(m.SEQ_NO, out msg))
                {
                    msg = "计算家庭年收入异常";
                }
                return(msg);
            }

            return("删除失败!");
        }
Ejemplo n.º 16
0
        private string DeleteLog()
        {
            try
            {
                string fromDATE = Post("Fromdate");//获取页面文本信息。
                string toDATE   = Post("Todate");
                Dictionary <string, string> param = new Dictionary <string, string> {
                    { string.Format(" LOG_DATE BETWEEN '{0} 00:00:00,000' AND '{1} 23:59:59,999'", fromDATE, toDATE), "" }
                };                                                                                                                     //筛选出数据的SQL。
                var selecttrcn = ImplementFactory.GetSelectTransaction <Log_sys_operation>("Log_sys_operationSelectTransaction", param);
                var list       = selecttrcn.SelectAll();

                var deletetrcn = ImplementFactory.GetDeleteTransaction <Log_sys_operation>("Log_sys_operationDeleteTransaction");
                for (int i = 0; i < list.Count; i++)
                {
                    deletetrcn.EntityList.Add(new Log_sys_operation()
                    {
                        OID = list[i].OID//获取筛选出的数据的OID,并添加到删除事务里。
                    });
                }

                if (list.Count > 0 && deletetrcn.Commit())
                {
                    return("");
                }
                else
                {
                    return("删除不成功!");
                }
            }
            catch (Exception ex)
            {
                return(string.Format("删除日志异常,原因:{0}", ex.Message));
            }
        }
Ejemplo n.º 17
0
 /// <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("删除失败!");
     }
 }
Ejemplo n.º 18
0
        private string CheckOnly()
        {
            string oid        = Get("oid");
            string sch_year   = Get("year");
            string sch_term   = Get("term");
            string year_month = Get("month");

            Dictionary <string, string> param = new Dictionary <string, string>()
            {
                { "SCH_YEAR", sch_year },
                { "SCH_TERM", sch_term },
                { "YEAR_MONTH", year_month }
            };

            if (oid.Length > 0)
            {
                param.Add(string.Format("OID NOT IN ('{0}')", oid), string.Empty);
            }
            var selectTran = ImplementFactory.GetSelectTransaction <Qz_job_proof_set>("Qz_job_proof_setSelectTransaction", param);
            var selectList = selectTran.SelectAll();

            if (selectList == null || selectList.Count <= 0)
            {
                return(string.Empty);
            }
            return("该学年、学期设置已存在!");
        }
Ejemplo n.º 19
0
        /// <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("删除失败!");
            }
        }
Ejemplo n.º 20
0
        private string Delete()
        {
            try
            {
                if (Request.QueryString["id"].Length <= 0)
                {
                    return("菜单ID参数不正确,重新操作或者联系管理人员进行处理");
                }

                var deletetrcn = ImplementFactory.GetDeleteTransaction <Ua_function>("Ua_functionDeleteTransaction");
                deletetrcn.EntityList.Add(new Ua_function()
                {
                    FUNCTIONID = Request.QueryString["id"]
                });
                if (deletetrcn.Commit())
                {
                    //把子菜单也一并删除
                    string strSQL = string.Format("DELETE FROM UA_FUNCTION WHERE PARENTID = '{0}' ", Request.QueryString["id"].ToString());
                    ds.ExecuteTxtNonQuery(strSQL);
                    return("删除成功");
                }
                return("操作失败!");
            }
            catch (Exception ex)
            {
                return("删除失败!原因:" + ex.Message);
            }
        }
Ejemplo n.º 21
0
 private string Save()
 {
     if (Request.QueryString["optype"].Equals("add"))
     {
         model.FUNCTIONID = Guid.NewGuid().ToString();
         ds.RetrieveObject(model);
         model.PARENTID = Request.QueryString["id"];
         GetValue(model);
         var inserttrcn = ImplementFactory.GetInsertTransaction <Ua_function>("Ua_functionInsertTransaction", user.User_Name);
         inserttrcn.EntityList.Add(model);
         if (inserttrcn.Commit())
         {
             return("保存成功");
         }
         return("保存失败");
     }
     else
     {
         model.FUNCTIONID = Request.QueryString["id"];
         ds.RetrieveObject(model);
         GetValue(model);
         var updatetrcn = ImplementFactory.GetUpdateTransaction <Ua_function>("Ua_functionUpdateTransaction", user.User_Name);
         if (updatetrcn.Commit(model))
         {
             return("保存成功");
         }
         return("保存失败");
     }
 }
Ejemplo n.º 22
0
        private string GetNode()
        {
            string             functionid = Get("id");
            List <Ua_function> listAll    = ImplementFactory.GetSelectTransaction <Ua_function>("Ua_functionSelectTransaction", new Dictionary <string, string> {
                { "FUNCTIONID", functionid }
            }).SelectAll();
            string json = "{}";

            if (listAll.Count > 0)
            {
                model = listAll[0];
                JsonObj jsonObj = new JsonObj();
                jsonObj.DESCRIPTION = model.DESCRIPTION;
                jsonObj.FUNCTIONID  = model.FUNCTIONID;
                jsonObj.ICON        = model.ICON;
                jsonObj.NAME        = model.NAME;
                jsonObj.NOTICE_FLAG = model.NOTICE_FLAG;
                jsonObj.SEQUENCE    = model.SEQUENCE.ToString();
                jsonObj.SHOWINMENU  = model.SHOWINMENU;
                jsonObj.QUICK_FLAG  = model.QUICK_FLAG;
                jsonObj.YJS_FLAG    = model.YJS_FLAG;
                jsonObj.URL         = model.URL;
                jsonObj.HASROLE     = getRole4FunId(model.FUNCTIONID);
                json = JsonConvert.SerializeObject(jsonObj);
            }
            return(json);
        }
Ejemplo n.º 23
0
 protected override SelectTransaction <Shoolar_apply_head> GetSelectTransaction()
 {
     if (!string.IsNullOrEmpty(Get("page_from")))
     {
         if (Get("page_from").ToString().Equals("approve_pend"))/// 待处理查看
         {
             param.Add(string.Format(DataFilterHandleClass.getInstance().Pend_DataFilter(user.User_Role, CValue.DOC_TYPE_BDM03)), string.Empty);
         }
         else if (Get("page_from").ToString().Equals("approve_proce"))   /// 已处理查看
         {
             param.Add(string.Format(DataFilterHandleClass.getInstance().Proc_DataFilter(user.User_Role, CValue.DOC_TYPE_BDM03)), string.Empty);
         }
         else if (Get("page_from").ToString().Equals("result")) //查询都是审批通过的数据
         {
             param.Add("RET_CHANNEL", CValue.RET_CHANNEL_D4000);
         }
         else if (Get("page_from").ToString().Equals("nation_schoolar")) //全国信息:查询都是审批通过的数据
         {
             param.Add("RET_CHANNEL", CValue.RET_CHANNEL_D4000);
         }
         else if (Get("page_from").ToString().Equals("result_outline")) //查询线下项目数据
         {
             param.Add("PROJECT_CLASS", "OUTLINE");
         }
     }
     return(ImplementFactory.GetSelectTransaction <Shoolar_apply_head>("Shoolar_apply_headSelectTransaction", param));
 }
Ejemplo n.º 24
0
        /// <summary>
        ///保存方法
        /// </summary>
        /// <returns></returns>
        private string SaveData()
        {
            bool           result = false;
            Peer_coun_head head   = new Peer_coun_head();

            if (string.IsNullOrEmpty(Post("hidOid")))//新增
            {
                head.OID    = Guid.NewGuid().ToString();
                head.SEQ_NO = GetSeq_no();
                GetPageValue(head);
                var inserttrcn = ImplementFactory.GetInsertTransaction <Peer_coun_head>("Peer_coun_headInsertTransaction");
                inserttrcn.EntityList.Add(head);
                result = inserttrcn.Commit();
            }
            else//修改
            {
                head.OID = Post("hidOid");
                ds.RetrieveObject(head);
                GetPageValue(head);
                var updatetrcn = ImplementFactory.GetUpdateTransaction <Peer_coun_head>("Peer_coun_headUpdateTransaction", user.User_Name);
                result = updatetrcn.Commit(head);
            }

            if (result)
            {
                //成功之后保存表体
                SaveDataList(head.SEQ_NO, head.PEER_SEQ_NO);
                return(head.OID);
            }
            else
            {
                return(string.Empty);
            }
        }
Ejemplo n.º 25
0
 protected override SelectTransaction <Messge_info> GetSelectTransaction()
 {
     if (!user.User_Id.Equals(ApplicationSettings.Get("AdminUser").ToString()))
     {
         //过滤:接收人与发送人都可以看到所属信息
         param.Add("SEND_CODE", user.User_Id);
     }
     return(ImplementFactory.GetSelectTransaction <Messge_info>("Messge_infoSelectTransaction", param));
 }
Ejemplo n.º 26
0
 protected override SelectTransaction <Basic_coun_info> GetSelectTransaction()
 {
     if (!string.IsNullOrEmpty(Get("page_from")))
     {
         if (Get("page_from").ToString().Equals("index"))/// 首页的用户档案进来的,只展示自己的
         {
             param.Add("ENO", user.User_Id);
         }
     }
     return(ImplementFactory.GetSelectTransaction <Basic_coun_info>("Basic_coun_infoSelectTransaction", param));
 }
Ejemplo n.º 27
0
 protected override SelectTransaction <Basic_stu_info> GetSelectTransaction()
 {
     if (!string.IsNullOrEmpty(Get("page_from")))
     {
         if (Get("page_from").ToString().Equals("nosubmit"))/// 页面来源:未提交修改学生信息
         {
             param.Add(string.Format("NUMBER NOT IN (SELECT NUMBER FROM BASIC_STU_INFO_MODI)"), string.Empty);
         }
     }
     return(ImplementFactory.GetSelectTransaction <Basic_stu_info>("Basic_stu_infoSelectTransaction", param));
 }
Ejemplo n.º 28
0
 protected override SelectTransaction <Insur_apply_check_file> GetSelectTransaction()
 {
     if (Request.QueryString["seq_no"] != null && Request.QueryString["seq_no"].Length != 0)
     {
         param.Add("SEQ_NO", Request.QueryString["seq_no"]);
     }
     else
     {
         param.Add(" 1=2 ", "");
     }
     return(ImplementFactory.GetSelectTransaction <Insur_apply_check_file>("Insur_apply_check_fileSelectTransaction", param));
 }
Ejemplo n.º 29
0
        protected override SelectTransaction <Peer_coun_head> GetSelectTransaction()
        {
            if (!string.IsNullOrEmpty(Get("page_from")))
            {
                if (Get("page_from").ToString().Equals("result")) //查询都是结束的
                {
                    param.Add(string.Format("PEER_SEQ_NO IN (SELECT SEQ_NO FROM PEER_PROJECT_HEAD WHERE PEER_END < '{0}' ) ", GetDateShortFormater()), "");
                }
            }

            return(ImplementFactory.GetSelectTransaction <Peer_coun_head>("Peer_coun_headSelectTransaction", param));
        }
Ejemplo n.º 30
0
 protected override SelectTransaction <Shoolar_project_num> GetSelectTransaction()
 {
     if (Request.QueryString["seq_no"] != null && Request.QueryString["seq_no"].Length != 0)
     {
         param.Add("SEQ_NO", Request.QueryString["seq_no"]);
     }
     else
     {
         param.Add(" 1=2 ", "");
     }
     return(ImplementFactory.GetSelectTransaction <Shoolar_project_num>("Shoolar_project_numSelectTransaction", param));
 }