public bool Update(DtCms.Model.Programme model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_Programme set ");
strSql.Append("ProgrammeName=@ProgrammeName");
strSql.Append(" where ProgrammeId=@ProgrammeId");
SqlParameter[] parameters =
{
new SqlParameter("@ActivityId", SqlDbType.VarChar, 100),
new SqlParameter("@ProgrammeId", SqlDbType.VarChar, 100),
new SqlParameter("@ProgrammeName", SqlDbType.VarChar, 100),
};
parameters[0].Value = model.ActivityId;
parameters[1].Value = model.ProgrammeId;
parameters[2].Value = model.ProgrammeName;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public int Add(DtCms.Model.Programme model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_Programme(");
strSql.Append("ActivityId,ProgrammeId,ProgrammeName)");
strSql.Append(" values (");
strSql.Append("@ActivityId,@ProgrammeId,@ProgrammeName)");
SqlParameter[] parameters =
{
new SqlParameter("@ActivityId", SqlDbType.VarChar, 100),
new SqlParameter("@ProgrammeId", SqlDbType.VarChar, 100),
new SqlParameter("@ProgrammeName", SqlDbType.VarChar, 100)
};
parameters[0].Value = model.ActivityId;
parameters[1].Value = model.ProgrammeId;
parameters[2].Value = model.ProgrammeName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public DtCms.Model.Programme QueryOneRecord(string activityId, string pId)
{
DtCms.Model.Programme programme;
string cmdstr = "Select * From dt_Programme Where ActivityId='" + activityId + "' AND ProgrammeId='" + pId + "'";
SqlParameter[] SqlParam = new SqlParameter[1];
SqlParam[0] = new SqlParameter("@ActivityId", activityId);
//获取SqlDataReader对象
SqlDataReader dataReader = DbHelperSQL.ExecuteReader(cmdstr, SqlParam);
if (dataReader.Read())
{
programme = new DtCms.Model.Programme();
programme.ActivityId = dataReader["ActivityId"].ToString();
programme.ProgrammeId = dataReader["ProgrammeId"].ToString();
programme.ProgrammeName = dataReader["ProgrammeName"].ToString();
}
else
{
programme = null;
}
dataReader.Close();
return(programme);
}
protected void ButtonPSub_Click(object sender, EventArgs e)
{
if (TextBox1.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label1.Text.ToString()) == true)
{
programme1.ProgrammeName = TextBox1.Text.ToString();
programme1.ProgrammeId = HiddenFieldP.Value + Label1.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label1.Text.ToString();
programme1.ProgrammeName = TextBox1.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox2.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label2.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label2.Text.ToString();
programme1.ProgrammeName = TextBox2.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label2.Text.ToString();
programme1.ProgrammeName = TextBox2.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox3.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label3.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label3.Text.ToString();
programme1.ProgrammeName = TextBox3.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label3.Text.ToString();
programme1.ProgrammeName = TextBox3.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox4.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label4.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label4.Text.ToString();
programme1.ProgrammeName = TextBox4.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label4.Text.ToString();
programme1.ProgrammeName = TextBox4.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox5.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label5.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label5.Text.ToString();
programme1.ProgrammeName = TextBox5.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label5.Text.ToString();
programme1.ProgrammeName = TextBox5.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox6.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label6.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label6.Text.ToString();
programme1.ProgrammeName = TextBox6.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label6.Text.ToString();
programme1.ProgrammeName = TextBox6.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox7.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label7.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label7.Text.ToString();
programme1.ProgrammeName = TextBox7.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ProgrammeId = HiddenFieldP.Value + Label7.Text.ToString();
programme1.ProgrammeName = TextBox7.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox8.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label8.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label8.Text.ToString();
programme1.ProgrammeName = TextBox8.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label8.Text.ToString();
programme1.ProgrammeName = TextBox8.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox9.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label9.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label9.Text.ToString();
programme1.ProgrammeName = TextBox9.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label9.Text.ToString();
programme1.ProgrammeName = TextBox9.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox10.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label10.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label10.Text.ToString();
programme1.ProgrammeName = TextBox10.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label10.Text.ToString();
programme1.ProgrammeName = TextBox10.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox11.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label11.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label11.Text.ToString();
programme1.ProgrammeName = TextBox11.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label11.Text.ToString();
programme1.ProgrammeName = TextBox11.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox12.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label12.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label12.Text.ToString();
programme1.ProgrammeName = TextBox12.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label12.Text.ToString();
programme1.ProgrammeName = TextBox12.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox13.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label13.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label13.Text.ToString();
programme1.ProgrammeName = TextBox13.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label13.Text.ToString();
programme1.ProgrammeName = TextBox13.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox14.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label14.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label14.Text.ToString();
programme1.ProgrammeName = TextBox14.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label14.Text.ToString();
programme1.ProgrammeName = TextBox14.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
if (TextBox15.Text != "")
{
DtCms.Model.Programme programme1 = new DtCms.Model.Programme();
DtCms.BLL.Programme programme1Bll = new DtCms.BLL.Programme();
if (programme1Bll.PExists(HiddenFieldP.Value, HiddenFieldP.Value + Label15.Text.ToString()) == true)
{
programme1.ProgrammeId = HiddenFieldP.Value + Label15.Text.ToString();
programme1.ProgrammeName = TextBox15.Text.ToString();
programme1Bll.Update(programme1);
}
else
{
programme1.ActivityId = HiddenFieldP.Value;
programme1.ProgrammeId = HiddenFieldP.Value + Label15.Text.ToString();
programme1.ProgrammeName = TextBox15.Text.ToString();
DtCms.BLL.Programme bll = new DtCms.BLL.Programme();
bll.Add(programme1);
}
}
Response.Write("<script>alert('提交成功。')</script>");
PanelAdd.Visible = false;
}
public bool Update(DtCms.Model.Programme model)
{
return(dal.Update(model));
}
public int Add(DtCms.Model.Programme model)
{
return(dal.Add(model));
}
