public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtOperatorCode.Text.Trim().Length == 0)
{
strErr += "OperatorCode不能为空！\\n";
}
if (this.txtIP.Text.Trim().Length == 0)
{
strErr += "IP不能为空！\\n";
}
if (this.txtBrowserName.Text.Trim().Length == 0)
{
strErr += "BrowserName不能为空！\\n";
}
if (this.txtBrowerVersion.Text.Trim().Length == 0)
{
strErr += "BrowerVersion不能为空！\\n";
}
if (this.txtOSName.Text.Trim().Length == 0)
{
strErr += "OSName不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtCreateTime.Text))
{
strErr += "CreateTime格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
long Id = long.Parse(this.lblId.Text);
string DanWeiName = this.lblDanWeiName.Text;
string JiQiMa = this.lblJiQiMa.Text;
string OperatorCode = this.txtOperatorCode.Text;
string IP = this.txtIP.Text;
string BrowserName = this.txtBrowserName.Text;
string BrowerVersion = this.txtBrowerVersion.Text;
string OSName = this.txtOSName.Text;
DateTime CreateTime = DateTime.Parse(this.txtCreateTime.Text);
WebDemo.Model.WebDemo.ClientEnvironmentInfo model = new WebDemo.Model.WebDemo.ClientEnvironmentInfo();
model.Id = Id;
model.DanWeiName = DanWeiName;
model.JiQiMa = JiQiMa;
model.OperatorCode = OperatorCode;
model.IP = IP;
model.BrowserName = BrowserName;
model.BrowerVersion = BrowerVersion;
model.OSName = OSName;
model.CreateTime = CreateTime;
WebDemo.BLL.WebDemo.ClientEnvironmentInfo bll = new WebDemo.BLL.WebDemo.ClientEnvironmentInfo();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
private void ShowInfo(long Id)
{
WebDemo.BLL.WebDemo.ClientEnvironmentInfo bll = new WebDemo.BLL.WebDemo.ClientEnvironmentInfo();
WebDemo.Model.WebDemo.ClientEnvironmentInfo model = bll.GetModel(Id);
this.lblId.Text = model.Id.ToString();
this.lblDanWeiName.Text = model.DanWeiName;
this.lblJiQiMa.Text = model.JiQiMa;
this.lblOperatorCode.Text = model.OperatorCode;
this.lblIP.Text = model.IP;
this.lblBrowserName.Text = model.BrowserName;
this.lblBrowerVersion.Text = model.BrowerVersion;
this.lblOSName.Text = model.OSName;
this.lblCreateTime.Text = model.CreateTime.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.ClientEnvironmentInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ClientEnvironmentInfo set ");
strSql.Append("OperatorCode=@OperatorCode,");
strSql.Append("IP=@IP,");
strSql.Append("BrowserName=@BrowserName,");
strSql.Append("BrowerVersion=@BrowerVersion,");
strSql.Append("OSName=@OSName");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@OperatorCode", SqlDbType.VarChar, 50),
new SqlParameter("@IP", SqlDbType.VarChar, 50),
new SqlParameter("@BrowserName", SqlDbType.VarChar, 50),
new SqlParameter("@BrowerVersion", SqlDbType.VarChar, 50),
new SqlParameter("@OSName", SqlDbType.VarChar, 50),
new SqlParameter("@Id", SqlDbType.BigInt, 8),
new SqlParameter("@DanWeiName", SqlDbType.NVarChar, 200),
new SqlParameter("@JiQiMa", SqlDbType.VarChar, 200),
new SqlParameter("@CreateTime", SqlDbType.DateTime)
};
parameters[0].Value = model.OperatorCode;
parameters[1].Value = model.IP;
parameters[2].Value = model.BrowserName;
parameters[3].Value = model.BrowerVersion;
parameters[4].Value = model.OSName;
parameters[5].Value = model.Id;
parameters[6].Value = model.DanWeiName;
parameters[7].Value = model.JiQiMa;
parameters[8].Value = model.CreateTime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.ClientEnvironmentInfo DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.ClientEnvironmentInfo model = new WebDemo.Model.WebDemo.ClientEnvironmentInfo();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = long.Parse(row["Id"].ToString());
}
if (row["DanWeiName"] != null)
{
model.DanWeiName = row["DanWeiName"].ToString();
}
if (row["JiQiMa"] != null)
{
model.JiQiMa = row["JiQiMa"].ToString();
}
if (row["OperatorCode"] != null)
{
model.OperatorCode = row["OperatorCode"].ToString();
}
if (row["IP"] != null)
{
model.IP = row["IP"].ToString();
}
if (row["BrowserName"] != null)
{
model.BrowserName = row["BrowserName"].ToString();
}
if (row["BrowerVersion"] != null)
{
model.BrowerVersion = row["BrowerVersion"].ToString();
}
if (row["OSName"] != null)
{
model.OSName = row["OSName"].ToString();
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(WebDemo.Model.WebDemo.ClientEnvironmentInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ClientEnvironmentInfo(");
strSql.Append("DanWeiName,JiQiMa,OperatorCode,IP,BrowserName,BrowerVersion,OSName,CreateTime)");
strSql.Append(" values (");
strSql.Append("@DanWeiName,@JiQiMa,@OperatorCode,@IP,@BrowserName,@BrowerVersion,@OSName,@CreateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@DanWeiName", SqlDbType.NVarChar, 200),
new SqlParameter("@JiQiMa", SqlDbType.VarChar, 200),
new SqlParameter("@OperatorCode", SqlDbType.VarChar, 50),
new SqlParameter("@IP", SqlDbType.VarChar, 50),
new SqlParameter("@BrowserName", SqlDbType.VarChar, 50),
new SqlParameter("@BrowerVersion", SqlDbType.VarChar, 50),
new SqlParameter("@OSName", SqlDbType.VarChar, 50),
new SqlParameter("@CreateTime", SqlDbType.DateTime)
};
parameters[0].Value = model.DanWeiName;
parameters[1].Value = model.JiQiMa;
parameters[2].Value = model.OperatorCode;
parameters[3].Value = model.IP;
parameters[4].Value = model.BrowserName;
parameters[5].Value = model.BrowerVersion;
parameters[6].Value = model.OSName;
parameters[7].Value = model.CreateTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.ClientEnvironmentInfo GetModel(long Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,DanWeiName,JiQiMa,OperatorCode,IP,BrowserName,BrowerVersion,OSName,CreateTime from ClientEnvironmentInfo ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.BigInt)
};
parameters[0].Value = Id;
WebDemo.Model.WebDemo.ClientEnvironmentInfo model = new WebDemo.Model.WebDemo.ClientEnvironmentInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
