Example #1
0
    public void   GetTempalte(string quarterID, string templateNo)
    {
        DataTable     dtTemplate     = RectInterviewBus.GetTemplateInfo(quarterID);
        StringBuilder sbTemplateInfo = new StringBuilder();

        //数据存在的时候
        if (dtTemplate != null && dtTemplate.Rows.Count > 0)
        {
            //遍历所有模板信息
            for (int i = 0; i < dtTemplate.Rows.Count; i++)
            {
                //获取模板编号
                string no = GetSafeData.ValidateDataRow_String(dtTemplate.Rows[i], "TemplateNo");
                //获取模板主题
                string title = GetSafeData.ValidateDataRow_String(dtTemplate.Rows[i], "Title");

                if (no == templateNo)
                {
                    ddlTemplate.Items.Add(new ListItem(title, no));

                    //sbTemplateInfo.AppendLine("<option value=\"" + no + "\" selected=\"selected\">" + title + "</option>");
                }
                else
                {
                    ddlTemplate.Items.Add(new ListItem(title, no));
                    //sbTemplateInfo.AppendLine("<option value=\"" + no + "\">" + title + "</option>");
                }
            }
            ddlTemplate.SelectedValue = templateNo;
        }
    }
        /// <summary>
        /// 查询公司是否有销售模块
        /// </summary>
        /// <param name="companyCD">公司代码</param>
        /// <returns></returns>
        public static bool IsHaveSellInfo(string companyCD)
        {
            #region 查询语句
            StringBuilder searchSql = new StringBuilder();
            searchSql.AppendLine(" SELECT                                     ");
            searchSql.AppendLine(" 	COUNT(ModuleID) AS ModuleCount            ");
            searchSql.AppendLine(" FROM                                       ");
            searchSql.AppendLine(" 	pubdba.CompanyModule                      ");
            searchSql.AppendLine(" WHERE                                      ");
            searchSql.AppendLine(" 	CompanyCD = @CompanyCD                    ");
            searchSql.AppendLine(" 	AND CONVERT(VARCHAR, ModuleID) LIKE '203%'");
            #endregion

            //定义查询的命令
            SqlCommand comm = new SqlCommand();
            //公司代码
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", companyCD));

            //指定命令的SQL文
            comm.CommandText = searchSql.ToString();
            //执行查询
            DataTable dtModuleInfo = SqlHelper.ExecuteSearch(comm);
            int       rowCount     = 0;
            if (dtModuleInfo != null && dtModuleInfo.Rows.Count > 0)
            {
                rowCount = GetSafeData.ValidateDataRow_Int(dtModuleInfo.Rows[0], "ModuleCount");
            }
            return(rowCount > 0 ? true : false);
        }
        /// <summary>
        /// 校验提成工资项是否被使用
        /// </summary>
        /// <param name="itemNo">提成工资项编号</param>
        /// <param name="companyCD">公司代码</param>
        /// <returns></returns>
        public static bool IsUsedItem(string itemNo, string companyCD)
        {
            //校验SQL拼写
            StringBuilder searchSql = new StringBuilder();

            searchSql.AppendLine(" SELECT                      ");
            searchSql.AppendLine(" 	COUNT(*) AS UsedCount      ");
            searchSql.AppendLine(" FROM                        ");
            searchSql.AppendLine(" 	officedba.CommissionSalary ");
            searchSql.AppendLine(" WHERE                       ");
            searchSql.AppendLine(" ItemNo = @ItemNo            ");
            searchSql.AppendLine(" AND CompanyCD = @CompanyCD  ");

            SqlCommand cmd = new SqlCommand();

            //设置SQL语句
            cmd.CommandText = searchSql.ToString();
            //工资项编号
            cmd.Parameters.Add(SqlHelper.GetParameterFromString("@ItemNo", itemNo));
            //公司代码
            cmd.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", companyCD));

            //执行查询
            DataTable dtCount = SqlHelper.ExecuteSearch(cmd);
            //获取记录数
            int count = GetSafeData.ValidateDataRow_Int(dtCount.Rows[0], "UsedCount");

            //返回结果
            return(count > 0 ? true : false);
        }
Example #4
0
        //根据题目ID 初始化题目
        //输入:
        //      TID - 题目编号;
        //输出:
        //      如果考试题目存在:返回True;
        //      如果考试题目不在:返回False;
        public bool LoadData(int TID)
        {
            SqlParameter[] Params = new SqlParameter[1];
            DataBase       DB     = new DataBase();
            string         strsql = "SELECT * FROM FillBlankProblemmr where ID=@ID";

            Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID);                  //用户编号

            DataSet ds = DB.GetStrDataSetSql(strsql, Params);

            ds.CaseSensitive = false;
            DataRow DR;

            if (ds.Tables[0].Rows.Count > 0)
            {
                DR               = ds.Tables[0].Rows[0];
                this._CourseID   = GetSafeData.ValidateDataRow_N(DR, "CourseID");                 //科目编号
                this._FrontTitle = GetSafeData.ValidateDataRow_S(DR, "FrontTitle");               //题目前部分
                this._BackTitle  = GetSafeData.ValidateDataRow_S(DR, "BackTitle");                //题目后部分
                this._Answer     = GetSafeData.ValidateDataRow_S(DR, "Answer");                   //答案
                return(true);
            }
            else
            {
                return(false);
            }
        }
    /// <summary>
    /// 根据面试模板ID,获取模板信息,并设置到页面显示
    /// </summary>
    /// <param name="templateID">模板ID</param>
    private void InitTemplateInfo(string templateID)
    {
        //设置编号可见
        divCodeNo.Attributes.Add("style", "display:block;");
        //自动生成编号的控件设置为不可见
        divCodeRule.Attributes.Add("style", "display:none;");

        //查询考试信息
        DataSet dsTemplateInfo = RectCheckTemplateBus.GetRectCheckTemplateInfoWithID(templateID);
        //获取考试基本信息
        DataTable dtBaseInfo = dsTemplateInfo.Tables[0];

        //基本信息存在时
        if (dtBaseInfo != null && dtBaseInfo.Rows.Count > 0)
        {
            #region 设置基本信息
            //模板编号
            divCodeNo.InnerHtml = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TemplateNo");
            //主题
            txtTitle.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Title");
            //岗位
            ddlQuarter.SelectedValue = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "QuarterID");
            //考试状态
            txtRemark.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Remark");
            #endregion

            //设置要素信息
            InitElemInfo(dsTemplateInfo.Tables[1]);
        }
    }
Example #6
0
        /// <summary>
        /// 根据参数userId,获取购物篮详细信息
        /// </summary>
        /// <param name="userId">用户ID</param>
        public void LoadData(int userId)
        {
            Database db = new Database();                       //实例化一个Database类

            string sql = "";

            sql = "Select * from [Cart] where UserID = " + userId;

            SqlDataReader reader = db.GetDataReader(sql);               //利用Database类的GetDataRow方法查询用户数据

            //根据查询得到的数据,对成员安全赋值
            while (reader.Read())
            {
                if (this._cartId == 0)
                {
                    this._cartId = GetSafeData.ValidateDataReader_N(reader, "CartId");
                    this._userId = GetSafeData.ValidateDataReader_N(reader, "UserId");
                }
                this._books.Add(GetSafeData.ValidateDataReader_N(reader, "BookId"));
                this._amount.Add(GetSafeData.ValidateDataReader_N(reader, "Amount"));

                this._exist = true;
            }
            if (this._cartId == 0)
            {
                this._exist = false;
            }
        }
        /// <summary>
        /// 根据参数loginName,获取用户详细信息
        /// </summary>
        /// <param name="czy">用户登录名</param>
        public void LoadData(string czy)
        {
            Database db = new Database();               //实例化一个Database类

            string sql = "";

            sql = "Select * from [czyb],[yxb] where czy = "
                  + SqlStringConstructor.GetQuotedString(czy)
                  + " And [czyb].yxbh=[yxb].yxbh";

            DataRow dr = db.GetDataRow(sql);    //利用Database类的GetDataRow方法查询用户数据

            //根据查询得到的数据,对成员赋值
            if (dr != null)
            {
                this._czy  = GetSafeData.ValidateDataRow_S(dr, "czy");
                this._dlmm = GetSafeData.ValidateDataRow_S(dr, "dlmm");
                this._yxmc = GetSafeData.ValidateDataRow_S(dr, "yxmc");
                this._qx   = GetSafeData.ValidateDataRow_S(dr, "qx");

                //解密口令
                this._dlmm = Encrypt.DecryptString(_dlmm, _czy);

                this._exist = true;
            }
            else
            {
                this._exist = false;
            }
        }
Example #8
0
        public BMBaseModel GetModel(string BM)
        {
            DataTable kH    = this.bmkhDAL.GetKH(BM);
            BMKHModel model = new BMKHModel();

            if (kH.Rows.Count > 0)
            {
                DataRow row = kH.Rows[0];
                model.BM    = GetSafeData.ValidateValue <string>(row, "BM");
                model.MC    = GetSafeData.ValidateValue <string>(row, "MC");
                model.JM    = GetSafeData.ValidateValue <string>(row, "JM");
                model.KJM   = GetSafeData.ValidateValue <string>(row, "KJM");
                model.SH    = GetSafeData.ValidateValue <string>(row, "SH");
                model.DZDH  = GetSafeData.ValidateValue <string>(row, "DZDH");
                model.YHZH  = GetSafeData.ValidateValue <string>(row, "YHZH");
                model.YJDZ  = GetSafeData.ValidateValue <string>(row, "YJDZ");
                model.BZ    = GetSafeData.ValidateValue <string>(row, "BZ");
                model.YSKM  = GetSafeData.ValidateValue <string>(row, "YSKM");
                model.DQBM  = GetSafeData.ValidateValue <string>(row, "DQBM");
                model.DQMC  = GetSafeData.ValidateValue <string>(row, "DQMC");
                model.DQKM  = GetSafeData.ValidateValue <string>(row, "DQKM");
                model.SJBM  = GetSafeData.ValidateValue <string>(row, "SJBM");
                model.SFZJY = GetSafeData.ValidateValue <bool>(row, "SFZJY");
            }
            return(model);
        }
Example #9
0
        /// <summary>
        /// 根据参数Jxbbh,获取教学班详细信息
        /// </summary>
        /// <param name="jxbbh">教学班编号</param>
        public void LoadData(string jsbh, string bjmc, string sxlx, string kbxn, string kbxq)
        {
            Database db = new Database();               //实例化一个Database类

            string sql = "";

            sql = "Select * from [sxb],[jsb],[yxb],[bjb] where [jsb].jsbh = "
                  + SqlStringConstructor.GetQuotedString(jsbh) + " And [bjb].bjmc = " + SqlStringConstructor.GetQuotedString(bjmc)
                  + " And sxlx = " + SqlStringConstructor.GetQuotedString(sxlx) + " And kbxn = " + SqlStringConstructor.GetQuotedString(kbxn) + " And kbxq ="
                  + SqlStringConstructor.GetQuotedString(kbxq) + "And [sxb].jsbh=[jsb].jsbh And [sxb].bjbh=[bjb].bjbh And [sxb].yxbh=[yxb].yxbh";


            DataRow dr = db.GetDataRow(sql);    //利用Database类的GetDataRow方法查询用户数据

            //根据查询得到的数据,对成员赋值
            if (dr != null)
            {
                this._jsxm   = GetSafeData.ValidateDataRow_S(dr, "jsxm");
                this._bjmc   = GetSafeData.ValidateDataRow_S(dr, "bjmc");
                this._sxmc   = GetSafeData.ValidateDataRow_S(dr, "sxmc");
                this._sxlx   = GetSafeData.ValidateDataRow_S(dr, "sxlx");
                this._yxmc   = GetSafeData.ValidateDataRow_S(dr, "yxmc");
                this._sxzsts = GetSafeData.ValidateDataRow_F(dr, "sxzsts");
                this._kbxn   = GetSafeData.ValidateDataRow_S(dr, "kbxn");
                this._kbxq   = GetSafeData.ValidateDataRow_S(dr, "kbxq");
                this._jsbh   = GetSafeData.ValidateDataRow_S(dr, "jsbh");
                this._bjbh   = GetSafeData.ValidateDataRow_S(dr, "bjbh");
                this._yxbh   = GetSafeData.ValidateDataRow_S(dr, "yxbh");
                this._exist  = true;
            }
            else
            {
                this._exist = false;
            }
        }
