///<summary>
///修改方法，返回Boolean类型，为true表示操作成功，否则操作失败
///生成时间：2011-1-21 20:14:08
///</summary>
public Boolean UpdateOrderdetail1x2hfl(Orderdetail1x2hfl orderdetail1x2hfl)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?UserName", orderdetail1x2hfl.UserName),
new MySqlParameter("?OrderID", orderdetail1x2hfl.OrderID),
new MySqlParameter("?time", orderdetail1x2hfl.Time),
new MySqlParameter("?leaguecn", orderdetail1x2hfl.Leaguecn),
new MySqlParameter("?leaguetw", orderdetail1x2hfl.Leaguetw),
new MySqlParameter("?leagueen", orderdetail1x2hfl.Leagueen),
new MySqlParameter("?leagueth", orderdetail1x2hfl.Leagueth),
new MySqlParameter("?leaguevn", orderdetail1x2hfl.Leaguevn),
new MySqlParameter("?Homecn", orderdetail1x2hfl.Homecn),
new MySqlParameter("?Hometw", orderdetail1x2hfl.Hometw),
new MySqlParameter("?Homeen", orderdetail1x2hfl.Homeen),
new MySqlParameter("?Hometh", orderdetail1x2hfl.Hometh),
new MySqlParameter("?Homevn", orderdetail1x2hfl.Homevn),
new MySqlParameter("?Awaycn", orderdetail1x2hfl.Awaycn),
new MySqlParameter("?Awaytw", orderdetail1x2hfl.Awaytw),
new MySqlParameter("?Awayen", orderdetail1x2hfl.Awayen),
new MySqlParameter("?Awayth", orderdetail1x2hfl.Awayth),
new MySqlParameter("?Awayvn", orderdetail1x2hfl.Awayvn),
new MySqlParameter("?BeginTime", orderdetail1x2hfl.BeginTime),
new MySqlParameter("?BetType", orderdetail1x2hfl.BetType),
new MySqlParameter("?IsHalf", orderdetail1x2hfl.IsHalf),
new MySqlParameter("?BetItem", orderdetail1x2hfl.BetItem),
new MySqlParameter("?Score", orderdetail1x2hfl.Score),
new MySqlParameter("?Handicap", orderdetail1x2hfl.Handicap),
new MySqlParameter("?Odds", orderdetail1x2hfl.Odds),
new MySqlParameter("?OddsType", orderdetail1x2hfl.OddsType),
new MySqlParameter("?Amount", orderdetail1x2hfl.Amount),
new MySqlParameter("?ValidAmount", orderdetail1x2hfl.ValidAmount),
new MySqlParameter("?Status", orderdetail1x2hfl.Status),
new MySqlParameter("?Agent", orderdetail1x2hfl.Agent),
new MySqlParameter("?AgentPercent", orderdetail1x2hfl.AgentPercent),
new MySqlParameter("?AgentCommission", orderdetail1x2hfl.AgentCommission),
new MySqlParameter("?ZAgentPercent", orderdetail1x2hfl.ZAgentPercent),
new MySqlParameter("?ZAgent", orderdetail1x2hfl.ZAgent),
new MySqlParameter("?ZAgentCommission", orderdetail1x2hfl.ZAgentCommission),
new MySqlParameter("?PartnerPercent", orderdetail1x2hfl.PartnerPercent),
new MySqlParameter("?PartnerCommission", orderdetail1x2hfl.PartnerCommission),
new MySqlParameter("?Partner", orderdetail1x2hfl.Partner),
new MySqlParameter("?CompanyPercent", orderdetail1x2hfl.CompanyPercent),
new MySqlParameter("?CompanyCommission", orderdetail1x2hfl.CompanyCommission),
new MySqlParameter("?IP", orderdetail1x2hfl.IP),
new MySqlParameter("?SubCompany", orderdetail1x2hfl.SubCompany),
new MySqlParameter("?SubCompanyCommission", orderdetail1x2hfl.SubCompanyCommission),
new MySqlParameter("?SubCompanyPercent", orderdetail1x2hfl.SubCompanyPercent),
new MySqlParameter("?WebSiteiID", orderdetail1x2hfl.WebSiteiID),
new MySqlParameter("?UserLevel", orderdetail1x2hfl.UserLevel),
new MySqlParameter("?Coefficient", orderdetail1x2hfl.Coefficient),
new MySqlParameter("?Proportion", orderdetail1x2hfl.Proportion),
new MySqlParameter("?Currency", orderdetail1x2hfl.Currency),
new MySqlParameter("?Reason", orderdetail1x2hfl.Reason),
new MySqlParameter("?gameid", orderdetail1x2hfl.Gameid),
new MySqlParameter("?betflag", orderdetail1x2hfl.Betflag),
new MySqlParameter("?MemberPercent", orderdetail1x2hfl.MemberPercent),
new MySqlParameter("?MemberCommission", orderdetail1x2hfl.MemberCommission),
new MySqlParameter("?ID", orderdetail1x2hfl.ID)
};
return(MySqlHelper.ExecuteNonQuery(SQL_UPDATE, param) > 0);
}
public bool DeleBetlog()
{
string sql = "delete from betlog";
return(MySqlHelper.ExecuteNonQuery(sql) > 0);
}
/// <summary>
/// Programmer:liuxubang
/// time:7-16 15:05
/// </summary>
/// <param name="sysModule"></param>
/// <returns></returns>
public System_module AddModule(System_module sysModule, String operate)
{
Boolean con = false;
String lastModule = GetLastModule(sysModule.Module_parent_code);
String codeModule = String.Empty; //产生一个新的Module_code
if (lastModule != "" && lastModule != null) //表示有父模块
{
Int32 codeNum = Convert.ToInt32(lastModule.Remove(0, 1)) + 1;
if (sysModule.Module_parent_code == "ROOT_MENU") //添加一个大的模块
{
if (codeNum.ToString().Length == 1)
{
codeModule = "L0" + codeNum;
}
else
{
codeModule = "L" + codeNum;
}
}
else //添加一个子模块
{
codeModule = sysModule.Module_parent_code + codeNum.ToString().Substring(codeNum.ToString().Length - 2);
}
}
else
{
if (sysModule.Module_parent_code == "ROOT_MENU") //添加一个大的模块
{
codeModule = "L01";
}
else //添加一个子模块
{
codeModule = sysModule.Module_parent_code + "01";
}
}
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?ModuleCode", codeModule),
new MySqlParameter("?ModuleParentCode", sysModule.Module_parent_code),
new MySqlParameter("?ModuleType", sysModule.Module_type),
new MySqlParameter("?ModuleText", sysModule.Module_text),
new MySqlParameter("?ModuleUrl", sysModule.Module_url),
new MySqlParameter("?ModuleTarget", sysModule.Module_target),
new MySqlParameter("?ModuleTip", sysModule.Module_tip),
new MySqlParameter("?status", sysModule.Status)
};
con = MySqlHelper.ExecuteNonQuery(INSERT_MODULE, param) > 0;
if (con)
{
if (operate != "" && sysModule.Module_parent_code != "ROOT_MENU")
{
String[] OperateArr = operate.Split(',');
for (int i = 0; i < OperateArr.Length; i++)
{
new System_module_rightService().AddModuleRight(codeModule, int.Parse(OperateArr[i]), sysModule.Module_url);
}
}
else
{
new System_module_rightService().AddModuleRight(codeModule, 0, "");
}
sysModule.Module_code = codeModule;
return(sysModule);
}
else
{
return(null);
}
}
