/// <summary>
/// 会员关注新增、修改、删除，返回1成功，其它失败
/// </summary>
/// <param name="FS">C:新增 U:修改 D:删除</param>
/// <param name="info">实体</param>
/// <returns></returns>
public int HuiYuanGuanZhu_CUD(string FS, Eyousoft_yhq.Model.MHuiYuanGuanZhuInfo info)
{
var cmd = _db.GetStoredProcCommand("proc_HuiYuan_GuanZhu_CUD");
_db.AddInParameter(cmd, "@IdentityId", DbType.Int32, info.IdentityId);
_db.AddInParameter(cmd, "@HuiYuanId1", DbType.AnsiStringFixedLength, info.HuiYuanId1);
_db.AddInParameter(cmd, "@HuiYuanId2", DbType.AnsiStringFixedLength, info.HuiYuanId2);
_db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime);
_db.AddInParameter(cmd, "@FS", DbType.AnsiStringFixedLength, FS);
_db.AddOutParameter(cmd, "@RetCode", DbType.Int32, 4);
int sqlExceptionCode = 0;
try
{
DbHelper.RunProcedure(cmd, _db);
}
catch (System.Data.SqlClient.SqlException e)
{
sqlExceptionCode = 0 - e.Number;
}
if (sqlExceptionCode < 0)
{
return(sqlExceptionCode);
}
return(Convert.ToInt32(_db.GetParameterValue(cmd, "@RetCode")));
}
/// <summary>
/// 微店新增、修改，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int WeiDian_CU(Eyousoft_yhq.Model.MWeiDianInfo info)
{
var cmd = _db.GetStoredProcCommand("proc_WeiDian_CU");
_db.AddInParameter(cmd, "@WeiDianId", DbType.AnsiStringFixedLength, info.WeiDianId);
_db.AddInParameter(cmd, "@HuiYuanId", DbType.AnsiStringFixedLength, info.HuiYuanId);
_db.AddInParameter(cmd, "@MingCheng", DbType.String, info.MingCheng);
_db.AddInParameter(cmd, "@Status", DbType.Int32, info.Status);
_db.AddInParameter(cmd, "@ShenQingTime", DbType.DateTime, info.ShenQingTime);
_db.AddInParameter(cmd, "@ShenHeTime", DbType.DateTime, info.ShenHeTime);
_db.AddInParameter(cmd, "@JieShao", DbType.String, info.JieShao);
_db.AddOutParameter(cmd, "@RetCode", DbType.Int32, 4);
_db.AddInParameter(cmd, "@LogoFilepath", DbType.String, info.LogoFilepath);
_db.AddInParameter(cmd, "@DianHua", DbType.String, info.DianHua);
int sqlExceptionCode = 0;
try
{
DbHelper.RunProcedure(cmd, _db);
}
catch (System.Data.SqlClient.SqlException e)
{
sqlExceptionCode = 0 - e.Number;
}
if (sqlExceptionCode < 0)
{
return(sqlExceptionCode);
}
return(Convert.ToInt32(_db.GetParameterValue(cmd, "RetCode")));
}
/// <summary>
/// 微店产品关系新增、删除，返回1成功，其它失败。
/// </summary>
/// <param name="weiDianId">微店编号</param>
/// <param name="huiYuanId">会员编号</param>
/// <param name="guanXiId">关系编号</param>
/// <param name="chanPinId">产品编号</param>
/// <param name="fs">操作方式 C:新增 D:删除</param>
/// <param name="caoZuoTime">操作时间</param>
/// <returns></returns>
public int WeiDianChanPinGuanXi_CD(string weiDianId, string huiYuanId, int guanXiId, string chanPinId, string fs, DateTime caoZuoTime)
{
var cmd = _db.GetStoredProcCommand("proc_WeiDian_ChanPinGuanXi_CD");
_db.AddInParameter(cmd, "@WeiDianId", DbType.AnsiStringFixedLength, weiDianId);
_db.AddInParameter(cmd, "@HuiYuanId", DbType.AnsiStringFixedLength, huiYuanId);
_db.AddInParameter(cmd, "@GuanXiId", DbType.Int32, guanXiId);
_db.AddInParameter(cmd, "@ChanPinId", DbType.AnsiStringFixedLength, chanPinId);
_db.AddInParameter(cmd, "@CaoZuoTime", DbType.DateTime, caoZuoTime);
_db.AddInParameter(cmd, "@FS", DbType.AnsiStringFixedLength, fs);
_db.AddOutParameter(cmd, "@RetCode", DbType.Int32, 4);
int sqlExceptionCode = 0;
try
{
DbHelper.RunProcedure(cmd, _db);
}
catch (System.Data.SqlClient.SqlException e)
{
sqlExceptionCode = 0 - e.Number;
}
if (sqlExceptionCode < 0)
{
return(sqlExceptionCode);
}
return(Convert.ToInt32(_db.GetParameterValue(cmd, "RetCode")));
}
/// <summary>
/// 微信用户新增修改，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int YongHu_CU(Eyousoft_yhq.Model.MWeiXinYongHuInfo info)
{
var cmd = _db.GetStoredProcCommand("proc_WeiXin_YongHu_CU");
_db.AddInParameter(cmd, "@YongHuId", DbType.AnsiStringFixedLength, info.YongHuId);
_db.AddInParameter(cmd, "@subscribe", DbType.String, info.subscribe);
_db.AddInParameter(cmd, "@openid", DbType.String, info.openid);
_db.AddInParameter(cmd, "@nickname", DbType.String, info.nickname);
_db.AddInParameter(cmd, "@sex", DbType.String, info.sex);
_db.AddInParameter(cmd, "@city", DbType.String, info.city);
_db.AddInParameter(cmd, "@country", DbType.String, info.country);
_db.AddInParameter(cmd, "@province", DbType.String, info.province);
_db.AddInParameter(cmd, "@language", DbType.String, info.language);
_db.AddInParameter(cmd, "@headimgurl", DbType.String, info.headimgurl);
_db.AddInParameter(cmd, "@subscribe_time", DbType.String, info.subscribe_time);
_db.AddInParameter(cmd, "@unionid", DbType.String, info.unionid);
_db.AddInParameter(cmd, "@createtime", DbType.DateTime, info.createtime);
_db.AddInParameter(cmd, "@latesttime", DbType.DateTime, info.latesttime);
_db.AddOutParameter(cmd, "@RetCode", DbType.Int32, 4);
_db.AddInParameter(cmd, "@LeiXing", DbType.Int32, info.LeiXing);
int sqlExceptionCode = 0;
try
{
DbHelper.RunProcedure(cmd, _db);
}
catch (System.Data.SqlClient.SqlException e)
{
sqlExceptionCode = 0 - e.Number;
}
if (sqlExceptionCode < 0)
{
return(sqlExceptionCode);
}
return(Convert.ToInt32(_db.GetParameterValue(cmd, "RetCode")));
}
/// <summary>
/// 删除/批量删除
/// </summary>
/// <param name="ProductIDs">单个ID/多个ID拼接的字符串</param>
/// <returns></returns>
public int Delete(string[] ProductIDs)
{
StringBuilder sId = new StringBuilder();
for (int i = 0; i < ProductIDs.Length; i++)
{
sId.AppendFormat("{0},", ProductIDs[i]);
}
sId.Remove(sId.Length - 1, 1);
DbCommand dc = this._db.GetStoredProcCommand("Proc_Product_Delete");
this._db.AddInParameter(dc, "ProductID", DbType.AnsiString, sId.ToString());
this._db.AddOutParameter(dc, "Result", DbType.Int32, 4);
DbHelper.RunProcedure(dc, this._db);
object Result = this._db.GetParameterValue(dc, "Result");
if (!Result.Equals(null))
{
return(int.Parse(Result.ToString()));
}
return(0);
}
/// <summary>
/// 绑定会员，返回1成功，其它失败
/// </summary>
/// <param name="yongHuId">用户编号</param>
/// <param name="openid">openid</param>
/// <param name="u">用户名</param>
/// <param name="p">密码</param>
/// <param name="huiYuanId">out 会员编号</param>
/// <returns></returns>
public int BangDingHuiYuan(string yongHuId, string openid, string u, string p, out string huiYuanId)
{
huiYuanId = string.Empty;
var cmd = _db.GetStoredProcCommand("proc_WeiXin_BangDingHuiYuan");
_db.AddInParameter(cmd, "@YongHuId", DbType.AnsiStringFixedLength, yongHuId);
_db.AddInParameter(cmd, "@openid", DbType.String, openid);
_db.AddInParameter(cmd, "@U", DbType.String, u);
_db.AddInParameter(cmd, "@P", DbType.String, p);
_db.AddOutParameter(cmd, "@RetCode", DbType.Int32, 4);
_db.AddOutParameter(cmd, "@HuiYuanId", DbType.String, 36);
int sqlExceptionCode = 0;
try
{
DbHelper.RunProcedure(cmd, _db);
}
catch (System.Data.SqlClient.SqlException e)
{
sqlExceptionCode = 0 - e.Number;
}
if (sqlExceptionCode < 0)
{
return(sqlExceptionCode);
}
int dbRetCode = Convert.ToInt32(_db.GetParameterValue(cmd, "RetCode"));
if (dbRetCode == 1)
{
huiYuanId = _db.GetParameterValue(cmd, "HuiYuanId").ToString();
}
return(dbRetCode);
}