Example #10
0
    /// <summary>
    /// 获取并设置人员信息
    /// </summary>
    /// <param name="ID">ID</param>
    private void InitEmployeInfo(string ID)
    {
        //获取申请单数据
        DataTable dtEmpl = EmployeeInfoBus.GetEmplDeptInfoWithID(ID);

        //数据存在时,设置值
        if (dtEmpl != null && dtEmpl.Rows.Count > 0)
        {
            //调职人
            txtEmployeeID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "ID");
            divCodeNo.Attributes.Add("style", "width:60%;");
            //员工编号
            txtEmployeeNo.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "EmployeeNo");
            //员工名
            txtEmployeeName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "EmployeeName");
            //原部门名称
            txtNowDeptName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "DeptName");
            //原部门ID
            txtNowDeptID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "DeptID");
            //原岗位名
            txtNowQuarterName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "QuarterName");
            //原岗位ID
            txtNowQuarterID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "QuarterID");
            //原岗位职等名称
            txtNowQuarterAdminName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "AdminLevelName");
            //原岗位职等ID
            txtNowQuarterAdminID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "AdminLevelID");

            //设置不可编辑
            txtEmployeeNo.Enabled = false;
        }
    }
Example #11
0
        public string ExportData(string pathFile, string separator, DataTable khTable = null)
        {
            DataTable exportData;
            string    path = pathFile.Remove(pathFile.LastIndexOf(@"\"));

            if (!Directory.Exists(path))
            {
                Directory.CreateDirectory(path);
            }
            if (khTable == null)
            {
                exportData = this.bmkhDAL.GetExportData();
            }
            else
            {
                exportData = khTable;
            }
            if (exportData.Rows.Count == 0)
            {
                return("没有客户");
            }
            StringBuilder builder = new StringBuilder();

            using (StreamWriter writer = new StreamWriter(pathFile, false, ToolUtil.GetEncoding()))
            {
                writer.WriteLine("{客户编码}[分隔符]\"" + separator + "\"");
                writer.WriteLine("// 每行格式 :");
                string str2 = "// 编码,名称,简码,税号,地址电话,银行账号,邮件地址,备注,身份证校验";
                writer.WriteLine(str2.Replace(",", separator));
                for (int i = 0; i < exportData.Rows.Count; i++)
                {
                    builder.Remove(0, builder.Length);
                    builder.Append(GetSafeData.ExportItem(exportData.Rows[i]["BM"].ToString(), separator));
                    builder.Append(separator);
                    builder.Append(GetSafeData.ExportItem(exportData.Rows[i]["MC"].ToString(), separator));
                    builder.Append(separator);
                    builder.Append(GetSafeData.ExportItem(exportData.Rows[i]["JM"].ToString(), separator));
                    if (exportData.Rows[i]["WJ"].ToString() == "1")
                    {
                        builder.Append(separator);
                        builder.Append(exportData.Rows[i]["SH"]);
                        builder.Append(separator);
                        string item = exportData.Rows[i]["DZDH"].ToString().Replace("\r\n", "#|#");
                        builder.Append(GetSafeData.ExportItem(item, separator));
                        builder.Append(separator);
                        string str4 = exportData.Rows[i]["YHZH"].ToString().Replace("\r\n", "#|#");
                        builder.Append(GetSafeData.ExportItem(str4, separator));
                        builder.Append(separator);
                        builder.Append(GetSafeData.ExportItem(exportData.Rows[i]["YJDZ"].ToString(), separator));
                        builder.Append(separator);
                        builder.Append(GetSafeData.ExportItem(exportData.Rows[i]["BZ"].ToString(), separator));
                        builder.Append(separator);
                        builder.Append(GetSafeData.ExportItem(exportData.Rows[i]["SFZJY"].ToString(), separator));
                    }
                    builder.Replace(",,", ",\"\",");
                    writer.WriteLine(builder.ToString());
                }
            }
            return("0");
        }
Example #12
0
        /// <summary>
        /// 根据ID获取信息
        /// </summary>
        /// <returns></returns>
        public static CodeReasonFeeModel GetThreeCodeById(int id, string TableName)
        {
            CodeReasonFeeModel model = new CodeReasonFeeModel();
            string             sql   = "select * from " + TableName + " where id=@id ";

            SqlParameter[] param = new SqlParameter[1];
            param[0] = SqlHelper.GetParameter("@id", id);
            DataTable dt = SqlHelper.ExecuteSql(sql, param);

            DataRow data = dt.Rows[0];

            if (dt.Rows.Count > 0)
            {
                model.CodeName       = GetSafeData.ValidateDataRow_String(data, "CodeName");
                model.ModifiedDate   = GetSafeData.ValidateDataRow_DateTime(data, "ModifiedDate");
                model.UsedStatus     = GetSafeData.ValidateDataRow_String(data, "UsedStatus");
                model.ModifiedUserID = GetSafeData.ValidateDataRow_String(data, "ModifiedUserID");
                model.Flag           = GetSafeData.ValidateDataRow_Int(data, "Flag");
                model.CompanyCD      = GetSafeData.ValidateDataRow_String(data, "CompanyCD");
                model.Description    = GetSafeData.ValidateDataRow_String(data, "Description");
                if (TableName == "officedba.CodeUnitType")// 往来单位
                {
                    model.CodeSymbol = GetSafeData.ValidateDataRow_String(data, "CodeSymbol");
                }
                return(model);
            }
            else
            {
                return(null);
            }
        }
Example #13
0
        /// <summary>
        /// 根据参数kcbh,获取课程详细信息
        /// </summary>
        /// <param name="kcbh">课程编号/param>
        public void LoadData(string kcbh)
        {
            Database db = new Database();               //实例化一个Database类

            string sql = "";

            sql = "Select * from [kcb] where kcbh = " + SqlStringConstructor.GetQuotedString(kcbh);


            DataRow dr = db.GetDataRow(sql);    //利用Database类的GetDataRow方法查询数据

            //根据查询得到的数据,对成员赋值
            if (dr != null)
            {
                this._kcbh   = GetSafeData.ValidateDataRow_S(dr, "Kcbh");
                this._kcmc   = GetSafeData.ValidateDataRow_S(dr, "Kcmc");
                this._kcxz   = GetSafeData.ValidateDataRow_S(dr, "Kcxz");
                this._kclx   = GetSafeData.ValidateDataRow_S(dr, "Kclx");
                this._fdkcsj = GetSafeData.ValidateDataRow_B(dr, "Fdkcsj");
                this._yxbz   = GetSafeData.ValidateDataRow_B(dr, "Yxbz");
                this._exist  = true;
            }
            else
            {
                this._exist = false;
            }
        }
Example #14
0
        //根据题目ID 初始化题目
        //输入:
        //      TID - 题目编号;
        //输出:
        //      题目存在:返回True;
        //      题目不在:返回False;
        public bool LoadData(int TID)
        {
            SqlParameter[] Params = new SqlParameter[1];
            DataBase       DB     = new DataBase();

            Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID);                  //用户编号

            DataSet ds = DB.GetDataSet("Proc_DatiDetail", Params);

            ds.CaseSensitive = false;
            DataRow DR;

            if (ds.Tables[0].Rows.Count > 0)
            {
                DR             = ds.Tables[0].Rows[0];
                this._CourseID = GetSafeData.ValidateDataRow_N(DR, "CourseID"); //科目编号
                this._ImgFile  = GetSafeData.ValidateDataRow_S(DR, "Img");      //图片url
                this._Title    = GetSafeData.ValidateDataRow_S(DR, "Title");    //大题信息
                this._nandu    = GetSafeData.ValidateDataRow_N(DR, "Nandu");    //难度
                this._zhang    = GetSafeData.ValidateDataRow_N(DR, "Zhang");    //章
                this._jie      = GetSafeData.ValidateDataRow_N(DR, "Jie");      //节
                return(true);
            }
            else
            {
                return(false);
            }
        }
Example #15
0
        public XSDJ_MXModel GetMXModel(string XSDJBH, string XH)
        {
            XSDJ_MXModel model = new XSDJ_MXModel();
            Dictionary <string, object> dictionary = new Dictionary <string, object>();

            dictionary.Add("XSDJBH", XSDJBH);
            dictionary.Add("XH", XH);
            DataTable table = this.baseDAO.querySQLDataTable("aisino.Fwkp.Wbjk.XSDJMXGetModel", dictionary);

            if (table.Rows.Count > 0)
            {
                DataRow row = table.Rows[0];
                model.XSDJBH = GetSafeData.ValidateValue <string>(row, "XSDJBH");
                model.XH     = GetSafeData.ValidateValue <int>(row, "XH");
                model.SL     = GetSafeData.ValidateValue <double>(row, "SL");
                model.DJ     = GetSafeData.ValidateValue <double>(row, "DJ");
                model.JE     = GetSafeData.ValidateValue <double>(row, "JE");
                model.SLV    = GetSafeData.ValidateValue <double>(row, "SLV");
                model.SE     = GetSafeData.ValidateValue <double>(row, "SE");
                model.SPMC   = GetSafeData.ValidateValue <string>(row, "SPMC");
                model.SPSM   = GetSafeData.ValidateValue <string>(row, "SPSM");
                model.GGXH   = GetSafeData.ValidateValue <string>(row, "GGXH");
                model.JLDW   = GetSafeData.ValidateValue <string>(row, "JLDW");
                model.HSJBZ  = GetSafeData.ValidateValue <bool>(row, "HSJBZ");
                model.DJHXZ  = GetSafeData.ValidateValue <int>(row, "DJHXZ");
                model.FPZL   = GetSafeData.ValidateValue <string>(row, "FPZL");
                model.FPDM   = GetSafeData.ValidateValue <string>(row, "FPDM");
                model.FPHM   = GetSafeData.ValidateValue <int>(row, "FPHM");
                model.SCFPXH = GetSafeData.ValidateValue <int>(row, "SCFPXH");
            }
            return(model);
        }
Example #16
0
        //根据题目ID 初始化题目
        //输入:
        //      TID - 题目编号;
        //输出:
        //      题目存在:返回True;
        //      题目不在:返回False;
        public bool LoadData(int TID)
        {
            SqlParameter[] Params = new SqlParameter[1];
            Datacon        DB     = new Datacon();

            Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID);                  //用户编号

            DataSet ds = DB.GetDataSet("Proc_JudgeProblemDetail", Params);

            ds.CaseSensitive = false;
            DataRow DR;

            if (ds.Tables[0].Rows.Count > 0)
            {
                DR           = ds.Tables[0].Rows[0];
                this._c_id   = GetSafeData.ValidateDataRow_N(DR, "c_id");                 //科目编号
                this._Title  = GetSafeData.ValidateDataRow_S(DR, "Title");                //题目
                this._Answer = GetSafeData.ValidateDataRow_B(DR, "Answer");               //答案
                return(true);
            }
            else
            {
                return(false);
            }
        }
