/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.education_Activity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update education_Activity set "); strSql.Append("A_DateTime=@A_DateTime,"); strSql.Append("A_Location=@A_Location,"); strSql.Append("A_Form=@A_Form,"); strSql.Append("A_Object=@A_Object,"); strSql.Append("A_Crowd=@A_Crowd,"); strSql.Append("A_Duration=@A_Duration,"); strSql.Append("A_Organizers=@A_Organizers,"); strSql.Append("A_Partners=@A_Partners,"); strSql.Append("A_Missionary=@A_Missionary,"); strSql.Append("A_Number=@A_Number,"); strSql.Append("A_Theme=@A_Theme"); strSql.Append(" where ActivityID=@ActivityID"); SqlParameter[] parameters = { new SqlParameter("@A_DateTime", SqlDbType.DateTime), new SqlParameter("@A_Location", SqlDbType.NVarChar, 100), new SqlParameter("@A_Form", SqlDbType.NVarChar, 50), new SqlParameter("@A_Object", SqlDbType.Int, 4), new SqlParameter("@A_Crowd", SqlDbType.NVarChar, 50), new SqlParameter("@A_Duration", SqlDbType.Int, 4), new SqlParameter("@A_Organizers", SqlDbType.NVarChar, 50), new SqlParameter("@A_Partners", SqlDbType.NVarChar, 50), new SqlParameter("@A_Missionary", SqlDbType.NVarChar, 20), new SqlParameter("@A_Number", SqlDbType.Int, 4), new SqlParameter("@A_Theme", SqlDbType.Text), new SqlParameter("@ActivityID", SqlDbType.Int, 4) }; parameters[0].Value = model.A_DateTime; parameters[1].Value = model.A_Location; parameters[2].Value = model.A_Form; parameters[3].Value = model.A_Object; parameters[4].Value = model.A_Crowd; parameters[5].Value = model.A_Duration; parameters[6].Value = model.A_Organizers; parameters[7].Value = model.A_Partners; parameters[8].Value = model.A_Missionary; parameters[9].Value = model.A_Number; parameters[10].Value = model.A_Theme; parameters[11].Value = model.ActivityID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.education_Activity DataRowToModel(DataRow row) { Maticsoft.Model.education_Activity model=new Maticsoft.Model.education_Activity(); if (row != null) { if(row["ActivityID"]!=null && row["ActivityID"].ToString()!="") { model.ActivityID=int.Parse(row["ActivityID"].ToString()); } if(row["A_DateTime"]!=null && row["A_DateTime"].ToString()!="") { model.A_DateTime=DateTime.Parse(row["A_DateTime"].ToString()); } if(row["A_Location"]!=null) { model.A_Location=row["A_Location"].ToString(); } if(row["A_Form"]!=null) { model.A_Form=row["A_Form"].ToString(); } if(row["A_Object"]!=null && row["A_Object"].ToString()!="") { model.A_Object=int.Parse(row["A_Object"].ToString()); } if(row["A_Crowd"]!=null) { model.A_Crowd=row["A_Crowd"].ToString(); } if(row["A_Duration"]!=null && row["A_Duration"].ToString()!="") { model.A_Duration=int.Parse(row["A_Duration"].ToString()); } if(row["A_Organizers"]!=null) { model.A_Organizers=row["A_Organizers"].ToString(); } if(row["A_Partners"]!=null) { model.A_Partners=row["A_Partners"].ToString(); } if(row["A_Missionary"]!=null) { model.A_Missionary=row["A_Missionary"].ToString(); } if(row["A_Number"]!=null && row["A_Number"].ToString()!="") { model.A_Number=int.Parse(row["A_Number"].ToString()); } if(row["A_Theme"]!=null) { model.A_Theme=row["A_Theme"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.education_Activity DataRowToModel(DataRow row) { Maticsoft.Model.education_Activity model = new Maticsoft.Model.education_Activity(); if (row != null) { if (row["ActivityID"] != null && row["ActivityID"].ToString() != "") { model.ActivityID = int.Parse(row["ActivityID"].ToString()); } if (row["A_DateTime"] != null && row["A_DateTime"].ToString() != "") { model.A_DateTime = DateTime.Parse(row["A_DateTime"].ToString()); } if (row["A_Location"] != null) { model.A_Location = row["A_Location"].ToString(); } if (row["A_Form"] != null) { model.A_Form = row["A_Form"].ToString(); } if (row["A_Object"] != null && row["A_Object"].ToString() != "") { model.A_Object = int.Parse(row["A_Object"].ToString()); } if (row["A_Crowd"] != null) { model.A_Crowd = row["A_Crowd"].ToString(); } if (row["A_Duration"] != null && row["A_Duration"].ToString() != "") { model.A_Duration = int.Parse(row["A_Duration"].ToString()); } if (row["A_Organizers"] != null) { model.A_Organizers = row["A_Organizers"].ToString(); } if (row["A_Partners"] != null) { model.A_Partners = row["A_Partners"].ToString(); } if (row["A_Missionary"] != null) { model.A_Missionary = row["A_Missionary"].ToString(); } if (row["A_Number"] != null && row["A_Number"].ToString() != "") { model.A_Number = int.Parse(row["A_Number"].ToString()); } if (row["A_Theme"] != null) { model.A_Theme = row["A_Theme"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.education_Activity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into education_Activity("); strSql.Append("A_DateTime,A_Location,A_Form,A_Object,A_Crowd,A_Duration,A_Organizers,A_Partners,A_Missionary,A_Number,A_Theme)"); strSql.Append(" values ("); strSql.Append("@A_DateTime,@A_Location,@A_Form,@A_Object,@A_Crowd,@A_Duration,@A_Organizers,@A_Partners,@A_Missionary,@A_Number,@A_Theme)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@A_DateTime", SqlDbType.DateTime), new SqlParameter("@A_Location", SqlDbType.NVarChar, 100), new SqlParameter("@A_Form", SqlDbType.NVarChar, 50), new SqlParameter("@A_Object", SqlDbType.Int, 4), new SqlParameter("@A_Crowd", SqlDbType.NVarChar, 50), new SqlParameter("@A_Duration", SqlDbType.Int, 4), new SqlParameter("@A_Organizers", SqlDbType.NVarChar, 50), new SqlParameter("@A_Partners", SqlDbType.NVarChar, 50), new SqlParameter("@A_Missionary", SqlDbType.NVarChar, 20), new SqlParameter("@A_Number", SqlDbType.Int, 4), new SqlParameter("@A_Theme", SqlDbType.Text) }; parameters[0].Value = model.A_DateTime; parameters[1].Value = model.A_Location; parameters[2].Value = model.A_Form; parameters[3].Value = model.A_Object; parameters[4].Value = model.A_Crowd; parameters[5].Value = model.A_Duration; parameters[6].Value = model.A_Organizers; parameters[7].Value = model.A_Partners; parameters[8].Value = model.A_Missionary; parameters[9].Value = model.A_Number; parameters[10].Value = model.A_Theme; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private void ShowInfo(int ActivityID) { Maticsoft.BLL.education_Activity bll = new Maticsoft.BLL.education_Activity(); Maticsoft.Model.education_Activity model = bll.GetModel(ActivityID); this.lblActivityID.Text = model.ActivityID.ToString(); this.lblA_DateTime.Text = model.A_DateTime.ToString(); this.lblA_Location.Text = model.A_Location; this.lblA_Form.Text = model.A_Form; this.lblA_Object.Text = model.A_Object.ToString(); this.lblA_Crowd.Text = model.A_Crowd; this.lblA_Duration.Text = model.A_Duration.ToString(); this.lblA_Organizers.Text = model.A_Organizers; this.lblA_Partners.Text = model.A_Partners; this.lblA_Missionary.Text = model.A_Missionary; this.lblA_Number.Text = model.A_Number.ToString(); this.lblA_Theme.Text = model.A_Theme; }
/// <summary> /// 点击确定按钮执行的方法 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button1_Click(object sender, EventArgs e) { Maticsoft.BLL.education_Activity education_Activity_bll = new Maticsoft.BLL.education_Activity(); Maticsoft.Model.education_Activity education_Activity_model = education_Activity_bll.GetModel(ActivityID); if (education_Activity_model == null) { education_Activity_model = new Maticsoft.Model.education_Activity(); } education_Activity_model.A_DateTime = (DateTime)Common.sink(this.A_DateTime.UniqueID, MethodType.Post, 255, 0, DataType.Dat); education_Activity_model.A_Location = A_Location.Text; education_Activity_model.A_Object = (int)Common.sink(this.A_Object.UniqueID, MethodType.Post, 255, 0, DataType.Int); education_Activity_model.A_Crowd = A_Crowd.Text; education_Activity_model.A_Form = A_Form.Text; education_Activity_model.A_Duration = (int)Common.sink(this.A_Duration.UniqueID, MethodType.Post, 255, 0, DataType.Int); education_Activity_model.A_Organizers = A_Organizers.Text; education_Activity_model.A_Partners = A_Partners.Text; education_Activity_model.A_Missionary = A_Missionary.Text; education_Activity_model.A_Number = (int)Common.sink(this.A_Number.UniqueID, MethodType.Post, 255, 0, DataType.Int); education_Activity_model.A_Theme = A_Theme.Text; switch (CMD) { case "New": CMD_Txt = "增加"; //如果是增加操作,就调用Add方法 education_Activity_model.ActivityID = education_Activity_bll.Add(education_Activity_model); break; case "Edit": CMD_Txt = "修改"; //如果是修改操作,就调用Update方法 education_Activity_bll.Update(education_Activity_model); break; } All_Title_Txt = CMD_Txt + App_Txt; //以下方法的第4个参数需要更改 EventMessage.MessageBox(1, "操作成功", string.Format("{1}ID({0})成功!", education_Activity_model.ActivityID, All_Title_Txt), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx")); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.education_Activity GetModel(int ActivityID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ActivityID,A_DateTime,A_Location,A_Form,A_Object,A_Crowd,A_Duration,A_Organizers,A_Partners,A_Missionary,A_Number,A_Theme from education_Activity "); strSql.Append(" where ActivityID=@ActivityID"); SqlParameter[] parameters = { new SqlParameter("@ActivityID", SqlDbType.Int, 4) }; parameters[0].Value = ActivityID; Maticsoft.Model.education_Activity model = new Maticsoft.Model.education_Activity(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsDateTime(txtA_DateTime.Text)) { strErr += "活动时间格式错误!\\n"; } if (this.txtA_Location.Text.Trim().Length == 0) { strErr += "活动地点不能为空!\\n"; } if (this.txtA_Form.Text.Trim().Length == 0) { strErr += "活动形式不能为空!\\n"; } if (!PageValidate.IsNumber(txtA_Object.Text)) { strErr += "居委会ID格式错误!\\n"; } if (this.txtA_Crowd.Text.Trim().Length == 0) { strErr += "参与人群不能为空!\\n"; } if (!PageValidate.IsNumber(txtA_Duration.Text)) { strErr += "持续时间(min)格式错误!\\n"; } if (this.txtA_Organizers.Text.Trim().Length == 0) { strErr += "主办单位不能为空!\\n"; } if (this.txtA_Partners.Text.Trim().Length == 0) { strErr += "合作伙伴不能为空!\\n"; } if (this.txtA_Missionary.Text.Trim().Length == 0) { strErr += "宣教人不能为空!\\n"; } if (!PageValidate.IsNumber(txtA_Number.Text)) { strErr += "参与人数格式错误!\\n"; } if (this.txtA_Theme.Text.Trim().Length == 0) { strErr += "活动主题不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } DateTime A_DateTime = DateTime.Parse(this.txtA_DateTime.Text); string A_Location = this.txtA_Location.Text; string A_Form = this.txtA_Form.Text; int A_Object = int.Parse(this.txtA_Object.Text); string A_Crowd = this.txtA_Crowd.Text; int A_Duration = int.Parse(this.txtA_Duration.Text); string A_Organizers = this.txtA_Organizers.Text; string A_Partners = this.txtA_Partners.Text; string A_Missionary = this.txtA_Missionary.Text; int A_Number = int.Parse(this.txtA_Number.Text); string A_Theme = this.txtA_Theme.Text; Maticsoft.Model.education_Activity model = new Maticsoft.Model.education_Activity(); model.A_DateTime = A_DateTime; model.A_Location = A_Location; model.A_Form = A_Form; model.A_Object = A_Object; model.A_Crowd = A_Crowd; model.A_Duration = A_Duration; model.A_Organizers = A_Organizers; model.A_Partners = A_Partners; model.A_Missionary = A_Missionary; model.A_Number = A_Number; model.A_Theme = A_Theme; Maticsoft.BLL.education_Activity bll = new Maticsoft.BLL.education_Activity(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
protected void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(!PageValidate.IsDateTime(txtA_DateTime.Text)) { strErr+="活动时间格式错误!\\n"; } if(this.txtA_Location.Text.Trim().Length==0) { strErr+="活动地点不能为空!\\n"; } if(this.txtA_Form.Text.Trim().Length==0) { strErr+="活动形式不能为空!\\n"; } if(!PageValidate.IsNumber(txtA_Object.Text)) { strErr+="居委会ID格式错误!\\n"; } if(this.txtA_Crowd.Text.Trim().Length==0) { strErr+="参与人群不能为空!\\n"; } if(!PageValidate.IsNumber(txtA_Duration.Text)) { strErr+="持续时间(min)格式错误!\\n"; } if(this.txtA_Organizers.Text.Trim().Length==0) { strErr+="主办单位不能为空!\\n"; } if(this.txtA_Partners.Text.Trim().Length==0) { strErr+="合作伙伴不能为空!\\n"; } if(this.txtA_Missionary.Text.Trim().Length==0) { strErr+="宣教人不能为空!\\n"; } if(!PageValidate.IsNumber(txtA_Number.Text)) { strErr+="参与人数格式错误!\\n"; } if(this.txtA_Theme.Text.Trim().Length==0) { strErr+="活动主题不能为空!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } DateTime A_DateTime=DateTime.Parse(this.txtA_DateTime.Text); string A_Location=this.txtA_Location.Text; string A_Form=this.txtA_Form.Text; int A_Object=int.Parse(this.txtA_Object.Text); string A_Crowd=this.txtA_Crowd.Text; int A_Duration=int.Parse(this.txtA_Duration.Text); string A_Organizers=this.txtA_Organizers.Text; string A_Partners=this.txtA_Partners.Text; string A_Missionary=this.txtA_Missionary.Text; int A_Number=int.Parse(this.txtA_Number.Text); string A_Theme=this.txtA_Theme.Text; Maticsoft.Model.education_Activity model=new Maticsoft.Model.education_Activity(); model.A_DateTime=A_DateTime; model.A_Location=A_Location; model.A_Form=A_Form; model.A_Object=A_Object; model.A_Crowd=A_Crowd; model.A_Duration=A_Duration; model.A_Organizers=A_Organizers; model.A_Partners=A_Partners; model.A_Missionary=A_Missionary; model.A_Number=A_Number; model.A_Theme=A_Theme; Maticsoft.BLL.education_Activity bll=new Maticsoft.BLL.education_Activity(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.education_Activity GetModel(int ActivityID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 ActivityID,A_DateTime,A_Location,A_Form,A_Object,A_Crowd,A_Duration,A_Organizers,A_Partners,A_Missionary,A_Number,A_Theme from education_Activity "); strSql.Append(" where ActivityID=@ActivityID"); SqlParameter[] parameters = { new SqlParameter("@ActivityID", SqlDbType.Int,4) }; parameters[0].Value = ActivityID; Maticsoft.Model.education_Activity model=new Maticsoft.Model.education_Activity(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }