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); }