Example #17
0
        public void LoadDataJXB2(string jxbmc)
        {
            Database db = new Database();               //实例化一个Database类

            string sql = "";

            sql = "Select * from [jxbb] where jxbmc = "
                  + SqlStringConstructor.GetQuotedString(jxbmc);


            DataRow dr = db.GetDataRow(sql);    //利用Database类的GetDataRow方法查询用户数据

            //根据查询得到的数据,对成员赋值
            if (dr != null)
            {
                this._jxbbh  = GetSafeData.ValidateDataRow_S(dr, "jxbbh");
                this._jxbmc  = GetSafeData.ValidateDataRow_S(dr, "jxbmc");
                this._jxbzrs = GetSafeData.ValidateDataRow_S(dr, "jxbzrs");


                this._exist = true;
            }
            else
            {
                this._exist = false;
            }
        }
Example #18
0
        //根据用户 UserID 初始化该用户
        //输入:
        //      XUserID - 用户编号;
        //输出:
        //      用户存在:返回True;
        //      用户不在:返回False;
        public bool LoadData(int XUserID)
        {
            SqlParameter[] Params = new SqlParameter[1];
            DataBase       DB     = new DataBase();

            Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, XUserID);                  //用户编号

            DataSet ds = DB.GetDataSet("Proc_UsersDetail", Params);

            ds.CaseSensitive = false;
            DataRow DR;

            if (ds.Tables[0].Rows.Count > 0)
            {
                DR              = ds.Tables[0].Rows[0];
                this._userID    = GetSafeData.ValidateDataRow_N(DR, "UserID");                      //用户编号
                this._userPower = GetSafeData.ValidateDataRow_N(DR, "UserPower");                   //用户权限
                this._userName  = GetSafeData.ValidateDataRow_S(DR, "UserName");                    //用户姓名
                this._userEmail = GetSafeData.ValidateDataRow_S(DR, "UserEmail");                   //用户邮箱
                this._userNum   = GetSafeData.ValidateDataRow_S(DR, "UserNum");                     //用户学号
                return(true);
            }
            else
            {
                return(false);
            }
        }
