示例#1
0
        /// <summary>
        /// 增加一条民非企业申请
        /// </summary>
        /// <param name="AppCom">一个民非企业申请的对象</param>
        /// <returns>添加后那条记录的主键ID</returns>
        public static int AddAppCom(Approve_Company AppCom)
        {
            int iExecute = 0;
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("insert into Approve_Company11 (");
                strSql.Append("UserName,Tel,CompanyName,AppType,AppStatus,Remark,AppTime,FilePath,QueryCode");
                strSql.Append(") values(");
                strSql.Append("@UserName,@Tel,@CompanyName,@AppType,@AppStatus,@Remark,@AppTime,@FilePath,@QueryCode");
                strSql.Append(");select @@IDENTITY");
                SqlParameter[] para = new SqlParameter[]
                {
                new SqlParameter("@UserName",SqlDbType.NVarChar,50),
                new SqlParameter("@Tel",SqlDbType.NVarChar,20),
                new SqlParameter("@CompanyName",SqlDbType.NVarChar,50),
                new SqlParameter("@AppType",SqlDbType.NVarChar,20),
                new SqlParameter("@AppStatus",SqlDbType.NVarChar,50),
                new SqlParameter("@Remark",SqlDbType.Text),
                new SqlParameter("@AppTime",SqlDbType.DateTime),
                new SqlParameter("@FilePath",SqlDbType.Text),
                 new SqlParameter("@QueryCode",SqlDbType.NVarChar,10),
                };
                para[0].Value = AppCom.UserName;
                para[1].Value = AppCom.Tel;
                para[2].Value = AppCom.CompanyName;
                para[3].Value = AppCom.AppType;
                para[4].Value = AppCom.AppStatus;
                para[5].Value = AppCom.Remark;
                para[6].Value = AppCom.AppTime;
                para[7].Value = AppCom.FilePath;
                para[8].Value = AppCom.QueryCode;
                object obj = DbHelperSQL.GetSingle(strSql.ToString(), para);
                if (obj != null)
                {
                    iExecute = Convert.ToInt32(obj);
                }

            }
            catch (Exception e)
            {
                Log4Net.LogWrite("err", "Controler\\AddAppCom" + e.Message);
            }
            return iExecute;
        }
示例#2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string code = Request.QueryString["code"];
                Approve_Company AppCom = new Approve_Company();
                try
                {
                    AppCom = Ctrl_App_Com.FindAppComByQueryCode(code);
                    if (AppCom != null)
                    {
                        lbUserName.Text = AppCom.UserName;
                        lbCompany.Text = AppCom.CompanyName;
                        lbType.Text = AppCom.AppType;
                        lbStatus.Text = AppCom.AppStatus;
                        lbCode.Text = AppCom.QueryCode;
                        lbRemark.Text = AppCom.Remark;
                        lbAppTime.Text = AppCom.AppTime.ToString("yyyy-MM-dd H:m:s");

                        if (AppCom.AppStatus == "未审核")
                        {
                            lbCheckTime.Text = " ";
                        }
                        else
                        {
                            lbCheckTime.Text = AppCom.CheckTime.ToString("yyyy-MM-dd H:m:s");
                        }
                    }
                    else
                    {
                        MessageBox.Show(this, "查询异常!");
                        return;
                    }
                }
                catch (Exception)
                {
                    MessageBox.Show(this, "查询异常!");
                    throw;
                }
            }
        }
示例#3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                int id = Convert.ToInt32(Request.QueryString["ID"]);
                AppCom = new Approve_Company();
                try
                {
                    AppCom = Ctrl_App_Com.FindAppComByID(id);
                    if (AppCom != null)
                    {
                        lbUserName.Text = AppCom.UserName;
                        lbTel.Text = AppCom.Tel;
                        lbCompany.Text = AppCom.CompanyName;
                        lbType.Text = AppCom.AppType;
                        lbStatus.Text = AppCom.AppStatus;
                        lbRemark.Text = AppCom.Remark;
                        lbAppTime.Text = AppCom.AppTime.ToString("yyyy-MM-dd H:m:s");
                        txtRemark.Text = AppCom.Remark;
                        if (AppCom.AppStatus == "未审核")
                        {
                            lbCheckTime.Text = " ";
                        }
                        else
                        {
                            lbCheckTime.Text = AppCom.CheckTime.ToString("yyyy-MM-dd H:m:s");
                            btnSubmit.Enabled = false;
                        }
                    }
                    else
                    {
                        MessageBox.Show(this, "查询异常!");
                        return;
                    }
                }
                catch (Exception)
                {
                    MessageBox.Show(this, "查询异常!");
                    throw;
                }

            }
        }
