public bool Update(tbSenderInfo Sender)
{
bool IsOk = false;
IDbDataParameter[] parm = DBHelper.GetCacheParameters(SQL_UPDATE);
if (parm == null)
{
parm = new SqlParameter[] {
new SqlParameter(PARM_ID, SqlDbType.Int),
new SqlParameter(PARM_SID, SqlDbType.Int),
new SqlParameter(PARM_SNAME, SqlDbType.VarChar, 50),
new SqlParameter(PARM_NAME, SqlDbType.VarChar, 50),
new SqlParameter(PARM_TEL, SqlDbType.VarChar, 20),
new SqlParameter(PARM_MOBILE, SqlDbType.VarChar, 20),
new SqlParameter(PARM_ADD, SqlDbType.VarChar, 500),
new SqlParameter(PARM_CNAME, SqlDbType.VarChar, 100),
new SqlParameter(PARM_PROVINCE, SqlDbType.VarChar, 50),
new SqlParameter(PARM_CITY, SqlDbType.VarChar, 50),
new SqlParameter(PARM_DIS, SqlDbType.VarChar, 50),
new SqlParameter(PARM_CODE, SqlDbType.VarChar, 50),
new SqlParameter(PARM_SCODE, SqlDbType.VarChar, 50)
};
DBHelper.CacheParameters(SQL_UPDATE, parm);
}
parm[0].Value = Sender.SenderId;
parm[1].Value = Sender.ShopId;
parm[2].Value = Sender.ShopName;
parm[3].Value = Sender.SenderName;
parm[4].Value = Sender.SenderTel;
parm[5].Value = Sender.SenderMobile;
parm[6].Value = Sender.SenderAdd;
parm[7].Value = Sender.CompanyName;
parm[8].Value = Sender.Province;
parm[9].Value = Sender.City;
parm[10].Value = Sender.District;
parm[11].Value = Sender.PostCode;
parm[12].Value = Sender.ShopCode;
try
{
DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, SQL_UPDATE, parm);
IsOk = true;
}
catch { }
return(IsOk);
}
public tbSenderInfo SelectByUserId(int UserId)
{
tbSenderInfo Sender = null;
IDbDataParameter[] parm = DBHelper.GetCacheParameters(SQL_SELECT_UID);
if (parm == null)
{
parm = new SqlParameter[] {
new SqlParameter(PARM_UID, SqlDbType.Int)
};
DBHelper.CacheParameters(SQL_SELECT_UID, parm);
}
parm[0].Value = UserId;
using (IDataReader MyReader = DBHelper.ExecuteReader(CommandType.StoredProcedure, SQL_SELECT_UID, parm))
{
if (MyReader.Read())
{
Sender = new tbSenderInfo()
{
SenderId = MyReader.GetInt32(0),
ShopId = MyReader.GetInt32(1),
ShopName = MyReader.GetString(2),
SenderName = MyReader.GetString(3),
SenderTel = MyReader.GetString(4),
SenderMobile = MyReader.GetString(5),
SenderAdd = MyReader.GetString(6),
CompanyName = MyReader.GetString(7),
Province = MyReader.GetString(8),
City = MyReader.GetString(9),
District = MyReader.GetString(10),
PostCode = MyReader.GetString(11),
ShopCode = MyReader.GetString(12)
};
}
}
return(Sender == null ? new tbSenderInfo() : Sender);
}
/// <summary>
/// 修改寄件人信息
/// </summary>
/// <param name="Sender">寄件人信息表</param>
/// <returns></returns>
public static bool Update(tbSenderInfo Sender)
{
return(SenderInfoDal.Update(Sender));
}
