/// <summary>
/// 申请开通店铺(成功返回true)
/// </summary>
/// <param name="ust"></param>
/// <returns></returns>
public bool InsertStoreTable(M_UserStoreTable ust)
{
try
{
string sql = @"INSERT INTO [ZL_UserStoreTable] (
[UserID],
[StoreName],
[StoreContent],
[StoreCredit],
[StoreVip],
[StoreType],
[StoreCash],
[StoreState],
[AddTime],
[StoreProvince],
[StoreCity]
) VALUES (
@UserID,
@StoreName,
@StoreContent,
@StoreCredit,
@StoreVip,
@StoreType,
@StoreCash,
@StoreState,
@AddTime,
@StoreProvince,
@StoreCity
)";
SqlParameter[] parameter =
{
new SqlParameter("UserID", ust.UserID),
new SqlParameter("StoreName", ust.StoreName),
new SqlParameter("StoreContent", ust.StoreContent),
new SqlParameter("StoreCredit", ust.StoreCredit),
new SqlParameter("StoreVip", ust.StoreVip),
new SqlParameter("StoreType", ust.StoreType),
new SqlParameter("StoreCash", ust.StoreCash),
new SqlParameter("StoreState", ust.StoreState),
new SqlParameter("StoreProvince", ust.StoreProvince),
new SqlParameter("StoreCity", ust.StoreCity),
new SqlParameter("AddTime", DateTime.Now)
};
if (SqlHelper.ExecuteScalar(CommandType.Text, sql, parameter) == null)
{
return(false);
}
else
{
return(true);
}
}
catch
{
throw;
}
}
public static void ReadStoreTable(SqlDataReader dr, M_UserStoreTable ust)
{
ust.ID = int.Parse(dr["ID"].ToString());
ust.UserID = int.Parse(dr["UserID"].ToString());
ust.StoreName = dr["StoreName"].ToString();
ust.StoreContent = dr["StoreContent"].ToString();
ust.StoreProvince = dr["StoreProvince"].ToString();
ust.StoreCity = dr["StoreCity"].ToString();
ust.StoreType = dr["StoreType"].ToString();
ust.StoreVip = int.Parse(dr["StoreVip"].ToString());
ust.StoreCredit = int.Parse(dr["StoreCredit"].ToString());
ust.StoreCash = decimal.Parse(dr["StoreCash"].ToString());
ust.AddTime = DateTime.Parse(dr["AddTime"].ToString());
ust.StoreState = int.Parse(dr["StoreState"].ToString());
ust.ID = int.Parse(dr["ID"].ToString());
//dr.Close();
}
/// <summary>
/// 根据用户ID得到店铺信息
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public M_UserStoreTable GetStoreTableByUserID(int userid)
{
try
{
string sql = @"select * from ZL_UserStoreTable where UserID=@userid";
SqlParameter[] parameter = { new SqlParameter("userid", userid) };
M_UserStoreTable ust = new M_UserStoreTable();
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, parameter))
{
if (dr.Read())
{
ReadStoreTable(dr, ust);
}
dr.Close();
dr.Dispose();
}
return(ust);
}
catch
{
throw;
}
}
public int insert(M_UserStoreTable model)
{
return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
/// <summary>
/// 根据ID更新
/// </summary>
public bool UpdateStoreTable(M_UserStoreTable model)
{
return(Sql.UpdateByIDs(strTableName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
}
