protected void Rp_AdminList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
//ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "",
// "<script>alert('" + (e.Item.FindControl("r_credit") as Literal).Text + "');func();</script>", false);
//var
// return;
if (e.CommandName == "buy")
{
try
{
//string msg;
int Multiple = Convert.ToInt32((e.Item.FindControl("Literal1") as Literal).Text);
// int Multiple=-1;
AutoBwsModel.Credit.package pkmodel=new AutoBwsModel.Credit.package ();
pkmodel.id=0;
pkmodel.create_date=DateTime.Now;
pkmodel.level=Convert.ToInt32((e.Item.FindControl("DropDownList1") as DropDownList).SelectedItem.Text);
pkmodel.levelForNextPeriod=Convert.ToInt32((e.Item.FindControl("DropDownList1") as DropDownList).SelectedItem.Text);
pkmodel.name="";
pkmodel.remark="";
pkmodel.type_id=Convert.ToInt32(e.CommandArgument.ToString());
pkmodel.user_id=CurrentUser.Id;
string msg = "";
cm.AddOrUpdatePackage(pkmodel,CurrentUser,out msg);
//cm.BuyPackage(CurrentUser.Id, Convert.ToInt32(e.CommandArgument.ToString()), Multiple, out msg)
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "",
"<script>alert('" + msg + "');func();</script>", false);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "",
"<script>alert('" + ex.Message + "');func();</script>", false);
}
}
}
public IList<AutoBwsModel.Credit.package> GetPackageUserAndCondition(int userid, string condition)
{
IList<AutoBwsModel.Credit.package> mList = new List<AutoBwsModel.Credit.package>();
DataSet ds = this.GetList(" user_id =" + userid.ToString() + condition);
foreach (DataRow r in ds.Tables[0].Rows)
{
var model = new AutoBwsModel.Credit.package();
setModel(r, ref model);
mList.Add(model);
}
return mList;
}
//public void UpdateState(int int id)
//{
// DBHelper.ExecuteNonQuery(con, CommandType.Text, "Update package set state=" + state + " where id=" + id);
//}
public IList<AutoBwsModel.Credit.package> GetPackageByUserid(int id)
{
IList<AutoBwsModel.Credit.package> mList = new List<AutoBwsModel.Credit.package>();
DataSet ds = GetList(" user_id =" + id);
foreach (DataRow r in ds.Tables[0].Rows)
{
var model = new AutoBwsModel.Credit.package();
setModel_Michael(r, ref model);
mList.Add(model);
}
return mList;
}
public IList<AutoBwsModel.Credit.package> GetPackageListByUserAndRole(string roleType, int user_id)
{
IList<AutoBwsModel.Credit.package> mList = new List<AutoBwsModel.Credit.package>();
DataSet ds = new DataSet();
switch (roleType)
{
case "S":
ds = GetDetailWithUserAndPackageALL();
break;
case "A":
ds = this.GetDetailWithUserAndPackage(user_id);
break;
case "SU":
ds = GetDetailWithUserAndPackageForUser(user_id);
break;
case "P":
ds = GetDetailWithUserAndPackageForUser(user_id);
break;
}
//DataSet ds = this.GetList(" user_id =" + userid.ToString() + condition);
foreach (DataRow r in ds.Tables[0].Rows)
{
var model = new AutoBwsModel.Credit.package();
setModel(r, ref model);
mList.Add(model);
}
return mList;
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public AutoBwsModel.Credit.package GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("selec * from package ");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters = {
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
AutoBwsModel.Credit.package model = new AutoBwsModel.Credit.package();
DataSet ds = DBHelper.ExecuteDataset(con, CommandType.Text, 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.name = ds.Tables[0].Rows[0]["name"].ToString();
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
if (ds.Tables[0].Rows[0]["create_date"].ToString() != "")
{
model.create_date = DateTime.Parse(ds.Tables[0].Rows[0]["create_date"].ToString());
}
//if (ds.Tables[0].Rows[0]["expired_date"].ToString() != "")
//{
// model.expired_date = DateTime.Parse(ds.Tables[0].Rows[0]["expired_date"].ToString());
//}
//if (ds.Tables[0].Rows[0]["start_date"].ToString() != "")
//{
// model.start_date = DateTime.Parse(ds.Tables[0].Rows[0]["start_date"].ToString());
//}
//if(ds.Tables[0].Rows[0]["credit_count"].ToString()!="")
//{
// model.credit_count=int.Parse(ds.Tables[0].Rows[0]["credit_count"].ToString());
//}
if (ds.Tables[0].Rows[0]["user_id"].ToString() != "")
{
model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString());
}
//if (ds.Tables[0].Rows[0]["state"].ToString() != "")
//{
// model.state = int.Parse(ds.Tables[0].Rows[0]["state"].ToString());
//}
if (ds.Tables[0].Rows[0]["type_id"].ToString() != "")
{
model.type_id = int.Parse(ds.Tables[0].Rows[0]["type_id"].ToString());
}
if (ds.Tables[0].Rows[0]["level"].ToString() != "")
{
model.type_id = int.Parse(ds.Tables[0].Rows[0]["level"].ToString());
}
return model;
}
else
{
return null;
}
}