示例#4
0
 /// <summary>
 /// 更新民非企业申请信息
 /// </summary>
 /// <param name="AppCom"></param>
 /// <returns></returns>
 public static int UpdateAppCom(Approve_Company AppCom)
 {
     int iExecute = 0;
     try
     {
         string sqlStr = "";
         sqlStr += "UPDATE  Approve_Company11 SET  ";
         sqlStr += "AppStatus=@AppStatus,Remark=@Remark,CheckTime=@CheckTime";
         sqlStr += " where ID=@ID";
         SqlParameter[] para = new SqlParameter[]
         {
         new SqlParameter("@AppStatus",SqlDbType.NVarChar,20),
         new SqlParameter("@Remark",SqlDbType.Text),
         new SqlParameter("@CheckTime",SqlDbType.DateTime),
         new SqlParameter("@ID",SqlDbType.Int),
         };
         para[0].Value = AppCom.AppStatus;
         para[1].Value = AppCom.Remark;
         para[2].Value = AppCom.CheckTime;
         para[3].Value = AppCom.ID;
         object obj = DbHelperSQL.ExecuteSql(sqlStr, para);
         if (obj != null)
         {
             iExecute = Convert.ToInt32(obj);
         }
     }
     catch (Exception e)
     {
         Log4Net.LogWrite("err", "Controler\\UpdateAppCom" + e.Message);
     }
     return iExecute;
 }
示例#5
0
        /// <summary>
        ///   根据查询码查询申请记录
        /// </summary>
        /// <param name="code">查询码</param>
        /// <returns>一条申请记录或null</returns>
        public static Approve_Company FindAppComByQueryCode(string code)
        {
            Approve_Company AppCom = new Approve_Company();
            string sql = null;
            try
            {
                sql = "SELECT * FROM Approve_Company11 WHERE QueryCode=@QueryCode";
                SqlParameter para = new SqlParameter("@QueryCode", SqlDbType.NVarChar, 10);
                para.Value = code;
                DataSet ds = null;
                ds = DbHelperSQL.Query(sql, para);

                if (ds != null)
                {
                    DataTable dt = ds.Tables[0];
                    DataRow dr = dt.Rows[0];
                    AppCom.ID = Convert.ToInt32(dr["ID"]);
                    AppCom.UserName = dr["UserName"].ToString();
                    AppCom.Tel = dr["Tel"].ToString();
                    AppCom.CompanyName = dr["CompanyName"].ToString();
                    AppCom.AppType = dr["AppType"].ToString();
                    AppCom.AppStatus = dr["AppStatus"].ToString();
                    AppCom.Remark = dr["Remark"].ToString();
                    AppCom.AppTime = Convert.ToDateTime(dr["AppTime"]);
                    if (dr["CheckTime"] != DBNull.Value)
                    {
                        AppCom.CheckTime = Convert.ToDateTime(dr["CheckTime"]);
                    }
                    AppCom.FilePath = dr["FilePath"].ToString();
                    AppCom.QueryCode = code;
                }
                else
                {
                    AppCom = null;
                }
            }
            catch (Exception e)
            {
                Log4Net.LogWrite("err", "Controler\\FindYouFu_TypeById" + e.Message);
            }

            return AppCom;
        }
示例#6
0
        protected void btnSubUpload_Click(object sender, EventArgs e)
        {
            Approve_Company AppCom = new Approve_Company();

            string userName = txtUserName.Text.Trim();
            string tel = txtTel.Text.Trim();
            string companyName = txtCompany.Text.Trim();

            if (string.IsNullOrEmpty(userName))
            {
                MessageBox.Show(this, "请填写用户名!");
                return;
            }

            if (string.IsNullOrEmpty(tel))
            {
                MessageBox.Show(this, "请填写电话!");
                return;
            }

            if (string.IsNullOrEmpty(companyName))
            {
                MessageBox.Show(this, "请填写公司名!");
                return;
            }

            int kindIndex = ddlApplyKind.SelectedIndex;
            string kind = "";

            switch (kindIndex)
            {
                case 0:
                    kind = "变更";
                    break;
                case 1:
                    kind = "登记";
                    break;
                case 2:
                    kind = "注销";
                    break;

            }

            if (fuApplyFile.HasFile)
            {
                string extentionName = System.IO.Path.GetExtension(fuApplyFile.FileName);
                if (extentionName == ".doc" || extentionName == ".docx")
                {
                    string time = DateTime.Now.ToString("yyyyMMyyHms");
                    lbUploadWarning.Text = "正在上传请稍后。。。";
                    fuApplyFile.SaveAs(Server.MapPath("~/Uploads/" + kind + "/") + userName + time + extentionName);
                    lbUploadWarning.Text = "上传成功!";

                    string code = Med_Ass.GenerateRandomNumber(6);

                    AppCom.UserName = userName;
                    AppCom.Tel = tel;
                    AppCom.CompanyName = companyName;
                    AppCom.AppType = kind;
                    AppCom.FilePath = kind + "/" + userName + time + extentionName;
                    AppCom.AppStatus = "未审核";
                    AppCom.AppTime = DateTime.Now;
                    AppCom.QueryCode = code;

                    int n = Ctrl_App_Com.AddAppCom(AppCom);
                    if (n > 0)
                    {
                        MessageBox.Show(this, " 插入成功!");
                        Response.Redirect("Result.aspx?code=" + code);
                    }
                    else
                    {
                        MessageBox.Show(this, " 插入失败,请重试!");
                        return;
                    }
                }
                else
                {
                    MessageBox.Show(this, " 上传文档格式错误,只支持(doc docx)格式的文件");
                    return;
                }

            }

            else
            {
                lbUploadWarning.Text = "请选择要上传的文件";
            }
        }