/// <summary>
/// 新增地址
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string AddMailAddress(MmailAddress model)
{
if (!this.CheckIsLogin())
{
return("-1");
}
model.userId = Session["loginuserId"] + string.Empty;
model.userName = Session["loginuserName"] + string.Empty;
new MailAddressBus().AddMailAddress(model);
return(string.Empty);
}
/// <summary>
/// 新增地址
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddMailAddress(MmailAddress model)
{
try
{
model.isDefault = "1";
model.addressId = PublicTools.GetRandomNumberByTime();
return(opertService.AddMailAddress(model));
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// 根据用户ID获取其全部地址信息
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public List <MmailAddress> GetMmailAddressesByUserId(string userId)
{
string sql = "select addressId,userId,userName,province,city,area,detailedAddress,contactName,contactTell,isDefault,isDelete,isEffective,great_time,modify_time from mailAddress where userId=?userId;";
List <MySqlParameter> parameterList = new List <MySqlParameter>();
MySqlParameter parameter = new MySqlParameter("?userId", MySqlDbType.VarChar, 25);
parameter.Value = userId;
parameterList.Add(parameter);
List <MmailAddress> listModel = null;
using (MySqlDataReader sqlDataReader = PKMySqlHelper.ExecuteReader(sql, parameterList.ToArray()))
{
if (sqlDataReader != null)
{
listModel = new List <MmailAddress>();
while (sqlDataReader.Read())
{
MmailAddress model = new MmailAddress();
model.addressId = sqlDataReader["addressId"] != DBNull.Value ? sqlDataReader["addressId"].ToString() : string.Empty;
model.userId = sqlDataReader["userId"] != DBNull.Value ? sqlDataReader["userId"].ToString() : string.Empty;
model.userName = sqlDataReader["userName"] != DBNull.Value ? sqlDataReader["userName"].ToString() : string.Empty;
model.userName = Base64.DecodeBase64(model.userName);
model.province = sqlDataReader["province"] != DBNull.Value ? sqlDataReader["province"].ToString() : string.Empty;
model.city = sqlDataReader["city"] != DBNull.Value ? sqlDataReader["city"].ToString() : string.Empty;
model.area = sqlDataReader["area"] != DBNull.Value ? sqlDataReader["area"].ToString() : string.Empty;
model.detailedAddress = sqlDataReader["detailedAddress"] != DBNull.Value ? sqlDataReader["detailedAddress"].ToString() : string.Empty;
model.contactName = sqlDataReader["contactName"] != DBNull.Value ? sqlDataReader["contactName"].ToString() : string.Empty;
model.contactTell = sqlDataReader["contactTell"] != DBNull.Value ? sqlDataReader["contactTell"].ToString() : string.Empty;
model.isDefault = sqlDataReader["isDefault"] != DBNull.Value ? sqlDataReader["isDefault"].ToString() : string.Empty;
model.great_time = sqlDataReader["great_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["great_time"].ToString()) : DateTime.MinValue;
model.modify_time = sqlDataReader["modify_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["modify_time"].ToString()) : DateTime.MinValue;
listModel.Add(model);
}
}
}
return(listModel);
}
/// <summary>
/// 新增地址
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddMailAddress(MmailAddress model)
{
return(opertService.AddMailAddress(model));
}
/// <summary>
/// 新增地址
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddMailAddress(MmailAddress model)
{
//// sql语句
string sql = "";
if (model.isDefault == "1")
{
sql = "update mailAddress set isDefault=0 where userId=?userId;";
}
sql += "INSERT INTO mailAddress (addressId,userId,userName,province,city,area,detailedAddress,contactName,contactTell,isDefault,isDelete,isEffective,great_time,modify_time) " +
"VALUES(?addressId,?userId,?userName,?province,?city,?area,?detailedAddress,?contactName,?contactTell,?isDefault,?isDelete,?isEffective,?great_time,?modify_time)";
List <MySqlParameter> parameterList = new List <MySqlParameter>();
MySqlParameter parameter = new MySqlParameter("?addressId", MySqlDbType.VarChar, 25);
parameter.Value = model.addressId;
parameterList.Add(parameter);
parameter = new MySqlParameter("?userId", MySqlDbType.VarChar, 25);
parameter.Value = model.userId;
parameterList.Add(parameter);
parameter = new MySqlParameter("?userName", MySqlDbType.VarChar, 500);
parameter.Value = Base64.EncodeBase64(model.userName);
parameterList.Add(parameter);
parameter = new MySqlParameter("?province", MySqlDbType.VarChar, 30);
parameter.Value = string.IsNullOrEmpty(model.province)?"": model.province;
parameterList.Add(parameter);
parameter = new MySqlParameter("?city", MySqlDbType.VarChar, 30);
parameter.Value = string.IsNullOrEmpty(model.city) ? "" : model.city;
parameterList.Add(parameter);
parameter = new MySqlParameter("?area", MySqlDbType.VarChar, 30);
parameter.Value = string.IsNullOrEmpty(model.area) ? "" : model.area;
parameterList.Add(parameter);
parameter = new MySqlParameter("?detailedAddress", MySqlDbType.VarChar, 200);
parameter.Value = model.detailedAddress;
parameterList.Add(parameter);
parameter = new MySqlParameter("?contactName", MySqlDbType.VarChar, 30);
parameter.Value = model.contactName;
parameterList.Add(parameter);
parameter = new MySqlParameter("?contactTell", MySqlDbType.VarChar, 20);
parameter.Value = model.contactTell;
parameterList.Add(parameter);
parameter = new MySqlParameter("?isDefault", MySqlDbType.Int16, 1);
parameter.Value = model.isDefault;
parameterList.Add(parameter);
parameter = new MySqlParameter("?isDelete", MySqlDbType.Int16, 1);
parameter.Value = 0;
parameterList.Add(parameter);
parameter = new MySqlParameter("?isEffective", MySqlDbType.Int16, 1);
parameter.Value = 1;
parameterList.Add(parameter);
DateTime dateTime = System.DateTime.Now;
parameter = new MySqlParameter("?great_time", MySqlDbType.DateTime);
parameter.Value = dateTime;
parameterList.Add(parameter);
parameter = new MySqlParameter("?modify_time", MySqlDbType.DateTime);
parameter.Value = dateTime;
parameterList.Add(parameter);
//// 执行操作
return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0);
}