Example #19
0
        /// <summary>
        /// 根据参数jsbh,获取教师详细信息
        /// </summary>
        /// <param name="jsbh">教师编号/param>
        public void LoadData(string jsbh)
        {
            Database db = new Database();               //实例化一个Database类

            string sql = "";

            sql = "Select * from [jsb],[yxb],[zwb],[zcb] where jsbh = " + SqlStringConstructor.GetQuotedString(jsbh)
                  + "And [jsb].yxbh = [yxb].yxbh And [jsb].zcbh = [zcb].zcbh And [jsb].zwbh = [zwb].zwbh";

            DataRow dr = db.GetDataRow(sql);    //利用Database类的GetDataRow方法查询数据

            //根据查询得到的数据,对成员赋值
            if (dr != null)
            {
                this._jsbh = GetSafeData.ValidateDataRow_S(dr, "Jsbh");
                this._jsxm = GetSafeData.ValidateDataRow_S(dr, "Jsxm");
                this._jsxb = GetSafeData.ValidateDataRow_S(dr, "Jsxb");
                this._yxmc = GetSafeData.ValidateDataRow_S(dr, "Yxmc");
                this._zcmc = GetSafeData.ValidateDataRow_S(dr, "Zcmc");
                this._zwlx = GetSafeData.ValidateDataRow_S(dr, "Zwlx");
                this._dlmm = GetSafeData.ValidateDataRow_S(dr, "Dlmm");
                this._zzzt = GetSafeData.ValidateDataRow_B(dr, "Zzzt");

                //解密口令
                this._dlmm  = Encrypt.DecryptString(_dlmm, _jsbh);
                this._exist = true;
            }
            else
            {
                this._exist = false;
            }
        }
Example #20
0
        public void LoadInfo(string authorID)
        {
            string   sql = "select * from author where authorID=" + SQLString.GetQuotedString(authorID);
            Database db  = new Database();
            DataRow  dr  = db.GetDataRow(sql);

            if (dr != null)
            {
                this._authorID      = GetSafeData.ValidateDataRow_S(dr, "authorID");
                this._authorPwd     = GetSafeData.ValidateDataRow_S(dr, "authorPwd");
                this._authorName    = GetSafeData.ValidateDataRow_S(dr, "authorName");
                this._authorSex     = GetSafeData.ValidateDataRow_S(dr, "authorSex");
                this._authorBirth   = GetSafeData.ValidateDataRow_S(dr, "authorBirth");
                this._authorRegion  = GetSafeData.ValidateDataRow_S(dr, "authorRegion");
                this._authorPost    = GetSafeData.ValidateDataRow_S(dr, "authorPost");
                this._authorMail    = GetSafeData.ValidateDataRow_S(dr, "authorMail");
                this._authorDegree  = GetSafeData.ValidateDataRow_S(dr, "authorDegree");
                this._authorMajor   = GetSafeData.ValidateDataRow_S(dr, "authorMajor");
                this._authorTitle   = GetSafeData.ValidateDataRow_S(dr, "authorTitle");
                this._authorJob     = GetSafeData.ValidateDataRow_S(dr, "authorJob");
                this._authorCompany = GetSafeData.ValidateDataRow_S(dr, "authorCompany");
                this._authorPhone   = GetSafeData.ValidateDataRow_S(dr, "authorPhone");
                this._authorAddress = GetSafeData.ValidateDataRow_S(dr, "authorAddress");
                this._authorInfo    = GetSafeData.ValidateDataRow_S(dr, "authorInfo");
                this._exist         = true;
            }
            else
            {
                this._exist = false;
            }
        }
Example #21
0
        //根据题目ID 初始化题目
        //输入:
        //      TID - 题目编号;
        //输出:
        //      题目存在:返回True;
        //      题目不在:返回False;
        public bool LoadData(int TID)
        {
            SqlParameter[] Params = new SqlParameter[1];
            DataBase       DB     = new DataBase();

            Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID);                  //用户编号

            DataSet ds = DB.GetDataSet("Proc_SingleProblemDetail", Params);

            ds.CaseSensitive = false;
            DataRow DR;

            if (ds.Tables[0].Rows.Count > 0)
            {
                DR             = ds.Tables[0].Rows[0];
                this._CourseID = GetSafeData.ValidateDataRow_N(DR, "CourseID");                 //科目编号
                this._Title    = GetSafeData.ValidateDataRow_S(DR, "Title");                    //题目
                this._AnswerA  = GetSafeData.ValidateDataRow_S(DR, "AnswerA");                  //答案A
                this._AnswerB  = GetSafeData.ValidateDataRow_S(DR, "AnswerB");                  //答案B
                this._AnswerC  = GetSafeData.ValidateDataRow_S(DR, "AnswerC");                  //答案C
                this._AnswerD  = GetSafeData.ValidateDataRow_S(DR, "AnswerD");                  //答案D
                this._Answer   = GetSafeData.ValidateDataRow_S(DR, "Answer");                   //答案
                this._DiffID   = GetSafeData.ValidateDataRow_N(DR, "DiffID");                   //难度系数
                return(true);
            }
            else
            {
                return(false);
            }
        }
