public bool Add(M_DownServer DownServerInfo)
{
string strSql = "PR_DownServer_Add";
SqlParameter[] parameter = GetParameters(DownServerInfo);
return(SqlHelper.ExecuteProc(strSql, parameter));
}
private void InItModify(int Dsid)
{
B_DownServer bdownerver = new B_DownServer();
M_DownServer mdownserver = bdownerver.GetDownServerByid(Dsid);
TxtServerName.Text = mdownserver.ServerName;
TxtServerLogo.Text = mdownserver.ServerLogo;
TxtServerUrl.Text = mdownserver.ServerUrl;
DropShowType.SelectedValue = mdownserver.ShowType.ToString();
EBtnModify.Visible = true;
EBtnSubmit.Visible = false;
}
private M_DownServer GetDownServerInfoFromReader(SqlDataReader reader)
{
M_DownServer info = new M_DownServer();
info.ServerID = DataConverter.CLng(reader["ServerID"]);
info.ServerName = reader["ServerName"].ToString();
info.ServerUrl = reader["ServerUrl"].ToString();
info.ServerLogo = reader["ServerLogo"].ToString();
info.OrderID = DataConverter.CLng(reader["OrderID"]);
info.ShowType = DataConverter.CLng(reader["ShowType"]);
reader.Close();
return(info);
}
protected void EBtnSubmit_Click(object sender, EventArgs e)
{
B_DownServer bdownserver = new B_DownServer();
M_DownServer mdownserver = new M_DownServer();
mdownserver.ServerID = bdownserver.Max() + 1;
mdownserver.ServerName = TxtServerName.Text.ToString();
mdownserver.ServerLogo = TxtServerLogo.Text.ToString();
mdownserver.ServerUrl = TxtServerUrl.Text.ToString();
mdownserver.ShowType = Convert.ToInt32(DropShowType.SelectedValue);
if (bdownserver.Add(mdownserver))
{
Response.Write("<script language=javascript> alert('添加成功！');window.document.location.href='DownServerManage.aspx';</script>");
//Page.Response.Redirect("DownServerManage.aspx");
}
}
private SqlParameter[] GetParameters(M_DownServer downserverInfo)
{
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@ServerID", SqlDbType.Int),
new SqlParameter("@ServerName", SqlDbType.NVarChar, 50),
new SqlParameter("@ServerUrl", SqlDbType.NVarChar, 50),
new SqlParameter("@ServerLogo", SqlDbType.NVarChar, 255),
new SqlParameter("@OrderID", SqlDbType.Int),
new SqlParameter("@ShowType", SqlDbType.Int)
};
parameter[0].Value = downserverInfo.ServerID;
parameter[1].Value = downserverInfo.ServerName;
parameter[2].Value = downserverInfo.ServerUrl;
parameter[3].Value = downserverInfo.ServerLogo;
parameter[4].Value = downserverInfo.OrderID;
parameter[5].Value = downserverInfo.ShowType;
return(parameter);
}
public int insert(M_DownServer model)
{
return(DBCenter.Insert(model));
}
public bool UpdateByID(M_DownServer model)
{
return(DBCenter.UpdateByID(model, model.ServerID));
}
public bool Add(M_DownServer model)
{
Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model));
return(true);
}
public int insert(M_DownServer model)
{
return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public bool UpdateByID(M_DownServer model)
{
return(Sql.UpdateByIDs(TbName, PK, model.ServerID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
}
public bool Update(M_DownServer downserverInfo)
{
SqlParameter[] cmdParams = GetParameters(downserverInfo);;
return(SqlHelper.ExecuteProc("PR_DownServer_Update", cmdParams));
}
public bool Update(M_DownServer DownServerInfo)
{
return(DownServerMethod.Update(DownServerInfo));
}
public bool Add(M_DownServer downserverInfo)
{
return(DownServerMethod.Add(downserverInfo));
}
