public override SqlParameter[] GetParameters()
{
M_DownServer model = this;
if (model.Addtime <= DateTime.MinValue)
{
model.Addtime = DateTime.Now;
}
if (model.Encryptime <= DateTime.MinValue)
{
model.Encryptime = DateTime.Now;
}
SqlParameter[] sp = GetSP();
sp[0].Value = model.ServerID;
sp[1].Value = model.ServerName;
sp[2].Value = model.ServerUrl;
sp[3].Value = model.ServerLogo;
sp[4].Value = model.OrderID;
sp[5].Value = model.ShowType;
sp[6].Value = model.UrlEncrypt;
sp[7].Value = model.UrlEncrypt;
sp[8].Value = model.TimeEncrypt;
sp[9].Value = model.UpTimeuti;
sp[10].Value = model.Addtime;
sp[11].Value = model.Encryptime;
sp[12].Value = model.ReadRoot;
return(sp);
}
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");
}
}
public M_DownServer GetModelFromReader(DbDataReader rdr)
{
M_DownServer model = new M_DownServer();
model.ServerID = Convert.ToInt32(rdr["ServerID"]);
model.ServerName = ConverToStr(rdr["ServerName"]);
model.ServerUrl = ConverToStr(rdr["ServerUrl"]);
model.ServerLogo = ConverToStr(rdr["ServerLogo"]);
model.OrderID = ConvertToInt(rdr["OrderID"]);
model.ShowType = ConvertToInt(rdr["ShowType"]);
model.UrlEncrypt = ConvertToInt(rdr["UrlEncrypt"]);
model.EncryptKey = ConverToStr(rdr["EncryptKey"]);
model.TimeEncrypt = ConvertToInt(rdr["TimeEncrypt"]);
model.UpTimeuti = ConvertToInt(rdr["UpTimeuti"]);
model.Addtime = ConvertToDate(rdr["Addtime"]);;
model.Encryptime = ConvertToDate(rdr["Encryptime"]);
model.ReadRoot = ConverToStr(rdr["ReadRoot"]);
rdr.Close();
rdr.Dispose();
return(model);
}
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;
}
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;
}
public bool Update(M_DownServer downserverInfo)
{
SqlParameter[] cmdParams = GetParameters(downserverInfo); ;
return SqlHelper.ExecuteProc("PR_DownServer_Update", cmdParams);
}
public bool Add(M_DownServer DownServerInfo)
{
string strSql = "PR_DownServer_Add";
SqlParameter[] parameter = GetParameters(DownServerInfo);
return SqlHelper.ExecuteProc(strSql, parameter);
}
public bool Update(M_DownServer DownServerInfo)
{
return DownServerMethod.Update(DownServerInfo);
}
public bool Add(M_DownServer downserverInfo)
{
return DownServerMethod.Add(downserverInfo);
}
