订单部分更新查询

View Code
1 <div>
2 <table cellpadding="5" cellspacing="0" border="0" class="member_info">
3 <tr>
4 <td style="width: 500px; float: left;">
5 &nbsp;<asp:TextBox ID="Cid" runat="server" Style="display: none;"></asp:TextBox>
6 <asp:TextBox ID="address_Id" runat="server" Style="display: none;"></asp:TextBox>
7 </td>
8 </tr>
9 </table>
10 <div class="member_tit03">
11 </div>
12 <table cellpadding="5" cellspacing="0" border="0" class="member_info">
13 <tr>
14 <th>
15 Email
16 </th>
17 <td>
18 <asp:TextBox class="member_txt01" ID="Email" runat="server" Width="260px" MaxLength="96"></asp:TextBox>
19 </td>
20 </tr>
21 <tr>
22 <th>
23 Name
24 </th>
25 <td class="title">
26 <asp:TextBox class="member_txt01" ID="MemberName" runat="server" Width="260px" MaxLength="80"></asp:TextBox>
27 </td>
28 </tr>
29 <tr>
30 <th>
31 Mobile
32 </th>
33 <td>
34 <asp:TextBox class="member_txt01" ID="address_mobile" runat="server" Width="260px"
35 MaxLength="80"></asp:TextBox>
36 </td>
37 </tr>
38 <tr>
39 <th>
40 Phone
41 </th>
42 <td>
43 <asp:TextBox class="member_txt01" ID="address_phone" runat="server" Width="260px"
44 MaxLength="80"></asp:TextBox>
45 </td>
46 </tr>
47 <tr>
48 <th valign="top">
49 Address
50 </th>
51 <td>
52 <asp:TextBox class="member_txt01" ID="address_Address1" runat="server" Width="260px"
53 MaxLength="80"></asp:TextBox>
54 </td>
55 </tr>
56 <tr>
57 <th>
58 Postcode
59 </th>
60 <td>
61 <asp:TextBox class="member_txt01" ID="address_postcode" runat="server" Width="260px"
62 MaxLength="80"></asp:TextBox>
63 </td>
64 </tr>
65 <tr>
66 <th>
67 Remark
68 </th>
69 <td>
70 <asp:TextBox class="member_txt01" ID="Remark" runat="server" Width="320" Height="120"
71 TextMode="MultiLine"></asp:TextBox>
72 </td>
73 </tr>
74 <tr>
75 <th>
76 &nbsp;
77 </th>
78 <td>
79 <asp:Button ID="Save" runat="server" CssClass="member_btn01" Text=" Save " OnClick="SavaClient_Click" />
80 </td>
81 </tr>
82 </table>
83 </div>
Cs Code
using System;
using System.Collections;
using System.Data;
using System.Web.UI;
using System.Web.UI.WebControls;
using Sigil.Common;
using SigilSoft.Data.SqlClient;
using Sigil.Task;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using Sigil.Stock;

namespace Sigil.Ste37
{
/// <summary>
/// 信息设置自定义画面
/// </summary>
public partial class ClientDetail : PageList
{
#region 声明控件
protected TextBox Email = new TextBox();
protected TextBox MemberName = new TextBox();
protected RadioButton SexMan = new RadioButton();
protected RadioButton SexWoman = new RadioButton();
protected TextBox birthday = new TextBox();
protected TextBox address_mobile = new TextBox();
protected TextBox address_phone = new TextBox();
protected TextBox address_Address1 = new TextBox();
protected TextBox address_postcode = new TextBox();
protected TextBox Remark = new TextBox();
protected Button Save = new Button();
protected TextBox Cid = new TextBox();
protected TextBox address_Id = new TextBox();
protected TextBox Mes_success = new TextBox();
protected TextBox Mes_failed = new TextBox();
#endregion

protected Member member = new Member();
//页面载入
protected void Page_Load(object sender, EventArgs e)
{

if (!IsPostBack)
{
ReadCilent();
}
}

#region 保存
protected void SavaClient_Click(object sender, EventArgs e)
{
if (SaveClinet())
{

MessageBox.Show(
"修改成功", MainPanel, this.GetType());

}
else
{
MessageBox.Show(
"修改失败", MainPanel, this.GetType());
}
}
//保存信息
protected bool SaveClinet()
{
//Members.MemberUpdate(3, MemberName.Text, "", "", Email.Text, 0, "", DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, 0, 0, true, "");
member.MemberId = TypeParser.ToInt32(Cid.Text);
member.MemberName
= MemberName.Text;
member.Sex
= SexMan.Checked;
member.Email
= Email.Text;
member.Remark
= Remark.Text;
member.Birthday
= birthday.Text;

MemberAddress ma
= new MemberAddress();
ma.Fax
= MemberName.Text;
ma.Address2
= " ";
ma.City
= "";
ma.Province
= "";
ma.Country
= "";
ma.Postcode
= address_postcode.Text;

ma.Maid
= TypeParser.ToInt32(address_Id.Text);
ma.Mid
= TypeParser.ToInt32(Cid.Text);
ma.Mobile
= address_mobile.Text;
ma.Phone
= address_phone.Text;
ma.Address1
= address_Address1.Text;
Collection
<Gladiator> mAddressList = new Collection<Gladiator>();
mAddressList.Add(ma);
int sucess = 0;

if (Cid.Text.Equals(string.Empty) == false)
sucess
= Members.DoMemberANDAddressUpdateTransaction(member, mAddressList);
else
sucess
= Members.DoMemberAndAddressInsertTransaction(member, mAddressList);

if (sucess == 0)
{
return false;
}
return true;
}


#endregion

#region 读取会员数据
protected void ReadCilent()
{
// int memberId = Convert.ToInt32(SessionHelper.GetSession("mid"));
int memberId = 3;
member
= Members.GetDetail(memberId);
Cid.Text
= memberId.ToString();
Email.Text
= member.Email.ToString();
MemberName.Text
= member.MemberName.ToString();
if (member.Sex == true)
{
SexMan.Checked
= true;
SexWoman.Checked
= false;
}
else
{
SexWoman.Checked
= true;
SexMan.Checked
= false;
}
birthday.Text
= member.Birthday.ToString();
Remark.Text
= member.Remark.ToString();

//读取第一条地址
ReadFirstAddress(memberId);
}

#endregion

#region 读取第一条地址

/// <summary>
/// 读取地址
/// </summary>
/// <param name="memberId"></param>
private void ReadFirstAddress(int memberId)
{
DataTable add
= Members.GetAddresssList(memberId);
if (add != null && add.Rows.Count > 0)
{
DataRow address
= add.Rows[0];
address_Id.Text
= TypeParser.ToString(address["maid"]);
address_Address1.Text
= TypeParser.ToString(address["address1"]);
address_mobile.Text
= TypeParser.ToString(address["mobile"]);
address_phone.Text
= TypeParser.ToString(address["phone"]);
address_postcode.Text
= TypeParser.ToString(address["postcode"]);

}
}
#endregion

}
}
posted @ 2011-03-24 16:32  Ryo  阅读(278)  评论(0编辑  收藏  举报