protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtServerName.Text.Trim().Length == 0)
{
strErr += "ServerName不能为空！\\n";
}
if (!PageValidate.IsNumber(txtServerType.Text))
{
strErr += "ServerType格式错误！\\n";
}
if (this.txtServerIp.Text.Trim().Length == 0)
{
strErr += "ServerIp不能为空！\\n";
}
if (this.txtWcfUrl.Text.Trim().Length == 0)
{
strErr += "WcfUrl不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtOperTime.Text))
{
strErr += "OperTime格式错误！\\n";
}
if (this.txtRemark.Text.Trim().Length == 0)
{
strErr += "Remark不能为空！\\n";
}
if (!PageValidate.IsNumber(txtPort.Text))
{
strErr += "Port格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string ServerName = this.txtServerName.Text;
int ServerType = int.Parse(this.txtServerType.Text);
string ServerIp = this.txtServerIp.Text;
string WcfUrl = this.txtWcfUrl.Text;
DateTime OperTime = DateTime.Parse(this.txtOperTime.Text);
string Remark = this.txtRemark.Text;
int Port = int.Parse(this.txtPort.Text);
WebDemo.Model.WebDemo.CollectServer model = new WebDemo.Model.WebDemo.CollectServer();
model.ServerName = ServerName;
model.ServerType = ServerType;
model.ServerIp = ServerIp;
model.WcfUrl = WcfUrl;
model.OperTime = OperTime;
model.Remark = Remark;
model.Port = Port;
WebDemo.BLL.WebDemo.CollectServer bll = new WebDemo.BLL.WebDemo.CollectServer();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
private void ShowInfo(int ServerId)
{
WebDemo.BLL.WebDemo.CollectServer bll = new WebDemo.BLL.WebDemo.CollectServer();
WebDemo.Model.WebDemo.CollectServer model = bll.GetModel(ServerId);
this.lblServerId.Text = model.ServerId.ToString();
this.lblServerName.Text = model.ServerName;
this.lblServerType.Text = model.ServerType.ToString();
this.lblServerIp.Text = model.ServerIp;
this.lblWcfUrl.Text = model.WcfUrl;
this.lblOperTime.Text = model.OperTime.ToString();
this.lblRemark.Text = model.Remark;
this.lblPort.Text = model.Port.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.CollectServer model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CollectServer set ");
strSql.Append("ServerName=@ServerName,");
strSql.Append("ServerType=@ServerType,");
strSql.Append("ServerIp=@ServerIp,");
strSql.Append("WcfUrl=@WcfUrl,");
strSql.Append("OperTime=@OperTime,");
strSql.Append("Remark=@Remark,");
strSql.Append("Port=@Port");
strSql.Append(" where ServerId=@ServerId");
SqlParameter[] parameters =
{
new SqlParameter("@ServerName", SqlDbType.VarChar, 50),
new SqlParameter("@ServerType", SqlDbType.Int, 4),
new SqlParameter("@ServerIp", SqlDbType.VarChar, 50),
new SqlParameter("@WcfUrl", SqlDbType.VarChar, 50),
new SqlParameter("@OperTime", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.VarChar, 100),
new SqlParameter("@Port", SqlDbType.Int, 4),
new SqlParameter("@ServerId", SqlDbType.Int, 4)
};
parameters[0].Value = model.ServerName;
parameters[1].Value = model.ServerType;
parameters[2].Value = model.ServerIp;
parameters[3].Value = model.WcfUrl;
parameters[4].Value = model.OperTime;
parameters[5].Value = model.Remark;
parameters[6].Value = model.Port;
parameters[7].Value = model.ServerId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.CollectServer DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.CollectServer model = new WebDemo.Model.WebDemo.CollectServer();
if (row != null)
{
if (row["ServerId"] != null && row["ServerId"].ToString() != "")
{
model.ServerId = int.Parse(row["ServerId"].ToString());
}
if (row["ServerName"] != null)
{
model.ServerName = row["ServerName"].ToString();
}
if (row["ServerType"] != null && row["ServerType"].ToString() != "")
{
model.ServerType = int.Parse(row["ServerType"].ToString());
}
if (row["ServerIp"] != null)
{
model.ServerIp = row["ServerIp"].ToString();
}
if (row["WcfUrl"] != null)
{
model.WcfUrl = row["WcfUrl"].ToString();
}
if (row["OperTime"] != null && row["OperTime"].ToString() != "")
{
model.OperTime = DateTime.Parse(row["OperTime"].ToString());
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["Port"] != null && row["Port"].ToString() != "")
{
model.Port = int.Parse(row["Port"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebDemo.Model.WebDemo.CollectServer model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CollectServer(");
strSql.Append("ServerName,ServerType,ServerIp,WcfUrl,OperTime,Remark,Port)");
strSql.Append(" values (");
strSql.Append("@ServerName,@ServerType,@ServerIp,@WcfUrl,@OperTime,@Remark,@Port)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ServerName", SqlDbType.VarChar, 50),
new SqlParameter("@ServerType", SqlDbType.Int, 4),
new SqlParameter("@ServerIp", SqlDbType.VarChar, 50),
new SqlParameter("@WcfUrl", SqlDbType.VarChar, 50),
new SqlParameter("@OperTime", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.VarChar, 100),
new SqlParameter("@Port", SqlDbType.Int, 4)
};
parameters[0].Value = model.ServerName;
parameters[1].Value = model.ServerType;
parameters[2].Value = model.ServerIp;
parameters[3].Value = model.WcfUrl;
parameters[4].Value = model.OperTime;
parameters[5].Value = model.Remark;
parameters[6].Value = model.Port;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.CollectServer GetModel(int ServerId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ServerId,ServerName,ServerType,ServerIp,WcfUrl,OperTime,Remark,Port from CollectServer ");
strSql.Append(" where ServerId=@ServerId");
SqlParameter[] parameters =
{
new SqlParameter("@ServerId", SqlDbType.Int, 4)
};
parameters[0].Value = ServerId;
WebDemo.Model.WebDemo.CollectServer model = new WebDemo.Model.WebDemo.CollectServer();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
