/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref WX_setreservationEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@setreservationid", Entity.setreservationid),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@ttcode", Entity.ttcode),
new SqlParameter("@maxdeposit", Entity.maxdeposit),
new SqlParameter("@methoddeposit", Entity.methoddeposit),
new SqlParameter("@nolimitdate", Entity.nolimitdate),
new SqlParameter("@daydeposit", Entity.daydeposit),
new SqlParameter("@Duetype", Entity.Duetype),
new SqlParameter("@remark", Entity.remark),
new SqlParameter("@status", Entity.status),
new SqlParameter("@cuser", Entity.cuser),
new SqlParameter("@uuser", Entity.uuser),
new SqlParameter("@btime", Entity.btime),
new SqlParameter("@etime", Entity.etime),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_WX_setreservation_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.setreservationid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref ts_DictsEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@dicid", Entity.dicid),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@strcode", Entity.strcode),
new SqlParameter("@dictype", Entity.dictype),
new SqlParameter("@lng", Entity.lng),
new SqlParameter("@pdicid", Entity.pdicid),
new SqlParameter("@diccode", Entity.diccode),
new SqlParameter("@dicname", Entity.dicname),
new SqlParameter("@dicvalue", Entity.dicvalue),
new SqlParameter("@orderno", Entity.orderno),
new SqlParameter("@remark", Entity.remark),
new SqlParameter("@status", Entity.status),
new SqlParameter("@cuser", Entity.cuser),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_ts_Dicts_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.dicid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_BackReasonEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@UCode", Entity.UCode),
new SqlParameter("@UCname", Entity.UCname),
new SqlParameter("@TStatus", Entity.TStatus),
new SqlParameter("@Sort", Entity.Sort),
new SqlParameter("@PKCode", Entity.PKCode),
new SqlParameter("@Reason", Entity.Reason),
new SqlParameter("@Ascription", Entity.Ascription),
new SqlParameter("@Remark", Entity.Remark),
};
sqlParameters[8].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_BackReason_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.PKCode = sqlParameters[8].Value.ToString();
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref WX_settimeEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@timeid", Entity.timeid),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@timename", Entity.timename),
new SqlParameter("@timevalue", Entity.timevalue),
new SqlParameter("@remark", Entity.remark),
new SqlParameter("@status", Entity.status),
new SqlParameter("@cuser", Entity.cuser),
new SqlParameter("@uuser", Entity.uuser),
new SqlParameter("@btime", Entity.btime),
new SqlParameter("@etime", Entity.etime),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_WX_settime_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.timeid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref choorderEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@lsid", Entity.lsid),
new SqlParameter("@orderid", Entity.orderid),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@strcode", Entity.strcode),
new SqlParameter("@shiftid", Entity.shiftid),
new SqlParameter("@tmcode", Entity.tmcode),
new SqlParameter("@personnum", Entity.personnum),
new SqlParameter("@username", Entity.username),
new SqlParameter("@userphone", Entity.userphone),
new SqlParameter("@arrivetime", Entity.arrivetime),
new SqlParameter("@opentime", Entity.opentime),
new SqlParameter("@restime", Entity.restime),
new SqlParameter("@checkouttime", Entity.checkouttime),
new SqlParameter("@gusetleavetime", Entity.gusetleavetime),
new SqlParameter("@alltime", Entity.alltime),
new SqlParameter("@allfoodtime", Entity.allfoodtime),
new SqlParameter("@conmoney", Entity.conmoney),
new SqlParameter("@status", Entity.status),
new SqlParameter("@remark", Entity.remark),
new SqlParameter("@cuser", Entity.cuser),
new SqlParameter("@uuser", Entity.uuser),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_choorder_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.lsid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref WX_busWaitEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@bwid", Entity.bwid),
new SqlParameter("@serialNumber", Entity.serialNumber),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@strcode", Entity.strcode),
new SqlParameter("@busTop", Entity.busTop),
new SqlParameter("@sortNum", Entity.sortNum),
new SqlParameter("@busDate", Entity.busDate),
new SqlParameter("@waitType", Entity.waitType),
new SqlParameter("@userName", Entity.userName),
new SqlParameter("@tel", Entity.tel),
new SqlParameter("@waitTime", Entity.waitTime),
new SqlParameter("@remark", Entity.remark),
new SqlParameter("@status", Entity.status),
new SqlParameter("@cuser", Entity.cuser),
new SqlParameter("@uuser", Entity.uuser),
new SqlParameter("@openid", Entity.openid),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_WX_busWait_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.bwid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_BackOrderEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@AuthCode", Entity.AuthCode),
new SqlParameter("@AuthName", Entity.AuthName),
new SqlParameter("@TStatus", Entity.TStatus),
new SqlParameter("@OrderCode", Entity.OrderCode),
new SqlParameter("@OrderDisCode", Entity.OrderDisCode),
new SqlParameter("@ReasonCode", Entity.ReasonCode),
new SqlParameter("@ReasonName", Entity.ReasonName),
new SqlParameter("@Remar", Entity.Remar),
new SqlParameter("@BackNum", Entity.BackNum),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_BackOrder_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.Id = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref DisheTypeEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@lsid", Entity.lsid),
new SqlParameter("@distypeid", Entity.distypeid),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@pdistypecode", Entity.pdistypecode),
new SqlParameter("@distypecode", Entity.distypecode),
new SqlParameter("@dispath", Entity.dispath),
new SqlParameter("@distypename", Entity.distypename),
new SqlParameter("@metcode", Entity.metcode),
new SqlParameter("@fincode", Entity.fincode),
new SqlParameter("@maxdiscount", Entity.maxdiscount),
new SqlParameter("@busSort", Entity.busSort),
new SqlParameter("@status", Entity.status),
new SqlParameter("@cuser", Entity.cuser),
new SqlParameter("@uuser", Entity.uuser),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_DisheType_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.lsid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref WX_setlineUpEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@lineid", Entity.lineid),
new SqlParameter("@linecode", Entity.linecode),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@ttcode", Entity.ttcode),
new SqlParameter("@maxperson", Entity.maxperson),
new SqlParameter("@minperosn", Entity.minperosn),
new SqlParameter("@Turncycle", Entity.Turncycle),
new SqlParameter("@remark", Entity.remark),
new SqlParameter("@status", Entity.status),
new SqlParameter("@cuser", Entity.cuser),
new SqlParameter("@uuser", Entity.uuser),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_WX_setlineUp_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.lineid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_OrderEntity Entity, string DishListJson)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@PKCode", SqlDbType.VarChar, 32)
{
Value = Entity.PKCode
},
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@OrderMoney", Entity.OrderMoney),
new SqlParameter("@Remar", Entity.Remar),
new SqlParameter("@DisNum", Entity.DisNum),
new SqlParameter("@OrderType", Entity.OrderType),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_Order_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 1)
{
Entity.PKCode = sqlParameters[0].Value.ToString();
int disRel = -1;
try
{
//解析json拼接SQL
DataTable dtDish = JsonHelper.ToDataTable(DishListJson);
string dishSql = " declare @odiscode varchar(32);";
dishSql += " declare @podiscode varchar(32);";
dishSql += " set @podiscode='';";
string checkmoneySql = " declare @allmoney decimal(18,2);";
checkmoneySql += " set @allmoney=0; ";
if (dtDish != null && dtDish.Rows.Count > 0)
{
foreach (DataRow dr in dtDish.Rows)
{
string disPrice = dr["price"].ToString();
string totalmoney = "0";
totalmoney = disPrice + "*" + dr["disnum"].ToString() + "+" + dr["cookmoney"].ToString();
string tempSql = " exec[dbo].[p_GetOrderCode] @odiscode output;";
tempSql += " insert into TB_OrderDish([StoCode],[OrderCode],[DisCode],[DisName],[Price],[DisNum],[PKCode],[CookName],[CookMoney],[TotalMoney]) ";
tempSql += " values('" + Entity.StoCode + "','" + Entity.PKCode + "','" + dr["discode"] + "','" + dr["disname"] + "'," + dr["price"] + "," + dr["disnum"] + ",@odiscode,'" + dr["cookname"] + "'," + dr["cookmoney"] + "," + totalmoney + ");";
dishSql += tempSql;
}
disRel = DBHelper.ExecuteNonQuery(dishSql, CommandType.Text, new SqlParameter[] { });
}
}
catch (Exception ex) {}
if (disRel != 0)
{
//删除订单信息，返回失败
string meg = "";
Delete(Entity.PKCode, Entity.StoCode, ref meg);
intReturn = -1;
}
}
return(intReturn);
}
/// <summary>
/// 更新状态
/// </summary>
/// <param name="PKCode">标识</param>
/// <param name="Status">状态</param>
/// <returns></returns>
public int UpdateStatus(string ids, string Status)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@ids", ids),
new SqlParameter("@status", Status)
};
return(DBHelper.ExecuteNonQuery("dbo.p_TB_DiscountScheme_UpdateStatus", CommandType.StoredProcedure, sqlParameters));
}
//解绑会员卡
public void CancelMemCard(string openid, string cardcode, ref string mescode)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@openid", openid),
new SqlParameter("@cardcode", cardcode),
new SqlParameter("@mescode", SqlDbType.VarChar,64, mescode)
};
sqlParameters[2].Direction = ParameterDirection.Output;
DBHelper.ExecuteNonQuery("p_CancelMemCard", CommandType.StoredProcedure, sqlParameters);
mescode = sqlParameters[2].Value.ToString();
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_BillEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@PKCode", SqlDbType.NVarChar, 32)
{
Value = Entity.PKCode
},
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@OrderCodeList", Entity.OrderCodeList),
new SqlParameter("@Remar", Entity.Remar),
new SqlParameter("@BillType", Entity.BillType),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_Bill_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.PKCode = sqlParameters[0].Value.ToString();
}
return(intReturn);
}
//优惠券发放
//优惠券活动code ,会员code,发放门店code
public int ReceiveCoupon(string mccode, string memcode, string ffstocode, ref string mescode)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@mccode", mccode),
new SqlParameter("@memcode", memcode),
new SqlParameter("@ffstocode", ffstocode),
new SqlParameter("@mescode", SqlDbType.VarChar,64, mescode)
};
sqlParameters[3].Direction = ParameterDirection.Output;
int count = DBHelper.ExecuteNonQuery("p_ReceiveCoupon", CommandType.StoredProcedure, sqlParameters);
mescode = sqlParameters[3].Value.ToString();
return(count);
}
/// <summary>
/// 增加一条数据
/// </summary>
//public int Add(ref StoreEntity Entity, string storetype, string jprice, string paytype, string sqcode, string jcaddress, string isjc, string jctype, string xftime, string sumcode, string mccode, string idtype)
public int Add(ref StoreEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@stoid", Entity.stoid),
new SqlParameter("@comcode", Entity.comcode),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@cname", Entity.cname),
new SqlParameter("@sname", Entity.sname),
new SqlParameter("@bcode", Entity.bcode),
new SqlParameter("@indcode", Entity.indcode),
new SqlParameter("@provinceid", Entity.provinceid),
new SqlParameter("@cityid", Entity.cityid),
new SqlParameter("@areaid", Entity.areaid),
new SqlParameter("@address", Entity.address),
new SqlParameter("@stoprincipal", Entity.stoprincipal),
new SqlParameter("@stoprincipaltel", Entity.stoprincipaltel),
new SqlParameter("@tel", Entity.tel),
new SqlParameter("@stoemail", Entity.stoemail),
new SqlParameter("@logo", Entity.logo),
new SqlParameter("@backgroundimg", Entity.backgroundimg),
new SqlParameter("@stopath", Entity.stopath),
new SqlParameter("@services", Entity.services),
new SqlParameter("@descr", Entity.descr),
new SqlParameter("@stourl", Entity.stourl),
new SqlParameter("@stocoordx", Entity.stocoordx),
new SqlParameter("@stocoordy", Entity.stocoordy),
new SqlParameter("@recommended", Entity.recommended),
new SqlParameter("@remark", Entity.remark),
new SqlParameter("@status", Entity.status),
new SqlParameter("@btime", Entity.btime),
new SqlParameter("@etime", Entity.etime),
new SqlParameter("@jprice", Entity.jprice),
new SqlParameter("@sqcode", Entity.sqcode)
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_Store_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 1)
{
Entity.stoid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 取消账单
/// </summary>
/// <param name="stocde"></param>
/// <param name="billcode"></param>
/// <returns></returns>
public int CancelBill(string stocde, string billcode)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@stocode", stocde),
new SqlParameter("@billcode", billcode)
};
return(DBHelper.ExecuteNonQuery("p_App_TB_Bill_Cancel", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 打赏
/// </summary>
/// <param name="openid"></param>
/// <param name="empcode"></param>
/// <param name="money"></param>
/// <param name="point"></param>
/// <param name="rcontent"></param>
/// <param name="rid"></param>
public void AddWXReward(string openid, string empcode, string money, string point, string rcontent, ref string rid, ref string orderno)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@openid", openid),
new SqlParameter("@empcode", empcode),
new SqlParameter("@money", money),
new SqlParameter("@point", point),
new SqlParameter("@rcontent", rcontent),
new SqlParameter("@rid", SqlDbType.VarChar, 64, rid),
new SqlParameter("@orderno", SqlDbType.VarChar, 64, orderno)
};
sqlParameters[5].Direction = ParameterDirection.Output;
sqlParameters[6].Direction = ParameterDirection.Output;
DBHelper.ExecuteNonQuery("dbo.p_addwxreward", CommandType.StoredProcedure, sqlParameters);
rid = sqlParameters[5].Value.ToString();
orderno = sqlParameters[6].Value.ToString();
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_DishTypeEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@PKKCode", Entity.PKKCode),
new SqlParameter("@PKCode", SqlDbType.NVarChar,32),
new SqlParameter("@TypeName", Entity.TypeName),
new SqlParameter("@Sort", Entity.Sort),
new SqlParameter("@TStatus", Entity.TStatus)
};
sqlParameters[1].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_DishType_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.PKCode = sqlParameters[1].Value.ToString();
}
return(intReturn);
}
/// <summary>
/// 添加投诉
/// </summary>
/// <param name="openid"></param>
/// <param name="stoname"></param>
/// <param name="content"></param>
/// <returns></returns>
public int AddComplaints(string openid, string stoname, string content)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@openid", openid),
new SqlParameter("@stoname", stoname),
new SqlParameter("@content", content)
};
return(DBHelper.ExecuteNonQuery("dbo.p_AddComplaints", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref WX_usermessageEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@id", Entity.id),
new SqlParameter("@openid", Entity.openid),
new SqlParameter("@msgtype", Entity.msgtype),
new SqlParameter("@status", Entity.status),
new SqlParameter("@msgdetails", Entity.msgdetails),
new SqlParameter("@title", Entity.title),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_WX_usermessage_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.id = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref WX_stosetEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@setreservationid", Entity.setreservationid),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@isnetwork", Entity.isnetwork),
new SqlParameter("@isqueue", Entity.isqueue),
new SqlParameter("@isaddfood", Entity.isaddfood),
new SqlParameter("@ntime", Entity.ntime),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_WX_stoset_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.setreservationid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_RoleFunctionEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@RoleId", Entity.RoleId),
new SqlParameter("@FunctionId", Entity.FunctionId),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_RoleFunction_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.Id = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 添加角色权限信息
/// </summary>
/// <param name="Entity">角色实体</param>
/// <param name="FunList">功能数组</param>
/// <returns></returns>
public int AddRITMAS(rolesEntity Entity, string[] FunList)
{
StringBuilder Builder = new StringBuilder();
Builder.Append(" BEGIN TRAN tan1");
Builder.Append(" declare @rolid int");
int rel = CheckRoleName(Entity.roleid.ToString(), Entity.cname, Entity.buscode);
if (rel <= 0)
{
if (Entity.roleid == 0)
{
Builder.AppendFormat(" INSERT INTO dbo.roles(scope,stocode,cname,[status],descr,cuser,ctime,buscode)VALUES({0},'{1}','{2}','{3}','{4}','{5}',getdate(),'{6}');", Entity.scope, Entity.stocode, Entity.cname, Entity.status, Entity.descr, Entity.cuser, Entity.buscode);
Builder.Append(" set @rolid=SCOPE_IDENTITY();");
}
else
{
Builder.Append(" UPDATE roles SET scope=" + Entity.scope + ",utime=getdate(),uuser="******" ,stocode='" + Entity.stocode + "'");
if (Entity.cname.Length > 0)
{
Builder.Append(" ,cname='" + Entity.cname + "'");
}
if (Entity.status.Length > 0)
{
Builder.Append(" ,[status]='" + Entity.status + "'");
}
if (Entity.descr.Length > 0)
{
Builder.Append(" ,descr='" + Entity.descr + "'");
}
Builder.AppendFormat(" WHERE roleid={0};", Entity.roleid);
Builder.Append(" set @rolid=" + Entity.roleid + ";");
}
Builder.AppendFormat(" DELETE FROM rolefunction WHERE roleid={0}", Entity.roleid);
try
{
if (FunList != null && FunList.Length > 0)
{
foreach (string item in FunList)
{
if (!string.IsNullOrEmpty(item))
{
Builder.Append(" INSERT INTO rolefunction(roleid,funid)");
Builder.AppendFormat(" VALUES(@rolid,{0});", item);
}
}
}
}
catch
{ }
Builder.Append(" if(@@error=0) begin commit tran tan1 end else begin rollback tran tran1 end");
return(DBHelper.ExecuteNonQuery(Builder.ToString()));
}
else
{
return(3);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref WX_busDestineEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@ID", Entity.ID),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@desDate", Entity.desDate),
new SqlParameter("@desTime", Entity.desTime),
new SqlParameter("@dicid", Entity.dicid),
new SqlParameter("@personNum", Entity.personNum),
new SqlParameter("@metcode", Entity.metcode),
new SqlParameter("@userName", Entity.userName),
new SqlParameter("@tel", Entity.tel),
new SqlParameter("@remark", Entity.remark),
new SqlParameter("@status", Entity.status),
new SqlParameter("@dishesremark", Entity.dishesremark),
new SqlParameter("@TerminalType", Entity.TerminalType),
new SqlParameter("@openid", Entity.openid),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_WX_busDestine_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.ID = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref sumcouponNEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@sumid", Entity.sumid),
new SqlParameter("@sumcode", Entity.sumcode),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@cname", Entity.cname),
new SqlParameter("@ctype", Entity.ctype),
new SqlParameter("@status", Entity.status),
new SqlParameter("@descr", Entity.descr),
new SqlParameter("@audcode", Entity.audcode),
new SqlParameter("@audcname", Entity.audcname),
new SqlParameter("@audremark", Entity.audremark),
new SqlParameter("@audstatus", Entity.audstatus),
new SqlParameter("@ccode", Entity.ccode),
new SqlParameter("@ccname", Entity.ccname)
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_sumcouponN_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.sumid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_ShoppingCartEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@TStatus", Entity.TStatus),
new SqlParameter("@PKCode", Entity.PKCode),
new SqlParameter("@AutoDelTime", Entity.AutoDelTime),
new SqlParameter("@IsAutoDelete", Entity.IsAutoDelete),
new SqlParameter("@MaxNum", Entity.MaxNum),
};
sqlParameters[4].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_ShoppingCart_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.PKCode = sqlParameters[4].Value.ToString();
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref ActivityAdEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@Title", Entity.Title),
new SqlParameter("@status", Entity.status),
new SqlParameter("@Sort", Entity.Sort),
new SqlParameter("@Description", Entity.Description),
new SqlParameter("@Type", Entity.Type),
new SqlParameter("@images", Entity.images),
new SqlParameter("@Url", Entity.Url),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_ActivityAd_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.Id = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref membersEntity Entity, ref string MesCode)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@memid", Entity.memid),
new SqlParameter("@memcode", SqlDbType.VarChar, 32),
new SqlParameter("@wxaccount", Entity.wxaccount),
new SqlParameter("@mobile", Entity.mobile)
};
sqlParameters[0].Direction = ParameterDirection.Output;
sqlParameters[1].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_members_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.memid = sqlParameters[0].Value.ToString();
Entity.memcode = sqlParameters[1].Value.ToString();
}
return(intReturn);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_OrderDishEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@OrderCode", Entity.OrderCode),
new SqlParameter("@DisCode", Entity.DisCode),
new SqlParameter("@DisName", Entity.DisName),
new SqlParameter("@Price", Entity.Price),
new SqlParameter("@DisUite", Entity.DisUite),
new SqlParameter("@DisNum", Entity.DisNum),
new SqlParameter("@PKCode", Entity.PKCode),
new SqlParameter("@TotalMoney", Entity.TotalMoney),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_OrderDish_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.Id = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(TB_BillCouponEntity Entity)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@TStatus", Entity.TStatus),
new SqlParameter("@BillCode", Entity.BillCode),
new SqlParameter("@CouponCode", Entity.CouponCode),
new SqlParameter("@CouponMoney", Entity.CouponMoney),
new SqlParameter("@MemberCardCode", Entity.MemberCardCode),
new SqlParameter("@RealPay", Entity.RealPay),
new SqlParameter("@VIMoney", Entity.VIMoney),
new SqlParameter("@Remark", Entity.Remark),
new SqlParameter("@UseType", Entity.UseType),
new SqlParameter("@ShiftCode", Entity.ShiftCode),
new SqlParameter("@CouponName", Entity.CouponName),
new SqlParameter("@McCode", Entity.McCode),
};
return(DBHelper.ExecuteNonQuery("dbo.p_TB_BillCoupon_Update", CommandType.StoredProcedure, sqlParameters));
}
private void UpdateLog(string outputMsg, int logID, int flag)
{
MSSqlDataAccess mss = new MSSqlDataAccess("GTEvent");
mss.CommandType = CommandType.Text;
DataTable dt = new DataTable();
string strSQL = "UPDATE dbo.BuyPoint_Log WITH(XLOCK) SET [Flag] = @Flag,[Memo] = @Memo WHERE Seq = @ID;";
SqlParameter[] sp = new SqlParameter[]
{
IDataAccess.New<SqlParameter>("@Flag" , flag , ParameterDirection.Input, DbType.Int16),
IDataAccess.New<SqlParameter>("@Memo" , outputMsg, ParameterDirection.Input, DbType.String,500),
IDataAccess.New<SqlParameter>("@ID" , logID, ParameterDirection.Input, DbType.Int32)
};
mss.ExecuteNonQuery(strSQL, sp);
if (mss.HasException)
{
Gamania.SD.IRS.ErrorLog.InsErrLog(215, "reconfirm.aspx", "UpdateLog", "UpdateLog", "UpdateLog Fail," + mss.ExceptionText);
AlertThenClose("Sorry! System is busy now, please try again！(8)", true);
}
}
