public void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(this.txtSE_TID.Text.Trim().Length==0) { strErr+="SE_TID不能为空!\\n"; } if(!PageValidate.IsDateTime(txtSE_CTIME.Text)) { strErr+="SE_CTIME格式错误!\\n"; } if(this.txtSE_NAME.Text.Trim().Length==0) { strErr+="SE_NAME不能为空!\\n"; } if(this.txtSE_CONTENT.Text.Trim().Length==0) { strErr+="SE_CONTENT不能为空!\\n"; } if(!PageValidate.IsDateTime(txtSE_TTIME.Text)) { strErr+="SE_TTIME格式错误!\\n"; } if(this.txtSE_DTIME.Text.Trim().Length==0) { strErr+="SE_DTIME不能为空!\\n"; } if(!PageValidate.IsNumber(txtSE_DELFLAG.Text)) { strErr+="SE_DELFLAG格式错误!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string SE_ID=this.lblSE_ID.Text; string SE_TID=this.txtSE_TID.Text; DateTime SE_CTIME=DateTime.Parse(this.txtSE_CTIME.Text); string SE_NAME=this.txtSE_NAME.Text; string SE_CONTENT=this.txtSE_CONTENT.Text; DateTime SE_TTIME=DateTime.Parse(this.txtSE_TTIME.Text); string SE_DTIME=this.txtSE_DTIME.Text; int SE_DELFLAG=int.Parse(this.txtSE_DELFLAG.Text); cfs.Model.OT_SESSION model=new cfs.Model.OT_SESSION(); model.SE_ID=SE_ID; model.SE_TID=SE_TID; model.SE_CTIME=SE_CTIME; model.SE_NAME=SE_NAME; model.SE_CONTENT=SE_CONTENT; model.SE_TTIME=SE_TTIME; model.SE_DTIME=SE_DTIME; model.SE_DELFLAG=SE_DELFLAG; cfs.BLL.OT_SESSION bll=new cfs.BLL.OT_SESSION(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public cfs.Model.OT_SESSION GetModel(string SE_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SE_ID,SE_TID,SE_CTIME,SE_NAME,SE_CONTENT,SE_TTIME,SE_DTIME,SE_DELFLAG from OT_SESSION "); strSql.Append(" where SE_ID=@SE_ID "); SqlParameter[] parameters = { new SqlParameter("@SE_ID", SqlDbType.VarChar, 64) }; parameters[0].Value = SE_ID; cfs.Model.OT_SESSION model = new cfs.Model.OT_SESSION(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SE_ID"] != null && ds.Tables[0].Rows[0]["SE_ID"].ToString() != "") { model.SE_ID = ds.Tables[0].Rows[0]["SE_ID"].ToString(); } if (ds.Tables[0].Rows[0]["SE_TID"] != null && ds.Tables[0].Rows[0]["SE_TID"].ToString() != "") { model.SE_TID = ds.Tables[0].Rows[0]["SE_TID"].ToString(); } if (ds.Tables[0].Rows[0]["SE_CTIME"] != null && ds.Tables[0].Rows[0]["SE_CTIME"].ToString() != "") { model.SE_CTIME = DateTime.Parse(ds.Tables[0].Rows[0]["SE_CTIME"].ToString()); } if (ds.Tables[0].Rows[0]["SE_NAME"] != null && ds.Tables[0].Rows[0]["SE_NAME"].ToString() != "") { model.SE_NAME = ds.Tables[0].Rows[0]["SE_NAME"].ToString(); } if (ds.Tables[0].Rows[0]["SE_CONTENT"] != null && ds.Tables[0].Rows[0]["SE_CONTENT"].ToString() != "") { model.SE_CONTENT = ds.Tables[0].Rows[0]["SE_CONTENT"].ToString(); } if (ds.Tables[0].Rows[0]["SE_TTIME"] != null && ds.Tables[0].Rows[0]["SE_TTIME"].ToString() != "") { model.SE_TTIME = DateTime.Parse(ds.Tables[0].Rows[0]["SE_TTIME"].ToString()); } if (ds.Tables[0].Rows[0]["SE_DTIME"] != null && ds.Tables[0].Rows[0]["SE_DTIME"].ToString() != "") { model.SE_DTIME = ds.Tables[0].Rows[0]["SE_DTIME"].ToString(); } if (ds.Tables[0].Rows[0]["SE_DELFLAG"] != null && ds.Tables[0].Rows[0]["SE_DELFLAG"].ToString() != "") { model.SE_DELFLAG = int.Parse(ds.Tables[0].Rows[0]["SE_DELFLAG"].ToString()); } return(model); } else { return(null); } }
private void ShowInfo(string SE_ID) { cfs.BLL.OT_SESSION bll = new cfs.BLL.OT_SESSION(); cfs.Model.OT_SESSION model = bll.GetModel(SE_ID); this.lblSE_ID.Text = model.SE_ID; this.lblSE_TID.Text = model.SE_TID; this.lblSE_CTIME.Text = model.SE_CTIME.ToString(); this.lblSE_NAME.Text = model.SE_NAME; this.lblSE_CONTENT.Text = model.SE_CONTENT; this.lblSE_TTIME.Text = model.SE_TTIME.ToString(); this.lblSE_DTIME.Text = model.SE_DTIME; this.lblSE_DELFLAG.Text = model.SE_DELFLAG.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(cfs.Model.OT_SESSION model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OT_SESSION set "); strSql.Append("SE_TID=@SE_TID,"); strSql.Append("SE_CTIME=@SE_CTIME,"); strSql.Append("SE_NAME=@SE_NAME,"); strSql.Append("SE_CONTENT=@SE_CONTENT,"); strSql.Append("SE_TTIME=@SE_TTIME,"); strSql.Append("SE_DTIME=@SE_DTIME,"); strSql.Append("SE_DELFLAG=@SE_DELFLAG"); strSql.Append(" where SE_ID=@SE_ID "); SqlParameter[] parameters = { new SqlParameter("@SE_TID", SqlDbType.VarChar, 50), new SqlParameter("@SE_CTIME", SqlDbType.DateTime), new SqlParameter("@SE_NAME", SqlDbType.NVarChar, 500), new SqlParameter("@SE_CONTENT", SqlDbType.Text), new SqlParameter("@SE_TTIME", SqlDbType.DateTime), new SqlParameter("@SE_DTIME", SqlDbType.VarChar, 50), new SqlParameter("@SE_DELFLAG", SqlDbType.Int, 4), new SqlParameter("@SE_ID", SqlDbType.VarChar, 64) }; parameters[0].Value = model.SE_TID; parameters[1].Value = model.SE_CTIME; parameters[2].Value = model.SE_NAME; parameters[3].Value = model.SE_CONTENT; parameters[4].Value = model.SE_TTIME; parameters[5].Value = model.SE_DTIME; parameters[6].Value = model.SE_DELFLAG; parameters[7].Value = model.SE_ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtSE_ID.Text.Trim().Length == 0) { strErr += "SE_ID不能为空!\\n"; } if (this.txtSE_TID.Text.Trim().Length == 0) { strErr += "SE_TID不能为空!\\n"; } if (!PageValidate.IsDateTime(txtSE_CTIME.Text)) { strErr += "SE_CTIME格式错误!\\n"; } if (this.txtSE_NAME.Text.Trim().Length == 0) { strErr += "SE_NAME不能为空!\\n"; } if (this.txtSE_CONTENT.Text.Trim().Length == 0) { strErr += "SE_CONTENT不能为空!\\n"; } if (!PageValidate.IsDateTime(txtSE_TTIME.Text)) { strErr += "SE_TTIME格式错误!\\n"; } if (this.txtSE_DTIME.Text.Trim().Length == 0) { strErr += "SE_DTIME不能为空!\\n"; } if (!PageValidate.IsNumber(txtSE_DELFLAG.Text)) { strErr += "SE_DELFLAG格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string SE_ID = this.txtSE_ID.Text; string SE_TID = this.txtSE_TID.Text; DateTime SE_CTIME = DateTime.Parse(this.txtSE_CTIME.Text); string SE_NAME = this.txtSE_NAME.Text; string SE_CONTENT = this.txtSE_CONTENT.Text; DateTime SE_TTIME = DateTime.Parse(this.txtSE_TTIME.Text); string SE_DTIME = this.txtSE_DTIME.Text; int SE_DELFLAG = int.Parse(this.txtSE_DELFLAG.Text); cfs.Model.OT_SESSION model = new cfs.Model.OT_SESSION(); model.SE_ID = SE_ID; model.SE_TID = SE_TID; model.SE_CTIME = SE_CTIME; model.SE_NAME = SE_NAME; model.SE_CONTENT = SE_CONTENT; model.SE_TTIME = SE_TTIME; model.SE_DTIME = SE_DTIME; model.SE_DELFLAG = SE_DELFLAG; cfs.BLL.OT_SESSION bll = new cfs.BLL.OT_SESSION(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public cfs.Model.OT_SESSION GetModel(string SE_ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 SE_ID,SE_TID,SE_CTIME,SE_NAME,SE_CONTENT,SE_TTIME,SE_DTIME,SE_DELFLAG from OT_SESSION "); strSql.Append(" where SE_ID=@SE_ID "); SqlParameter[] parameters = { new SqlParameter("@SE_ID", SqlDbType.VarChar,64) }; parameters[0].Value = SE_ID; cfs.Model.OT_SESSION model=new cfs.Model.OT_SESSION(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["SE_ID"]!=null && ds.Tables[0].Rows[0]["SE_ID"].ToString()!="") { model.SE_ID=ds.Tables[0].Rows[0]["SE_ID"].ToString(); } if(ds.Tables[0].Rows[0]["SE_TID"]!=null && ds.Tables[0].Rows[0]["SE_TID"].ToString()!="") { model.SE_TID=ds.Tables[0].Rows[0]["SE_TID"].ToString(); } if(ds.Tables[0].Rows[0]["SE_CTIME"]!=null && ds.Tables[0].Rows[0]["SE_CTIME"].ToString()!="") { model.SE_CTIME=DateTime.Parse(ds.Tables[0].Rows[0]["SE_CTIME"].ToString()); } if(ds.Tables[0].Rows[0]["SE_NAME"]!=null && ds.Tables[0].Rows[0]["SE_NAME"].ToString()!="") { model.SE_NAME=ds.Tables[0].Rows[0]["SE_NAME"].ToString(); } if(ds.Tables[0].Rows[0]["SE_CONTENT"]!=null && ds.Tables[0].Rows[0]["SE_CONTENT"].ToString()!="") { model.SE_CONTENT=ds.Tables[0].Rows[0]["SE_CONTENT"].ToString(); } if(ds.Tables[0].Rows[0]["SE_TTIME"]!=null && ds.Tables[0].Rows[0]["SE_TTIME"].ToString()!="") { model.SE_TTIME=DateTime.Parse(ds.Tables[0].Rows[0]["SE_TTIME"].ToString()); } if(ds.Tables[0].Rows[0]["SE_DTIME"]!=null && ds.Tables[0].Rows[0]["SE_DTIME"].ToString()!="") { model.SE_DTIME=ds.Tables[0].Rows[0]["SE_DTIME"].ToString(); } if(ds.Tables[0].Rows[0]["SE_DELFLAG"]!=null && ds.Tables[0].Rows[0]["SE_DELFLAG"].ToString()!="") { model.SE_DELFLAG=int.Parse(ds.Tables[0].Rows[0]["SE_DELFLAG"].ToString()); } return model; } else { return null; } }