Example #22
0
        public BMBaseModel GetModel(string BM)
        {
            DataTable sPFL  = this.bmspflDAL.GetSPFL(BM);
            BMSPModel model = new BMSPModel();

            if (sPFL.Rows.Count > 0)
            {
                DataRow row = sPFL.Rows[0];
                model.BM      = GetSafeData.ValidateValue <string>(row, "BM");
                model.MC      = GetSafeData.ValidateValue <string>(row, "MC");
                model.JM      = GetSafeData.ValidateValue <string>(row, "JM");
                model.KJM     = GetSafeData.ValidateValue <string>(row, "KJM");
                model.SJBM    = GetSafeData.ValidateValue <string>(row, "SJBM");
                model.SLV     = GetSafeData.ValidateValue <double>(row, "SLV");
                model.SPSM    = GetSafeData.ValidateValue <string>(row, "SPSM");
                model.GGXH    = GetSafeData.ValidateValue <string>(row, "GGXH");
                model.JLDW    = GetSafeData.ValidateValue <string>(row, "JLDW");
                model.DJ      = GetSafeData.ValidateValue <double>(row, "DJ");
                model.HSJBZ   = GetSafeData.ValidateValue <bool>(row, "HSJBZ");
                model.XSSRKM  = GetSafeData.ValidateValue <string>(row, "XSSRKM");
                model.YJZZSKM = GetSafeData.ValidateValue <string>(row, "YJZZSKM");
                model.XSTHKM  = GetSafeData.ValidateValue <string>(row, "XSTHKM");
                model.HYSY    = GetSafeData.ValidateValue <bool>(row, "HYSY");
                model.XTHASH  = GetSafeData.ValidateValue <string>(row, "XTHASH");
                model.XTCODE  = GetSafeData.ValidateValue <string>(row, "XTCODE");
                model.ISHIDE  = GetSafeData.ValidateValue <string>(row, "ISHIDE");
            }
            return(model);
        }
