private void ShowInfo(int OnlineID) { Maticsoft.BLL.sys_Online bll = new Maticsoft.BLL.sys_Online(); Maticsoft.Model.sys_Online model = bll.GetModel(OnlineID); this.lblOnlineID.Text = model.OnlineID.ToString(); this.lblO_SessionID.Text = model.O_SessionID; this.txtO_UserName.Text = model.O_UserName; this.txtO_Ip.Text = model.O_Ip; this.txtO_LoginTime.Text = model.O_LoginTime.ToString(); this.txtO_LastTime.Text = model.O_LastTime.ToString(); this.txtO_LastUrl.Text = model.O_LastUrl; }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtO_SessionID.Text.Trim().Length == 0) { strErr += "用户SessionID不能为空!\\n"; } if (this.txtO_UserName.Text.Trim().Length == 0) { strErr += "用户名不能为空!\\n"; } if (this.txtO_Ip.Text.Trim().Length == 0) { strErr += "用户IP地址不能为空!\\n"; } if (!PageValidate.IsDateTime(txtO_LoginTime.Text)) { strErr += "登陆时间格式错误!\\n"; } if (!PageValidate.IsDateTime(txtO_LastTime.Text)) { strErr += "最后访问时间格式错误!\\n"; } if (this.txtO_LastUrl.Text.Trim().Length == 0) { strErr += "最后请求网站不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string O_SessionID = this.txtO_SessionID.Text; string O_UserName = this.txtO_UserName.Text; string O_Ip = this.txtO_Ip.Text; DateTime O_LoginTime = DateTime.Parse(this.txtO_LoginTime.Text); DateTime O_LastTime = DateTime.Parse(this.txtO_LastTime.Text); string O_LastUrl = this.txtO_LastUrl.Text; Maticsoft.Model.sys_Online model = new Maticsoft.Model.sys_Online(); model.O_SessionID = O_SessionID; model.O_UserName = O_UserName; model.O_Ip = O_Ip; model.O_LoginTime = O_LoginTime; model.O_LastTime = O_LastTime; model.O_LastUrl = O_LastUrl; Maticsoft.BLL.sys_Online bll = new Maticsoft.BLL.sys_Online(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
protected void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(this.txtO_SessionID.Text.Trim().Length==0) { strErr+="用户SessionID不能为空!\\n"; } if(this.txtO_UserName.Text.Trim().Length==0) { strErr+="用户名不能为空!\\n"; } if(this.txtO_Ip.Text.Trim().Length==0) { strErr+="用户IP地址不能为空!\\n"; } if(!PageValidate.IsDateTime(txtO_LoginTime.Text)) { strErr+="登陆时间格式错误!\\n"; } if(!PageValidate.IsDateTime(txtO_LastTime.Text)) { strErr+="最后访问时间格式错误!\\n"; } if(this.txtO_LastUrl.Text.Trim().Length==0) { strErr+="最后请求网站不能为空!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string O_SessionID=this.txtO_SessionID.Text; string O_UserName=this.txtO_UserName.Text; string O_Ip=this.txtO_Ip.Text; DateTime O_LoginTime=DateTime.Parse(this.txtO_LoginTime.Text); DateTime O_LastTime=DateTime.Parse(this.txtO_LastTime.Text); string O_LastUrl=this.txtO_LastUrl.Text; Maticsoft.Model.sys_Online model=new Maticsoft.Model.sys_Online(); model.O_SessionID=O_SessionID; model.O_UserName=O_UserName; model.O_Ip=O_Ip; model.O_LoginTime=O_LoginTime; model.O_LastTime=O_LastTime; model.O_LastUrl=O_LastUrl; Maticsoft.BLL.sys_Online bll=new Maticsoft.BLL.sys_Online(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","add.aspx"); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.sys_Online model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update sys_Online set "); strSql.Append("O_UserName=@O_UserName,"); strSql.Append("O_Ip=@O_Ip,"); strSql.Append("O_LoginTime=@O_LoginTime,"); strSql.Append("O_LastTime=@O_LastTime,"); strSql.Append("O_LastUrl=@O_LastUrl"); strSql.Append(" where OnlineID=@OnlineID"); SqlParameter[] parameters = { new SqlParameter("@O_UserName", SqlDbType.NVarChar, 20), new SqlParameter("@O_Ip", SqlDbType.VarChar, 15), new SqlParameter("@O_LoginTime", SqlDbType.DateTime), new SqlParameter("@O_LastTime", SqlDbType.DateTime), new SqlParameter("@O_LastUrl", SqlDbType.NVarChar, 500), new SqlParameter("@OnlineID", SqlDbType.Int, 4), new SqlParameter("@O_SessionID", SqlDbType.VarChar, 24) }; parameters[0].Value = model.O_UserName; parameters[1].Value = model.O_Ip; parameters[2].Value = model.O_LoginTime; parameters[3].Value = model.O_LastTime; parameters[4].Value = model.O_LastUrl; parameters[5].Value = model.OnlineID; parameters[6].Value = model.O_SessionID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.sys_Online model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into sys_Online("); strSql.Append("O_SessionID,O_UserName,O_Ip,O_LoginTime,O_LastTime,O_LastUrl)"); strSql.Append(" values ("); strSql.Append("@O_SessionID,@O_UserName,@O_Ip,@O_LoginTime,@O_LastTime,@O_LastUrl)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@O_SessionID", SqlDbType.VarChar, 24), new SqlParameter("@O_UserName", SqlDbType.NVarChar, 20), new SqlParameter("@O_Ip", SqlDbType.VarChar, 15), new SqlParameter("@O_LoginTime", SqlDbType.DateTime), new SqlParameter("@O_LastTime", SqlDbType.DateTime), new SqlParameter("@O_LastUrl", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.O_SessionID; parameters[1].Value = model.O_UserName; parameters[2].Value = model.O_Ip; parameters[3].Value = model.O_LoginTime; parameters[4].Value = model.O_LastTime; parameters[5].Value = model.O_LastUrl; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Online DataRowToModel(DataRow row) { Maticsoft.Model.sys_Online model = new Maticsoft.Model.sys_Online(); if (row != null) { if (row["OnlineID"] != null && row["OnlineID"].ToString() != "") { model.OnlineID = int.Parse(row["OnlineID"].ToString()); } if (row["O_SessionID"] != null) { model.O_SessionID = row["O_SessionID"].ToString(); } if (row["O_UserName"] != null) { model.O_UserName = row["O_UserName"].ToString(); } if (row["O_Ip"] != null) { model.O_Ip = row["O_Ip"].ToString(); } if (row["O_LoginTime"] != null && row["O_LoginTime"].ToString() != "") { model.O_LoginTime = DateTime.Parse(row["O_LoginTime"].ToString()); } if (row["O_LastTime"] != null && row["O_LastTime"].ToString() != "") { model.O_LastTime = DateTime.Parse(row["O_LastTime"].ToString()); } if (row["O_LastUrl"] != null) { model.O_LastUrl = row["O_LastUrl"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Online GetModel(int OnlineID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 OnlineID,O_SessionID,O_UserName,O_Ip,O_LoginTime,O_LastTime,O_LastUrl from sys_Online "); strSql.Append(" where OnlineID=@OnlineID"); SqlParameter[] parameters = { new SqlParameter("@OnlineID", SqlDbType.Int, 4) }; parameters[0].Value = OnlineID; Maticsoft.Model.sys_Online model = new Maticsoft.Model.sys_Online(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Online DataRowToModel(DataRow row) { Maticsoft.Model.sys_Online model=new Maticsoft.Model.sys_Online(); if (row != null) { if(row["OnlineID"]!=null && row["OnlineID"].ToString()!="") { model.OnlineID=int.Parse(row["OnlineID"].ToString()); } if(row["O_SessionID"]!=null) { model.O_SessionID=row["O_SessionID"].ToString(); } if(row["O_UserName"]!=null) { model.O_UserName=row["O_UserName"].ToString(); } if(row["O_Ip"]!=null) { model.O_Ip=row["O_Ip"].ToString(); } if(row["O_LoginTime"]!=null && row["O_LoginTime"].ToString()!="") { model.O_LoginTime=DateTime.Parse(row["O_LoginTime"].ToString()); } if(row["O_LastTime"]!=null && row["O_LastTime"].ToString()!="") { model.O_LastTime=DateTime.Parse(row["O_LastTime"].ToString()); } if(row["O_LastUrl"]!=null) { model.O_LastUrl=row["O_LastUrl"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.sys_Online GetModel(int OnlineID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 OnlineID,O_SessionID,O_UserName,O_Ip,O_LoginTime,O_LastTime,O_LastUrl from sys_Online "); strSql.Append(" where OnlineID=@OnlineID"); SqlParameter[] parameters = { new SqlParameter("@OnlineID", SqlDbType.Int,4) }; parameters[0].Value = OnlineID; Maticsoft.Model.sys_Online model=new Maticsoft.Model.sys_Online(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }