/// <summary>
/// 增加一条数据
/// </summary>
public static bool Add(Model.H_Service model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into H_Service(");
strSql.Append("username,name,telephone,TeamViewerID,zhifubao,bank,bankname,banknumber)");
strSql.Append(" values (");
strSql.Append("@username,@name,@telephone,@TeamViewerID,@zhifubao,@bank,@bankname,@banknumber)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@username", SqlDbType.NVarChar, 50),
new SqlParameter("@name", SqlDbType.NVarChar, 50),
new SqlParameter("@telephone", SqlDbType.NVarChar, 50),
new SqlParameter("@TeamViewerID", SqlDbType.NVarChar, 50),
new SqlParameter("@zhifubao", SqlDbType.NVarChar, 50),
new SqlParameter("@bank", SqlDbType.NVarChar, 50),
new SqlParameter("@bankname", SqlDbType.NVarChar, 50),
new SqlParameter("@banknumber", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.username;
parameters[1].Value = model.name;
parameters[2].Value = model.telephone;
parameters[3].Value = model.TeamViewerID;
parameters[4].Value = model.zhifubao;
parameters[5].Value = model.bank;
parameters[6].Value = model.bankname;
parameters[7].Value = model.banknumber;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0);
}
public void InitData()
{
if (Request.QueryString["pid"] != null)
{
string pid = Request.QueryString["pid"].ToString();
Model.H_Service service = H_ServiceClass.GetModel(pid);
this.TextName.Value = service.name;
this.TextTeamViewerID.Value = service.TeamViewerID;
this.TextTel.Value = service.telephone;
this.TextZhifubao.Value = service.zhifubao;
this.TextBank.Value = service.bank;
this.TextBank_name.Value = service.bankname;
this.TextBank_number.Value = service.banknumber;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Model.H_Service service = new Model.H_Service();
service.name = this.TextName.Value.Trim();
service.TeamViewerID = this.TextTeamViewerID.Value.Trim();
service.telephone = this.TextTel.Value.Trim();
service.zhifubao = this.TextZhifubao.Value.Trim();
service.bank = this.TextBank.Value.Trim();
service.bankname = this.TextBank_name.Value.Trim();
service.banknumber = this.TextBank_number.Value.Trim();
service.id = int.Parse(Request.QueryString["pid"]);
if (H_ServiceClass.Update(service))
{
//JScript.Alert("操作成功", "a2", this);
JScript.AlertAndRedirect("操作成功！", "ServiceList.aspx", this);
}
else
{
JScript.Alert("操作失败", "a2", this);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(Model.H_Service model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update H_Service set ");
strSql.Append("username=@username,");
strSql.Append("name=@name,");
strSql.Append("telephone=@telephone,");
strSql.Append("TeamViewerID=@TeamViewerID,");
strSql.Append("zhifubao=@zhifubao,");
strSql.Append("bank=@bank,");
strSql.Append("bankname=@bankname,");
strSql.Append("banknumber=@banknumber");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@username", SqlDbType.NVarChar, 50),
new SqlParameter("@name", SqlDbType.NVarChar, 50),
new SqlParameter("@telephone", SqlDbType.NVarChar, 50),
new SqlParameter("@TeamViewerID", SqlDbType.NVarChar, 50),
new SqlParameter("@zhifubao", SqlDbType.NVarChar, 50),
new SqlParameter("@bank", SqlDbType.NVarChar, 50),
new SqlParameter("@bankname", SqlDbType.NVarChar, 50),
new SqlParameter("@banknumber", SqlDbType.NVarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.username;
parameters[1].Value = model.name;
parameters[2].Value = model.telephone;
parameters[3].Value = model.TeamViewerID;
parameters[4].Value = model.zhifubao;
parameters[5].Value = model.bank;
parameters[6].Value = model.bankname;
parameters[7].Value = model.banknumber;
parameters[8].Value = model.id;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0);
}
protected void Button1_Click(object sender, EventArgs e)
{
Model.H_Service service = new Model.H_Service();
string strSql = "update H_User set isoccupy=1 where id=" + userid + "";
int count = DbHelperSQL.ExecuteSql(strSql);
service.username = username;
service.name = this.TextName.Value.Trim();
service.TeamViewerID = this.TextTeamViewerID.Value.Trim();
service.telephone = this.TextTel.Value.Trim();
service.zhifubao = this.TextZhifubao.Value.Trim();
service.bank = this.TextBank.Value.Trim();
service.bankname = this.TextBank_name.Value.Trim();
service.banknumber = this.TextBank_number.Value.Trim();
if (H_ServiceClass.Add(service) && count > 0)
{
JScript.Alert("操作成功！", "a2", this);
}
else
{
JScript.Alert("操作失败！", "a2", this);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static Model.H_Service GetModel(string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,username,name,telephone,TeamViewerID,zhifubao,bank,bankname,banknumber from H_Service ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Model.H_Service model = new Model.H_Service();
DataSet ds = DbHelperSQL.Query(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.username = ds.Tables[0].Rows[0]["username"].ToString();
model.name = ds.Tables[0].Rows[0]["name"].ToString();
model.telephone = ds.Tables[0].Rows[0]["telephone"].ToString();
model.TeamViewerID = ds.Tables[0].Rows[0]["TeamViewerID"].ToString();
model.zhifubao = ds.Tables[0].Rows[0]["zhifubao"].ToString();
model.bank = ds.Tables[0].Rows[0]["bank"].ToString();
model.bankname = ds.Tables[0].Rows[0]["bankname"].ToString();
model.banknumber = ds.Tables[0].Rows[0]["banknumber"].ToString();
return(model);
}
else
{
return(null);
}
}