Example #23
0
        public string ExportData(string pathFile, string separator, DataTable khTable = null)
        {
            string path = pathFile.Remove(pathFile.LastIndexOf(@"\"));

            if (!Directory.Exists(path))
            {
                Directory.CreateDirectory(path);
            }
            DataTable exportData = this.bmfyxmDAL.GetExportData();

            if (exportData.Rows.Count == 0)
            {
                return("没有费用项目");
            }
            StringBuilder builder = new StringBuilder();

            using (StreamWriter writer = new StreamWriter(pathFile, false, ToolUtil.GetEncoding()))
            {
                writer.WriteLine("{费用项目编码}[分隔符]\"" + separator + "\"");
                writer.WriteLine("// 每行格式 :");
                string str2 = "";
                if (Flbm.IsYM())
                {
                    str2 = "// 编码~~名称~~简码~~商品分类~~是否享受优惠政策~~税收分类名称~~优惠政策类型~~编码版本号";
                }
                else
                {
                    str2 = "// 编码~~名称~~简码";
                }
                writer.WriteLine(str2.Replace(",", separator));
                string maxBMBBBH = new SPFLService().GetMaxBMBBBH();
                for (int i = 0; i < exportData.Rows.Count; i++)
                {
                    builder.Remove(0, builder.Length);
                    builder.Append(GetSafeData.ExportItem(exportData.Rows[i]["BM"].ToString(), separator));
                    builder.Append(separator);
                    builder.Append(GetSafeData.ExportItem(exportData.Rows[i]["MC"].ToString(), separator));
                    builder.Append(separator);
                    builder.Append(GetSafeData.ExportItem(exportData.Rows[i]["JM"].ToString(), separator));
                    if (Flbm.IsYM())
                    {
                        builder.Append(separator);
                        builder.Append(GetSafeData.ExportItem(exportData.Rows[i]["SPFL"].ToString(), separator));
                        builder.Append(separator);
                        builder.Append(GetSafeData.ExportItem(exportData.Rows[i]["YHZC"].ToString(), separator));
                        builder.Append(separator);
                        builder.Append(GetSafeData.ExportItem(exportData.Rows[i]["SPFLMC"].ToString(), separator));
                        builder.Append(separator);
                        builder.Append(GetSafeData.ExportItem(exportData.Rows[i]["YHZCMC"].ToString(), separator));
                        builder.Append(separator);
                        builder.Append(GetSafeData.ExportItem(maxBMBBBH, separator));
                    }
                    builder.Replace(",,", ",\"\",");
                    writer.WriteLine(builder.ToString());
                }
            }
            return("0");
        }
        private static OtherCorpInfoModel ChangeOtherCorpInfoModel(DataRow data)
        {
            //定义返回的 EmployeeInfoModel
            OtherCorpInfoModel model = new OtherCorpInfoModel();

            //人员信息存在时,转化为model形式的数据
            if (data != null)
            {
                model.ID             = GetSafeData.ValidateDataRow_Int(data, "ID");
                model.CompanyCD      = GetSafeData.ValidateDataRow_String(data, "CompanyCD");
                model.BigType        = GetSafeData.ValidateDataRow_String(data, "BigType");
                model.CustNo         = GetSafeData.ValidateDataRow_String(data, "CustNo");
                model.CustName       = GetSafeData.ValidateDataRow_String(data, "CustName");
                model.CorpNam        = GetSafeData.ValidateDataRow_String(data, "CorpNam");
                model.PYShort        = GetSafeData.ValidateDataRow_String(data, "PYShort");
                model.CustNote       = GetSafeData.ValidateDataRow_String(data, "CustNote");
                model.AreaID         = GetSafeData.GetStringFromInt(data, "AreaID");
                model.CompanyType    = GetSafeData.ValidateDataRow_String(data, "CompanyType");
                model.StaffCount     = GetSafeData.GetStringFromInt(data, "StaffCount");
                model.SetupDate      = GetSafeData.ValidateDataRow_String(data, "SetupDate");
                model.ArtiPerson     = GetSafeData.ValidateDataRow_String(data, "ArtiPerson");
                model.SetupMoney     = GetSafeData.GetStringFromDecimal(data, "SetupMoney");
                model.SetupAddress   = GetSafeData.ValidateDataRow_String(data, "SetupAddress");
                model.CapitalScale   = GetSafeData.GetStringFromDecimal(data, "CapitalScale");
                model.SaleroomY      = GetSafeData.GetStringFromDecimal(data, "SaleroomY");
                model.ProfitY        = GetSafeData.GetStringFromDecimal(data, "ProfitY");
                model.TaxCD          = GetSafeData.ValidateDataRow_String(data, "TaxCD");
                model.BusiNumber     = GetSafeData.ValidateDataRow_String(data, "BusiNumber");
                model.isTax          = GetSafeData.ValidateDataRow_String(data, "isTax");
                model.SellArea       = GetSafeData.ValidateDataRow_String(data, "SellArea");
                model.CountryID      = GetSafeData.GetStringFromInt(data, "CountryID");
                model.Province       = GetSafeData.ValidateDataRow_String(data, "Province");
                model.City           = GetSafeData.ValidateDataRow_String(data, "City");
                model.Post           = GetSafeData.ValidateDataRow_String(data, "Post");
                model.ContactName    = GetSafeData.ValidateDataRow_String(data, "ContactName");
                model.Tel            = GetSafeData.ValidateDataRow_String(data, "Tel");
                model.Fax            = GetSafeData.ValidateDataRow_String(data, "Fax");
                model.Mobile         = GetSafeData.ValidateDataRow_String(data, "Mobile");
                model.email          = GetSafeData.ValidateDataRow_String(data, "email");
                model.Addr           = GetSafeData.ValidateDataRow_String(data, "Addr");
                model.BillType       = GetSafeData.ValidateDataRow_String(data, "BillType");
                model.PayType        = GetSafeData.GetStringFromInt(data, "PayType");
                model.MoneyType      = GetSafeData.GetStringFromInt(data, "MoneyType");
                model.CurrencyType   = GetSafeData.GetStringFromInt(data, "CurrencyType");
                model.Remark         = GetSafeData.ValidateDataRow_String(data, "Remark");
                model.UsedStatus     = GetSafeData.ValidateDataRow_String(data, "UsedStatus");
                model.Creator        = GetSafeData.GetStringFromInt(data, "Creator");
                model.CreateDate     = GetSafeData.GetStringFromDateTime(data, "CreateDate", "yyyy-MM-dd");
                model.ModifiedDate   = GetSafeData.GetStringFromDateTime(data, "ModifiedDate", "yyyy-MM-dd");
                model.ModifiedUserID = GetSafeData.ValidateDataRow_String(data, "ModifiedUserID");
                model.EmployeeName   = GetSafeData.ValidateDataRow_String(data, "EmployeeName");
            }

            return(model);
        }
Example #25
0
        public void ChooseYHZCMCForFYXM()
        {
            DataTable table = new DAL.BMFYXMManager().QueryFYXMYHZCIsAndYHZCMCIsEmpty();

            if (table != null)
            {
                DAL.BMSPFLManager manager2 = new DAL.BMSPFLManager();
                List <string>     sqlID    = new List <string>();
                List <Dictionary <string, object> > param = new List <Dictionary <string, object> >();
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    Dictionary <string, object> item = new Dictionary <string, object>();
                    string   str        = GetSafeData.ValidateValue <string>(table.Rows[i], "BM");
                    string   bm         = GetSafeData.ValidateValue <string>(table.Rows[i], "SPFL");
                    string   str3       = GetSafeData.ValidateValue <string>(table.Rows[i], "YHZC");
                    string   sPFLMCBYBM = manager2.GetSPFLMCBYBM(bm);
                    string   str5       = "";
                    object[] objArray   = ServiceFactory.InvokePubService("Aisino.Fwkp.Bmgl.GetSLV_BY_BM", new object[] { bm });
                    if ((objArray != null) && (objArray.Length > 0))
                    {
                        string[] strArray = (objArray[0] as DataTable).Rows[0]["ZZSTSGL"].ToString().Split(new char[] { ',', '、', ';', ',', ';' });
                        if (strArray.Length > 0)
                        {
                            str5 = strArray[0];
                            if ((!Flbm.IsDK() && (strArray.Length == 1)) && strArray[0].Contains("1.5%"))
                            {
                                str3 = "否";
                                str5 = "";
                            }
                            if ((!Flbm.IsDK() && (strArray.Length > 1)) && strArray[0].Contains("1.5%"))
                            {
                                str5 = strArray[1];
                            }
                        }
                        else
                        {
                            str3 = "否";
                        }
                    }
                    else
                    {
                        str3 = "否";
                    }
                    item.Add("BM", str);
                    item.Add("SPFL", bm);
                    item.Add("SPFLMC", sPFLMCBYBM);
                    item.Add("YHZC", str3);
                    item.Add("YHZCMC", str5);
                    sqlID.Add("aisino.Fwkp.Bmgl.BMSPFL.UpdateFYXMSPFL");
                    param.Add(item);
                }
                new DAL.BMSPFLManager().UpdateSPFLTable(sqlID, param, false);
            }
        }
Example #26
0
        public void LoadInfo(string adminID)
        {
            string   sql = "select * from admin where adminID=" + SQLString.GetQuotedString(adminID);
            Database db  = new Database();
            DataRow  dr  = db.GetDataRow(sql);

            if (dr != null)
            {
                this._adminID  = GetSafeData.ValidateDataRow_S(dr, "adminID");
                this._adminPwd = GetSafeData.ValidateDataRow_S(dr, "adminPwd");
            }
        }
Example #27
0
        public BMXZQYModel GetModel(string BM)
        {
            DataTable   bMXZQY = this.bmkhDAL.GetBMXZQY(BM);
            BMXZQYModel model  = new BMXZQYModel();

            if (bMXZQY.Rows.Count > 0)
            {
                DataRow row = bMXZQY.Rows[0];
                model.BM = GetSafeData.ValidateValue <string>(row, "BM");
                model.MC = GetSafeData.ValidateValue <string>(row, "MC");
            }
            return(model);
        }
Example #28
0
        public void checkspspfl()
        {
            DataTable table = new DAL.BMSPManager().QuerySPSPFLLNotEmptyAndNotXT();

            if (table != null)
            {
                DAL.BMSPFLManager manager2 = new DAL.BMSPFLManager();
                List <string>     sqlID    = new List <string>();
                List <Dictionary <string, object> > param = new List <Dictionary <string, object> >();
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    Dictionary <string, object> item = new Dictionary <string, object>();
                    string str        = GetSafeData.ValidateValue <string>(table.Rows[i], "BM");
                    string bm         = GetSafeData.ValidateValue <string>(table.Rows[i], "SPFL");
                    string str3       = GetSafeData.ValidateValue <string>(table.Rows[i], "LSLVBS");
                    string str4       = GetSafeData.ValidateValue <string>(table.Rows[i], "YHZC");
                    string str5       = GetSafeData.ValidateValue <string>(table.Rows[i], "YHZCMC");
                    string sPFLMCBYBM = string.Empty;
                    item.Add("BM", str);
                    if (manager2.CanUseThisSPFLBM(bm, true, false))
                    {
                        item.Add("SPFL", bm);
                        sPFLMCBYBM = manager2.GetSPFLMCBYBM(bm);
                        item.Add("SPFLMC", sPFLMCBYBM);
                        if (manager2.CanUseThisYHZC(bm))
                        {
                            item.Add("YHZC", str4);
                            item.Add("YHZCMC", str5);
                            item.Add("LSLVBS", str3);
                        }
                        else
                        {
                            item.Add("YHZC", "否");
                            item.Add("YHZCMC", "");
                            item.Add("LSLVBS", "");
                        }
                    }
                    else
                    {
                        item.Add("SPFL", "");
                        item.Add("SPFLMC", "");
                        item.Add("YHZC", "");
                        item.Add("YHZCMC", "");
                        item.Add("LSLVBS", "");
                    }
                    sqlID.Add("aisino.Fwkp.Bmgl.BMSPFL.UpdateSPSPFL");
                    param.Add(item);
                }
                new DAL.BMSPFLManager().UpdateSPFLTable(sqlID, param, false);
            }
        }
    /// <summary>
    /// 设置考核结果
    /// </summary>
    /// <param name="dtSchedule">考核结果信息</param>
    private void InitAsseResultInfo(DataTable dtResult)
    {
        //定义保存进度安排的变量
        StringBuilder sbResultInfo = new StringBuilder();
        //换行标识
        int flag = 0;

        //进度安排存在时,设置进度安排
        if (dtResult != null && dtResult.Rows.Count > 0)
        {
            for (int i = 0; i < dtResult.Rows.Count; i++)
            {
                /* 每行显示两条数据,所以通过对2取余来判断是否换行 以及 行是否结束 */
                //对2进行取余
                flag = i % 2;
                //余数为0时,表示需要新添加一行
                if (flag == 0)
                {
                    //插入行开始标识
                    sbResultInfo.AppendLine("<tr>");
                }
                //姓名
                sbResultInfo.AppendLine("<td class='tdColInputCenter'><input type='hidden' value='"
                                        + GetSafeData.ValidateDataRow_String(dtResult.Rows[i], "EmployeeID") + "' class='tdinput' id='txtJoinUserID_" + i.ToString()
                                        + "'>" + GetSafeData.ValidateDataRow_String(dtResult.Rows[i], "EmployeeName") + "</td>");
                //考核得分
                sbResultInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '6' onchange='Number_round(this,2);' value='"
                                        + GetSafeData.ValidateDataRow_String(dtResult.Rows[i], "AssessScore") + "' class='tdinput' id='txtAsseScore_" + i.ToString() + "'></td>");
                //考核等级
                sbResultInfo.AppendLine("<td class='tdColInputCenter'>"
                                        + InitLevelDropDownList("ddlAsseLevel_" + i.ToString(), GetSafeData.ValidateDataRow_String(dtResult.Rows[i], "AssessLevel")) + "</td>");
                //余数为1时,表示行结束
                if (flag == 1)
                {
                    //插入行结束标识
                    sbResultInfo.AppendLine("</tr>");
                }
            }
            //余数为0时,表示所有的记录为单数条,因此需要把未结束的行结束
            if (flag == 0)
            {
                //插入空白列
                sbResultInfo.AppendLine("<td class='tdColInputCenter'></td><td class='tdColInput'></td><td class='tdColInputCenter'></td>");
                //插入行结束标识
                sbResultInfo.AppendLine("</tr>");
            }
        }
        //考核结果设置到DIV中表示
        divRsseResultDetail.InnerHtml = CreateResultTable() + sbResultInfo.ToString() + EndTable();
    }
