/// <summary>
/// 更新一条数据
/// </summary>
public int Update(ModStamp model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update N_Stamp set ");
strSql.Append("StampNo=@StampNo,");
strSql.Append("Password=@Password,");
strSql.Append("IsUsed=@IsUsed,");
strSql.Append("StampMoney=@StampMoney,");
strSql.Append("StampOutTime=@StampOutTime,");
strSql.Append("StampType=@StampType,");
strSql.Append("AddTime=@AddTime");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@StampNo", SqlDbType.VarChar, 50),
new SqlParameter("@Password", SqlDbType.VarChar, 50),
new SqlParameter("@IsUsed", SqlDbType.Int, 4),
new SqlParameter("@StampMoney", SqlDbType.Int, 4),
new SqlParameter("@StampOutTime", SqlDbType.DateTime),
new SqlParameter("@StampType", SqlDbType.Int, 4),
new SqlParameter("@AddTime", SqlDbType.DateTime)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.StampNo;
parameters[2].Value = model.Password;
parameters[3].Value = model.IsUsed;
parameters[4].Value = model.StampMoney;
parameters[5].Value = model.StampOutTime;
parameters[6].Value = model.StampType;
parameters[7].Value = model.AddTime;
return(adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ModStamp model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into N_Stamp(");
strSql.Append("StampNo,Password,IsUsed,StampMoney,StampOutTime,StampType,AddTime)");
strSql.Append(" values (");
strSql.Append("@StampNo,@Password,@IsUsed,@StampMoney,@StampOutTime,@StampType,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@StampNo", SqlDbType.VarChar, 50),
new SqlParameter("@Password", SqlDbType.VarChar, 50),
new SqlParameter("@IsUsed", SqlDbType.Int, 4),
new SqlParameter("@StampMoney", SqlDbType.Int, 4),
new SqlParameter("@StampOutTime", SqlDbType.DateTime),
new SqlParameter("@StampType", SqlDbType.Int, 4),
new SqlParameter("@AddTime", SqlDbType.DateTime)
};
parameters[0].Value = model.StampNo;
parameters[1].Value = model.Password;
parameters[2].Value = model.IsUsed;
parameters[3].Value = model.StampMoney;
parameters[4].Value = model.StampOutTime;
parameters[5].Value = model.StampType;
parameters[6].Value = model.AddTime;
return(adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ModStamp GetModel(string StampNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,StampNo,Password,IsUsed,StampMoney,StampOutTime,StampType,AddTime from N_Stamp ");
strSql.Append(" where StampNo=@StampNo ");
SqlParameter[] parameters =
{
new SqlParameter("@StampNo", SqlDbType.VarChar, 50)
};
parameters[0].Value = StampNo;
ModStamp model = new ModStamp();
DataSet ds = adoHelper.ExecuteSqlDataset(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.StampNo = ds.Tables[0].Rows[0]["StampNo"].ToString();
model.Password = ds.Tables[0].Rows[0]["Password"].ToString();
if (ds.Tables[0].Rows[0]["IsUsed"].ToString() != "")
{
model.IsUsed = int.Parse(ds.Tables[0].Rows[0]["IsUsed"].ToString());
}
if (ds.Tables[0].Rows[0]["StampMoney"].ToString() != "")
{
model.StampMoney = int.Parse(ds.Tables[0].Rows[0]["StampMoney"].ToString());
}
if (ds.Tables[0].Rows[0]["StampOutTime"].ToString() != "")
{
model.StampOutTime = DateTime.Parse(ds.Tables[0].Rows[0]["StampOutTime"].ToString());
}
if (ds.Tables[0].Rows[0]["StampType"].ToString() != "")
{
model.StampType = int.Parse(ds.Tables[0].Rows[0]["StampType"].ToString());
}
if (ds.Tables[0].Rows[0]["AddTime"].ToString() != "")
{
model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].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 Update(ModStamp model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ModStamp model)
{
return(dal.Add(model));
}