/// <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;
}
}