Example #30
0
        /// <summary>
        /// 根据编码规则获取单据编号
        /// </summary>
        /// <param name="codeID">编码规则ID</param>
        /// <returns></returns>
        public static string GetCodeValue(string codeID)
        {
            //上次生成的最大流水号
            //int lastpreNo =-1;
            //定义返回的值
            string codeValue = "";
            //获取编码规则详细设置内容
            DataTable ruleData = ItemCodingRuleDBHelper.GetCodingRuleInfoWithID(codeID);

            //数据存在时进行Code生成操作
            if (ruleData != null && ruleData.Rows.Count > 0)
            {
                //获取编码示例
                string ruleExample = GetSafeData.ValidateDataRow_String(ruleData.Rows[0], "RuleExample");
                //编码示例长度小于4时,进行设置
                if (!string.IsNullOrEmpty(ruleExample) && ruleExample.Length > 4)
                {
                    //获取流水号类型
                    int    start      = ruleExample.LastIndexOf(ConstUtil.RULE_EXAMPLE_START);
                    string ruleNoType = ruleExample.Substring(start);

                    //获取当前流水号最大值
                    string lastNo = GetSafeData.ValidateDataRow_Int(ruleData.Rows[0], "LastNo").ToString();
                    //编码流水号长度
                    int ruleNoLen = GetSafeData.ValidateDataRow_Int(ruleData.Rows[0], "RuleNoLen");
                    //长度不够时左边添加0
                    lastNo = lastNo.PadLeft(ruleNoLen, ConstUtil.RULE_EXAMPLE_ZERO);
                    //替换流水号
                    codeValue = ruleExample.Replace(ruleNoType, lastNo);

                    //获取编码类型
                    string codingType = GetSafeData.ValidateDataRow_String(ruleData.Rows[0], "CodingType");
                    //编码类型为单据时,替换日期设置
                    if (!ConstUtil.CODING_RULE_TYPE_ZERO.Equals(codingType))
                    {
                        //获取流水号类型
                        start = ruleExample.IndexOf(ConstUtil.RULE_EXAMPLE_START);
                        int    end      = ruleExample.IndexOf(ConstUtil.RULE_EXAMPLE_END);
                        string dateType = ruleExample.Substring(start, end - start + 1);
                        //获取当前日期值
                        string dateTypeValue = DateTime.Now.ToString(dateType.Substring(1, dateType.Length - 2));
                        //替换日期类型
                        codeValue = codeValue.Replace(dateType, dateTypeValue);
                    }
                }
            }

            //返回生成的单据编号
            return(codeValue);
        }