/// <summary>
/// 更新一条数据
/// </summary>
public int Update(MemberCZRecordModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Member_AccountRecord set ");
strSql.Append("memberId=@memberId,");
strSql.Append("money=@money,");
strSql.Append("moneyType=@moneyType,");
strSql.Append("remarks=@remarks,");
strSql.Append("addTime=@addTime,");
strSql.Append("addPerson=@addPerson,");
strSql.Append("shFlag=@shFlag,");
strSql.Append("shPerson=@shPerson,");
strSql.Append("shTime=@shTime");
strSql.Append(" where sysnumber=@sysnumber ");
SqlParameter[] parameters =
{
new SqlParameter("@sysnumber", SqlDbType.VarChar, 50),
new SqlParameter("@memberId", SqlDbType.Int, 4),
new SqlParameter("@money", SqlDbType.Decimal, 9),
new SqlParameter("@moneyType", SqlDbType.VarChar, 50),
new SqlParameter("@remarks", SqlDbType.VarChar, 500),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@addPerson", SqlDbType.VarChar, 50),
new SqlParameter("@shFlag", SqlDbType.Int, 4),
new SqlParameter("@shPerson", SqlDbType.VarChar, 50),
new SqlParameter("@shTime", SqlDbType.DateTime)
};
parameters[0].Value = model.sysnumber;
parameters[1].Value = model.memberId;
parameters[2].Value = model.money;
parameters[3].Value = model.moneyType;
parameters[4].Value = model.remarks;
parameters[5].Value = model.addTime;
parameters[6].Value = model.addPerson;
parameters[7].Value = model.shFlag;
parameters[8].Value = model.shPerson;
parameters[9].Value = model.shTime;
object obj = adoHelper.ExecuteSqlScalar(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MemberCZRecordModel GetModel(string sysnumber)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from T_Member_AccountRecord ");
strSql.Append(" where sysnumber=@sysnumber ");
SqlParameter[] parameters =
{
new SqlParameter("@sysnumber", SqlDbType.VarChar, 50)
};
parameters[0].Value = sysnumber;
MemberCZRecordModel model = new MemberCZRecordModel();
DataSet ds = adoHelper.ExecuteSqlDataset(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.sysnumber = ds.Tables[0].Rows[0]["sysnumber"].ToString();
if (ds.Tables[0].Rows[0]["memberId"].ToString() != "")
{
model.memberId = int.Parse(ds.Tables[0].Rows[0]["memberId"].ToString());
}
if (ds.Tables[0].Rows[0]["money"].ToString() != "")
{
model.money = decimal.Parse(ds.Tables[0].Rows[0]["money"].ToString());
}
model.moneyType = ds.Tables[0].Rows[0]["moneyType"].ToString();
model.remarks = ds.Tables[0].Rows[0]["remarks"].ToString();
model.addPerson = ds.Tables[0].Rows[0]["addPerson"].ToString();
if (ds.Tables[0].Rows[0]["addTime"].ToString() != "")
{
model.addTime = DateTime.Parse(ds.Tables[0].Rows[0]["addTime"].ToString());
}
if (ds.Tables[0].Rows[0]["shFlag"].ToString() != "")
{
model.shFlag = int.Parse(ds.Tables[0].Rows[0]["shFlag"].ToString());
}
model.shPerson = ds.Tables[0].Rows[0]["shPerson"].ToString();
if (ds.Tables[0].Rows[0]["shTime"].ToString() != "")
{
model.shTime = DateTime.Parse(ds.Tables[0].Rows[0]["shTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 使用消费券充值（1：充值成功，小于0充值失败）
/// </summary>
public int RegStamp(string stampNum, string userID)
{
//获取消费券信息
ModStamp modStamp = GetModel(stampNum);
if (modStamp != null)
{
if (modStamp.IsUsed == 1)
{
return(-3);
}
//记录到充值明细表
MemberCZRecordBLL bllMember = new MemberCZRecordBLL();
MemberCZRecordModel modMoney = new MemberCZRecordModel();
MemberCZRecordDAL dalMoney = new MemberCZRecordDAL();
modMoney.memberId = int.Parse(userID);
modMoney.addTime = DateTime.Now;
modMoney.addPerson = "平台会员";
modMoney.moneyType = "XFQ";
modMoney.shFlag = 1;//自动审核成功
modMoney.shTime = DateTime.Now;
modMoney.shPerson = "自动审核";
modMoney.remarks = ""; //使用消费券
modMoney.money = (int)(modStamp.StampMoney / 100);
string s = Convert.ToString(modStamp.StampMoney / 100);
if (bllMember.Add(modMoney) > 0)
{
//修改会员总金额
if (dalMoney.UpdateMemberCount("XFQ", s, userID) > 0)
{
UpdateToUse(stampNum); return(1);
}
else
{
return(-2);
}
}
else
{
return(-1);
}
}
else
{
return(-9999);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MemberCZRecordModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Member_AccountRecord(");
strSql.Append("memberId,money,moneyType,remarks,addTime,addPerson,shFlag)");
strSql.Append(" values (");
strSql.Append("@memberId,@money,@moneyType,@remarks,@addTime,@addPerson,@shFlag)");
SqlParameter[] parameters =
{
new SqlParameter("@memberId", SqlDbType.Int, 4),
new SqlParameter("@money", SqlDbType.Decimal, 9),
new SqlParameter("@moneyType", SqlDbType.VarChar, 50),
new SqlParameter("@remarks", SqlDbType.VarChar, 500),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@addPerson", SqlDbType.VarChar, 50),
new SqlParameter("@shFlag", SqlDbType.Int, 4)
};
parameters[0].Value = model.memberId;
parameters[1].Value = model.money;
parameters[2].Value = model.moneyType;
parameters[3].Value = model.remarks;
parameters[4].Value = model.addTime;
parameters[5].Value = model.addPerson;
parameters[6].Value = model.shFlag;
object obj = adoHelper.ExecuteSqlScalar(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(MemberCZRecordModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MemberCZRecordModel model)
{
return(dal.Add(model));
}
