Example #1
0
        public ActionResult AffiliApply()
        {
            Affiliate af = new Affiliate();
            Pan.Model.Affiliate model = new Pan.Model.Affiliate();
            model.mobile_num = Request.Form["shouji"];
            model.enterprise_type = Request.Form["txt_type"];
            model.enterprise = Request.Form["txt_corp"];
            model.time = DateTime.Now.ToString();
            model.person = Request.Form["txt_name"];
            model.person_post = Request.Form["txt_office"];
            af.Add(model);

            loan.Models.common.MailSender ms = new Models.common.MailSender();
            StringBuilder body = new StringBuilder();
            body.Append("<div>企业类型:");
            body.Append(model.enterprise_type);
            body.Append("</div>");
            body.Append("<div>企业名称:");
            body.Append(model.enterprise);
            body.Append("</div>");
            body.Append("<div>联系人:");
            body.Append(model.person);
            body.Append("</div>");
            body.Append("<div>联系人职务:");
            body.Append(model.person_post);
            body.Append("</div>");
            body.Append("<div>手机号码:");
            body.Append(model.mobile_num);
            body.Append("</div>");

            body.Append("<div>申请日期:");
            body.Append(model.time);
            body.Append("</div>");

            ms.send("加盟申请", body.ToString());

            return Content("<script>alert('申请成功,我们的工作人员会尽快跟您联系。');window.location='/Partner.html';</script>");
        }
Example #2
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Pan.Model.Affiliate DataRowToModel(DataRow row)
 {
     Pan.Model.Affiliate model=new Pan.Model.Affiliate();
     if (row != null)
     {
         if(row["id"]!=null && row["id"].ToString()!="")
         {
             model.id=int.Parse(row["id"].ToString());
         }
         if(row["enterprise"]!=null)
         {
             model.enterprise=row["enterprise"].ToString();
         }
         if(row["enterprise_type"]!=null)
         {
             model.enterprise_type=row["enterprise_type"].ToString();
         }
         if(row["person"]!=null)
         {
             model.person=row["person"].ToString();
         }
         if(row["person_post"]!=null)
         {
             model.person_post=row["person_post"].ToString();
         }
         if(row["mobile_num"]!=null)
         {
             model.mobile_num=row["mobile_num"].ToString();
         }
         if(row["time"]!=null)
         {
             model.time=row["time"].ToString();
         }
     }
     return model;
 }
Example #3
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Pan.Model.Affiliate GetModel(int id)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select  top 1 id,enterprise,enterprise_type,person,person_post,mobile_num,time from Affiliate ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
                    new SqlParameter("@id", SqlDbType.Int,4)
            };
            parameters[0].Value = id;

            Pan.Model.Affiliate model=new Pan.Model.Affiliate();
            DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
            if(ds.Tables[0].Rows.Count>0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }