//获取预约今天 明天 后台预约详细信息及备注信息
public DataSet GetReserveTimes(string stocode)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@stocode", stocode)
};
return(DBHelper.ExecuteDataSet("p_GetReserveTimes", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 获取账单详情
/// </summary>
/// <param name="BillCode">账单编号</param>
/// <param name="StoCode">门店编号</param>
/// <param name="UserCode">用户编号</param>
/// <returns></returns>
public DataSet GetDetail(string BillCode, string StoCode, string UserCode)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@BillCode", BillCode),
new SqlParameter("@StoCode", StoCode),
new SqlParameter("@UserCode", UserCode)
};
return(DBHelper.ExecuteDataSet("dbo.p_TB_Bill_Detail", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_DiscountSchemeEntity Entity)
{
DataSet dtStructure = DBHelper.ExecuteDataSet("select top 0 * from TB_DiscountScheme");
StringBuilder sql = new StringBuilder();
sql.Append(" declare @returnval int;");
sql.Append(" set @returnval=0;");
sql.Append("declare @PKCode varchar(32)");
sql.Append("exec [dbo].[p_GetbaseCode] @PKCode output");
sql.Append(" if exists(select 1 from TB_DiscountScheme where BusCode='" + Entity.BusCode + "' and StoCode='" + Entity.StoCode + "' and SchName='" + Entity.SchName + "') begin set @returnval=1; end ");
if (!string.IsNullOrEmpty(Entity.InsideCode))
{
sql.Append(" else if exists(select 1 from TB_DiscountScheme where BusCode='" + Entity.BusCode + "' and StoCode='" + Entity.StoCode + "' and InsideCode='" + Entity.InsideCode + "') begin set @returnval=1; end ");
}
sql.Append(" else begin BEGIN TRAN tan1");
Entity.CTime = System.DateTime.Now;
Entity.UTime = System.DateTime.Now;
List <string> lstExcludeFilds = new List <string>();
Dictionary <string, string> dicAttachFilds = new Dictionary <string, string>();
lstExcludeFilds.Clear();
lstExcludeFilds.Add("Id");
lstExcludeFilds.Add("PKCode");
lstExcludeFilds.Add("CTime");
lstExcludeFilds.Add("UTime");
dicAttachFilds.Clear();
dicAttachFilds.Add("PKCode", "@PKCode");
dicAttachFilds.Add("CTime", "getdate()");
dicAttachFilds.Add("UTime", "getdate()");
string InsertSql = EntityHelper.GenerateSqlByDE <TB_DiscountSchemeEntity>(dtStructure.Tables[0], Entity, lstExcludeFilds, dicAttachFilds, EntityHelper.eSqlType.insert);
sql.AppendFormat(" INSERT INTO TB_DiscountScheme " + InsertSql + " ;");
sql.AppendLine(" exec dbo.p_uploaddata_isSync '" + Entity.BusCode + "','" + Entity.StoCode + "','TB_DiscountScheme','PKCode',@PKCode,'add'");
#region 特殊折扣、
foreach (TR_DiscountSchemeRateEntity rate in Entity.DSRateList)
{
sql.Append("insert into [dbo].[TR_DiscountSchemeRate]([BusCode],[StoCode],[CCode],[CCname],[CTime],[TStatus],[Sort],[SchCode],[DiscountType],[DisTypeCode],[DisCode],[DisMetCode],[DiscountRate]) values('" + Entity.BusCode + "','" + Entity.StoCode + "','" + Entity.CCode
+ "','" + Entity.CCname + "','" + Entity.CTime + "','" + rate.TStatus + "','" + rate.Sort + "',@PKCode,'" + rate.DiscountType + "','" + rate.DisTypeCode + "','" + rate.DisCode + "','" + rate.DiscountRate + "');");
}
sql.AppendLine(" if(@@error=0) begin set @returnval=0; commit tran tan1; end else begin rollback tran tran1;set @returnval=1; end");
sql.AppendLine(" end");
sql.AppendLine(" select @returnval;");
DataTable dt = DBHelper.ExecuteDataTable(sql.ToString());
if (dt != null && dt.Rows.Count > 0)
{
return(StringHelper.StringToInt(dt.Rows[0][0].ToString()));
}
else
{
return(2);
}
#endregion
}
/// <summary>
/// 获取门店，菜品信息
/// </summary>
/// <param name="stocode"></param>
/// <param name="tablecode"></param>
/// <param name="menucode"></param>
/// <returns></returns>
public DataSet GetStoreDishInfo(string stocode, string tablecode, string menucode)
{
DataSet dsReturn = new DataSet();
SqlParameter[] sqlParameters =
{
new SqlParameter("@TableCode", tablecode),
new SqlParameter("@StoCode", stocode),
new SqlParameter("@menucode", menucode)
};
dsReturn = DBHelper.ExecuteDataSet("p_App_GetStoreDish", CommandType.StoredProcedure, sqlParameters);
return(dsReturn);
}
/// <summary>
/// 更新状态
/// </summary>
/// <param name="Id">标识</param>
/// <param name="Status">状态</param>
/// <returns></returns>
public DataSet UpdateStatus(string StoCode, string BillCode, string id, string Status, string isget, string OrderDishId, decimal DiscountPrice)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@id", id),
new SqlParameter("@StoCode", StoCode),
new SqlParameter("@BillCode", BillCode),
new SqlParameter("@status", Status),
new SqlParameter("@isget", isget),
new SqlParameter("@OrderDishId", OrderDishId),
new SqlParameter("@DiscountPrice", DiscountPrice)
};
return(DBHelper.ExecuteDataSet("dbo.p_TB_BillCoupon_UpdateStatus", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 执行存储过程获取数据表
/// </summary>
/// <param name="ProcedureName"></param>
/// <param name="sqlParameters"></param>
/// <returns></returns>
public DataSet GetDatasetByProcedure(string ProcedureName, SqlParameter[] sqlParameters)
{
DataSet ds = new DataSet();
try
{
ds = Obj.ExecuteDataSet(ProcedureName, CommandType.StoredProcedure, sqlParameters);
return(ds);
}
catch (Exception ex)
{
ErrorLog.WriteErrorMessage(ex);
return(ds);
}
}
/// <summary>
/// 门店详情
/// </summary>
/// <param name="stocode"></param>
/// <param name="openid"></param>
/// <returns></returns>
public DataSet GetStoDetail(string stocode, string openid)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@stocode", stocode),
new SqlParameter("@openid", openid)
};
return(DBHelper.ExecuteDataSet("p_GetStoreDetail", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 获取会员卡等级信息,缓存用
/// </summary>
/// <param name="BusCode"></param>
/// <returns></returns>
public DataSet GetMemcardLevel(string BusCode)
{
string where = "";
if (!string.IsNullOrEmpty(BusCode))
{
where = " and buscode='" + BusCode + "'";
}
DataSet ds = new DataSet();
ds = DBHelper.ExecuteDataSet("SELECT * FROM dbo.memcardtype WHERE [status]='1'" + where + ";SELECT * FROM memcardlevel WHERE status='1' AND mctcode IN (SELECT mctcode FROM dbo.memcardtype WHERE [status]='1'" + where + ")" + where);
return(ds);
}
//获取用户会员卡折扣信息及优惠券信息
public DataSet GetCardAndCouponList(string openid, string stocode, string money, string discodes)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@openid", openid),
new SqlParameter("@stocode", stocode),
new SqlParameter("@money", money),
new SqlParameter("@discodes", discodes)
};
return(DBHelper.ExecuteDataSet("p_getcardandcouponlist", CommandType.StoredProcedure, sqlParameters));
}
