/// <summary>
/// 初始化商户注册之卖家信息(店铺名称)
/// </summary>
/// <param name="userid">用户编号</param>
/// <param name="stroename">店铺名称</param>
public void GetStorename(int userid, ref string stroename)
{
model = dal.GetStorename(userid);
if (model != null)
{
stroename = model.shop_name;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(QAMZN.Model.tb_virtual_shop model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_virtual_shop(");
strSql.Append("user_id,shop_name,shop_level,shop_intro,shop_logo,shop_link,service_email,service_phone,service_reply_email,vacation,about_seller,shipping_rates,shipping_policies,FAQ,privacy_policy)");
strSql.Append(" values (");
strSql.Append("@user_id,@shop_name,@shop_level,@shop_intro,@shop_logo,@shop_link,@service_email,@service_phone,@service_reply_email,@vacation,@about_seller,@shipping_rates,@shipping_policies,@FAQ,@privacy_policy)");
SqlParameter[] parameters =
{
new SqlParameter("@user_id", SqlDbType.Int, 4),
new SqlParameter("@shop_name", SqlDbType.VarChar, 50),
new SqlParameter("@shop_level", SqlDbType.Int, 4),
new SqlParameter("@shop_intro", SqlDbType.Text),
new SqlParameter("@shop_logo", SqlDbType.VarChar, 20),
new SqlParameter("@shop_link", SqlDbType.VarChar, 500),
new SqlParameter("@service_email", SqlDbType.VarChar, 50),
new SqlParameter("@service_phone", SqlDbType.VarChar, 50),
new SqlParameter("@service_reply_email", SqlDbType.VarChar, 50),
new SqlParameter("@vacation", SqlDbType.Int, 4),
new SqlParameter("@about_seller", SqlDbType.Text),
new SqlParameter("@shipping_rates", SqlDbType.Text),
new SqlParameter("@shipping_policies", SqlDbType.Text),
new SqlParameter("@FAQ", SqlDbType.Text),
new SqlParameter("@privacy_policy", SqlDbType.Text)
};
parameters[0].Value = model.user_id;
parameters[1].Value = model.shop_name;
parameters[2].Value = model.shop_level;
parameters[3].Value = model.shop_intro;
parameters[4].Value = model.shop_logo;
parameters[5].Value = model.shop_link;
parameters[6].Value = model.service_email;
parameters[7].Value = model.service_phone;
parameters[8].Value = model.service_reply_email;
parameters[9].Value = model.vacation;
parameters[10].Value = model.about_seller;
parameters[11].Value = model.shipping_rates;
parameters[12].Value = model.shipping_policies;
parameters[13].Value = model.FAQ;
parameters[14].Value = model.privacy_policy;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取卖家详细资料
/// </summary>
/// <param name="userid">用户编号</param>
/// <param name="Str">查询条件</param>
public string GetShopInfo(int userid, ref string Str)
{
model = dal.GetStorename(userid);
if (model != null)
{
return("\"shop_name\":\"" + QGYHelper.FormatCode.FormatUrlEncode(model.shop_name)
+ "\",\"shop_link\":\"" + QGYHelper.FormatCode.FormatUrlEncode(model.shop_link)
+ "\",\"service_email\":\"" + QGYHelper.FormatCode.FormatUrlEncode(model.service_email)
+ "\",\"service_phone\":\"" + QGYHelper.FormatCode.FormatUrlEncode(model.service_phone)
+ "\",\"service_reply_email\":\"" + QGYHelper.FormatCode.FormatUrlEncode(model.service_reply_email)
+ "\",\"vacation\":\"" + model.vacation
+ "\"");
}
else
{
return("");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public QAMZN.Model.tb_virtual_shop GetStorename(int user_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 user_id,shop_name,shop_level,shop_intro,shop_logo,shop_link,service_email,service_phone,service_reply_email,vacation,about_seller,shipping_rates,shipping_policies,FAQ,privacy_policy from tb_virtual_shop ");
strSql.Append(" where user_id=@user_id ");
SqlParameter[] parameters =
{
new SqlParameter("@user_id", SqlDbType.Int, 4)
};
parameters[0].Value = user_id;
QAMZN.Model.tb_virtual_shop model = new QAMZN.Model.tb_virtual_shop();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public QAMZN.Model.tb_virtual_shop DataRowToModel(DataRow row)
{
QAMZN.Model.tb_virtual_shop model = new QAMZN.Model.tb_virtual_shop();
if (row != null)
{
if (row["user_id"] != null && row["user_id"].ToString() != "")
{
model.user_id = int.Parse(row["user_id"].ToString());
}
if (row["shop_name"] != null)
{
model.shop_name = row["shop_name"].ToString();
}
if (row["shop_level"] != null && row["shop_level"].ToString() != "")
{
model.shop_level = int.Parse(row["shop_level"].ToString());
}
if (row["shop_intro"] != null)
{
model.shop_intro = row["shop_intro"].ToString();
}
if (row["shop_logo"] != null)
{
model.shop_logo = row["shop_logo"].ToString();
}
if (row["shop_link"] != null)
{
model.shop_link = row["shop_link"].ToString();
}
if (row["service_email"] != null)
{
model.service_email = row["service_email"].ToString();
}
if (row["service_phone"] != null)
{
model.service_phone = row["service_phone"].ToString();
}
if (row["service_reply_email"] != null)
{
model.service_reply_email = row["service_reply_email"].ToString();
}
if (row["vacation"] != null && row["vacation"].ToString() != "")
{
model.vacation = int.Parse(row["vacation"].ToString());
}
if (row["about_seller"] != null)
{
model.about_seller = row["about_seller"].ToString();
}
if (row["shipping_rates"] != null)
{
model.shipping_rates = row["shipping_rates"].ToString();
}
if (row["shipping_policies"] != null)
{
model.shipping_policies = row["shipping_policies"].ToString();
}
if (row["FAQ"] != null)
{
model.FAQ = row["FAQ"].ToString();
}
if (row["privacy_policy"] != null)
{
model.privacy_policy = row["privacy_policy"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(QAMZN.Model.tb_virtual_shop model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_virtual_shop set ");
strSql.Append("shop_name=@shop_name,");
strSql.Append("shop_level=@shop_level,");
strSql.Append("shop_intro=@shop_intro,");
strSql.Append("shop_logo=@shop_logo,");
strSql.Append("shop_link=@shop_link,");
strSql.Append("service_email=@service_email,");
strSql.Append("service_phone=@service_phone,");
strSql.Append("service_reply_email=@service_reply_email,");
strSql.Append("vacation=@vacation,");
strSql.Append("about_seller=@about_seller,");
strSql.Append("shipping_rates=@shipping_rates,");
strSql.Append("shipping_policies=@shipping_policies,");
strSql.Append("FAQ=@FAQ,");
strSql.Append("privacy_policy=@privacy_policy");
strSql.Append(" where user_id=@user_id ");
SqlParameter[] parameters =
{
new SqlParameter("@shop_name", SqlDbType.VarChar, 50),
new SqlParameter("@shop_level", SqlDbType.Int, 4),
new SqlParameter("@shop_intro", SqlDbType.Text),
new SqlParameter("@shop_logo", SqlDbType.VarChar, 20),
new SqlParameter("@shop_link", SqlDbType.VarChar, 500),
new SqlParameter("@service_email", SqlDbType.VarChar, 50),
new SqlParameter("@service_phone", SqlDbType.VarChar, 50),
new SqlParameter("@service_reply_email", SqlDbType.VarChar, 50),
new SqlParameter("@vacation", SqlDbType.Int, 4),
new SqlParameter("@about_seller", SqlDbType.Text),
new SqlParameter("@shipping_rates", SqlDbType.Text),
new SqlParameter("@shipping_policies", SqlDbType.Text),
new SqlParameter("@FAQ", SqlDbType.Text),
new SqlParameter("@privacy_policy", SqlDbType.Text),
new SqlParameter("@user_id", SqlDbType.Int, 4)
};
parameters[0].Value = model.shop_name;
parameters[1].Value = model.shop_level;
parameters[2].Value = model.shop_intro;
parameters[3].Value = model.shop_logo;
parameters[4].Value = model.shop_link;
parameters[5].Value = model.service_email;
parameters[6].Value = model.service_phone;
parameters[7].Value = model.service_reply_email;
parameters[8].Value = model.vacation;
parameters[9].Value = model.about_seller;
parameters[10].Value = model.shipping_rates;
parameters[11].Value = model.shipping_policies;
parameters[12].Value = model.FAQ;
parameters[13].Value = model.privacy_policy;
parameters[14].Value = model.user_id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
