public void Gift(string kh, int id, string AdminHotelid)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from hy_hyzlxxb where CarId IS NOT NULL ");
string khs = kh;
khs = "'" + khs.Replace("，", ",").TrimEnd(',').Replace(",", "','") + "'";
sql.AppendFormat(" and kh in ({0}) or sjhm in ({0}) ", khs);
DataTable dt = DataFactory.SqlDataBase(AdminHotelid).GetDataTableBySQL(sql);
if (dt.Rows.Count > 0)
{
string sqlcp = string.Format(@"select * from V_XXZSYHQ where CID=@CID and AdminHotelid=@AdminHotelid ");
SqlParam[] parmAdd3 = new SqlParam[] {
new SqlParam("@CID", id),
new SqlParam("@AdminHotelid", AdminHotelid)
};
DataTable dts = DataFactory.SqlDataBase().GetDataTableBySQL(new StringBuilder(sqlcp), parmAdd3);
for (int i = 0; i < dt.Rows.Count; i++)
{
//赠送优惠券
if (dts != null && dts.Rows.Count > 0)
{
CommonMethod.AddCardCoupons(dt.Rows[i]["lsh"].ToString(), AdminHotelid, "指定赠送", dts, "10");
}
}
}
}