コード例 #1
0
ファイル: OdersDetail.aspx.cs プロジェクト: c6supper/huangxin
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "")
            {
                string orderid = Request.QueryString["id"].ToString();
                order= obll.getOrdersViewModel(int.Parse(orderid));
                this.customer_name.Text = order.Username;
                this.sales_orderid.Text = order.OrderNo;
                this.customer_address.Text = order.Address;

                //查询详细客户信息
                 c= cb.GetModel(int.Parse(order.Customerid.ToString()));
                 this.customer_linker.Text = c.link_men;
                 this.customer_tel.Text = order.Tel + "/" + order.Mobile;
                 this.customet_email.Text = c.email;

                //查询详细物流公司信息
                tbLogs logs=new tbLogs();
                tbLogsBLL tblogbll=new tbLogsBLL();
                if (order.Logid != null)
                {
                    logs = tblogbll.tbLogs_GetModel(order.Logid.ToString());
                    this.logistics.Text = logs.LogisticsName;
                    this.logistics_num.Text = order.LogNumber;
                }
                this.state.Text = order.StateName;
                this.create_date.Text = DateTime.Parse(order.createdate.ToString()).ToString("yyyy-MM-dd");
                attach_pay.Text =decimal.Parse(order.Postmoney.ToString()).ToString("0.00");

                dt = sql.getDataByCondition("dbo.OrdersPro_View", "*", " OrderID="+order.OrderID);

            }
        }
コード例 #2
0
ファイル: tbLogsBLL.cs プロジェクト: c6supper/huangxin
 /// <summary>
 /// 修改业务方法封装
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public int tbLogs_Update(tbLogs model)
 {
     SqlParameter[] pars = new SqlParameter[]{
     new SqlParameter("@ID",model.ID),
     new SqlParameter("@LogisticsName",model.LogisticsName),
     new SqlParameter("@Address",model.Address),
     new SqlParameter("@LinkMan",model.LinkMan),
     new SqlParameter("@Tel",model.Tel),
     new SqlParameter("@Mobile",model.Mobile)
     };
      return  sqlhelper.ExcuteCommandReturnInt("tbLogs_Update", CommandType.StoredProcedure, pars);
 }
コード例 #3
0
ファイル: logsedit.aspx.cs プロジェクト: c6supper/huangxin
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         if (Request.QueryString["id"] != null)
         {
             string id = Request.QueryString["id"].ToString();
             logs = logsbll.tbLogs_GetModel(id);
             this.txtAddress.Text = logs.Address;
             this.txtLinkMan.Text = logs.LinkMan;
             this.txtLogsName.Text = logs.LogisticsName;
             this.txtMobie.Text = logs.Mobile;
             this.txtTel.Text = logs.Tel;
         }
         else
         {
             Response.Redirect("logsList.aspx");
         }
     }
 }
コード例 #4
0
ファイル: tbLogsBLL.cs プロジェクト: c6supper/huangxin
        /// <summary>
        /// 获取详细对象
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public tbLogs tbLogs_GetModel(string id)
        {
            SqlParameter[] pars = new SqlParameter[]{
               new SqlParameter("@ID",int.Parse(id))
               };
               SqlDataReader reader= sqlhelper.SelectSqlReturnDataReader("tbLogs_GetModel", CommandType.StoredProcedure, pars);
               tbLogs logs = new tbLogs();
               if (reader.Read())
               {
               logs.ID =int.Parse(reader["ID"].ToString());
               logs.LogisticsName = reader["LogisticsName"].ToString();
               logs.Mobile = reader["Mobile"].ToString();
               logs.Tel = reader["Tel"].ToString();
               logs.LinkMan = reader["LinkMan"].ToString();
               logs.Address = reader["Address"].ToString();

               }
               reader.Close();
               return logs;
        }
コード例 #5
0
ファイル: logsAdd.aspx.cs プロジェクト: c6supper/huangxin
 protected void btnSave_Click(object sender, EventArgs e)
 {
     tbLogs logs = new tbLogs()
     {
         Address = txtAddress.Text,
         LinkMan = txtLinkMan.Text,
         LogisticsName = txtLogsName.Text,
         Mobile = txtMobie.Text,
         Tel = txtTel.Text
     };
     tbLogsBLL logsbll = new tbLogsBLL();
       int count=   logsbll.tbLogs_ADD(logs);
       if (count != 0)
       {
       Response.Redirect("logsList.aspx");
       }
       else
       {
       ClientScript.RegisterStartupScript(this.GetType(), "test", "alert('添加失败')", true);
       }
 }
コード例 #6
0
ファイル: tbLogsBLL.cs プロジェクト: c6supper/huangxin
 /// <summary>
 /// 物流公司信息添加业务
 /// </summary>
 /// <param name="model">tbLogs对象</param>
 /// <returns>int</returns>
 public int tbLogs_ADD(tbLogs model)
 {
     SqlParameter[] pars = new SqlParameter[]{
     new SqlParameter("@ID",SqlDbType.Int,4),
     new SqlParameter("@LogisticsName",model.LogisticsName),
     new SqlParameter("@Address",model.Address),
     new SqlParameter("@LinkMan",model.LinkMan),
     new SqlParameter("@Tel",model.Tel),
     new SqlParameter("@Mobile",model.Mobile)
        };
        pars[0].Direction = ParameterDirection.Output;
        int count=  sqlhelper.ExcuteCommandReturnInt("tbLogs_ADD", CommandType.StoredProcedure, pars);
        if (count != 0)
        {
        return int.Parse(pars[0].Value.ToString());
        }
        else
        {
        return 0;
        }
 }