public bool AddReceiptAddress(ReceiptAddress receiptAddress)
{
var result = false;
try
{
var sql = new StringBuilder();
sql.Append("INSERT INTO ReceiptAddress([User],[Addr],[ZipCode],[ConsigneeName],[ConsigneePhone],[Region],[Province],");
sql.Append("[City],[District],[Street],[IsDefault],[CreateDate],[CreateUser],[LastUpdateUser],[LastUpdateDate]) ");
sql.Append("VALUES(@User,@Addr,@ZipCode,@ConsigneeName,@ConsigneePhone,@Region,@Province,@City,@District,@Street,@IsDefault,@CreateDate,@CreateUser,@LastUpdateUser,@LastUpdateDate)");
var pars = new List <SqlParameter>();
pars.Add(new SqlParameter("@User", receiptAddress.User != null ? receiptAddress.User.UID : 0));
pars.Add(new SqlParameter("@Addr", receiptAddress.Addr));
pars.Add(new SqlParameter("@ZipCode", receiptAddress.ZipCode));
pars.Add(new SqlParameter("@ConsigneeName", receiptAddress.ConsigneeName));
pars.Add(new SqlParameter("@ConsigneePhone", receiptAddress.ConsigneePhone));
pars.Add(new SqlParameter("@Region", receiptAddress.Region));
pars.Add(new SqlParameter("@Province", receiptAddress.Province));
pars.Add(new SqlParameter("@District", receiptAddress.District));
pars.Add(new SqlParameter("@Street", receiptAddress.Street));
pars.Add(new SqlParameter("@IsDefault", receiptAddress.IsDefault));
pars.Add(new SqlParameter("@CreateDate", receiptAddress.CreateDate));
pars.Add(new SqlParameter("@CreateUser", receiptAddress.CreateUser.UID));
pars.Add(new SqlParameter("@LastUpdateDate", receiptAddress.LastUpdateDate));
result = SQLHelper.ExcuteSQL(sql.ToString(), pars.ToArray()) > 0;
}
catch (Exception ex)
{
}
return(result);
}
public bool UpdateReceiptAddress(ReceiptAddress receiptAddress)
{
var result = false;
try
{
var sql = new StringBuilder();
sql.Append("UPDATE ReceiptAddress SET [Addr]=@Addr,[ZipCode]=@ZipCode,[ConsigneeName]=@ConsigneeName,[ConsigneePhone]=@ConsigneePhone,");
sql.Append("[Region]=@Region,[Province]=@Province,[City]=@City,[District]=@District,[Street]=@Street,[IsDefault]=@IsDefault WHERE ID=@ID");
var pars = new List <SqlParameter>();
pars.Add(new SqlParameter("@ID", receiptAddress.ID));
pars.Add(new SqlParameter("@Addr", receiptAddress.Addr));
pars.Add(new SqlParameter("@ZipCode", receiptAddress.ZipCode));
pars.Add(new SqlParameter("@ConsigneeName", receiptAddress.ConsigneeName));
pars.Add(new SqlParameter("@ConsigneePhone", receiptAddress.ConsigneePhone));
pars.Add(new SqlParameter("@Region", receiptAddress.Region));
pars.Add(new SqlParameter("@Province", receiptAddress.Province));
pars.Add(new SqlParameter("@City", receiptAddress.City));
pars.Add(new SqlParameter("@District", receiptAddress.District));
pars.Add(new SqlParameter("@Street", receiptAddress.Street));
pars.Add(new SqlParameter("@IsDefault", receiptAddress.IsDefault));
result = SQLHelper.ExcuteSQL(sql.ToString(), pars.ToArray()) > 0;
}
catch (Exception ex)
{
}
return(result);
}
public List <ReceiptAddress> GetReceiptAddress(int userID)
{
var list = new List <ReceiptAddress>();
try
{
var sql = new StringBuilder();
sql.Append("SELECT [User],[Addr],[ZipCode],[ConsigneeName],[ConsigneePhone],[Region],[Province],[City],[District],[Street],");
sql.Append(string.Format("[IsDefault],[CreateDate],[CreateUser] FROM ReceiptAddress WHERE USER={0}", userID));
var dt = SQLHelper.GetTable(sql.ToString());
#region 提取数据
for (int i = 0; i < dt.Rows.Count; i++)
{
var obj = new ReceiptAddress
{
User = new User {
},
Addr = Convert.IsDBNull(dt.Rows[i]["Addr"]) ? "" : Convert.ToString(dt.Rows[i]["Addr"]),
ZipCode = Convert.IsDBNull(dt.Rows[i]["ZipCode"]) ? "" : Convert.ToString(dt.Rows[i]["ZipCode"]),
ConsigneeName = Convert.IsDBNull(dt.Rows[i]["ConsigneeName"]) ? "" : Convert.ToString(dt.Rows[i]["ConsigneeName"]),
ConsigneePhone = Convert.IsDBNull(dt.Rows[i]["Addr"]) ? "" : Convert.ToString(dt.Rows[i]["Addr"]),
Region = Convert.IsDBNull(dt.Rows[i]["Region"]) ? 0 : Convert.ToInt32(dt.Rows[i]["Region"]),
Province = Convert.IsDBNull(dt.Rows[i]["Province"]) ? 0 : Convert.ToInt32(dt.Rows[i]["Province"]),
City = Convert.IsDBNull(dt.Rows[i]["City"]) ? 0 : Convert.ToInt32(dt.Rows[i]["City"]),
District = Convert.IsDBNull(dt.Rows[i]["District"]) ? 0 : Convert.ToInt32(dt.Rows[i]["District"]),
Street = Convert.IsDBNull(dt.Rows[i]["Street"]) ? 0 : Convert.ToInt32(dt.Rows[i]["Street"]),
IsDefault = Convert.IsDBNull(dt.Rows[i]["IsDefault"]) ? false : Convert.ToBoolean(dt.Rows[i]["IsDefault"]),
CreateDate = Convert.IsDBNull(dt.Rows[i]["CreateDate"]) ? new DateTime() : Convert.ToDateTime(dt.Rows[i]["CreateDate"]),
};
list.Add(obj);
}
#endregion
}
catch (Exception ex)
{
}
return(list);
}
public bool UpdateReceiptAddress(ReceiptAddress receiptAddress)
{
return(dal.UpdateReceiptAddress(receiptAddress));
}
public bool AddReceiptAddress(ReceiptAddress receiptAddress)
{
return(dal.AddReceiptAddress(receiptAddress));
}
