protected void ButtonEditSub_Click(object sender, EventArgs e)
{
DtCms.BLL.Activity activityBLL = new DtCms.BLL.Activity();
DtCms.Model.Activity activity = new DtCms.Model.Activity();
activity.ActivityId = TextBoxActivityId.Text.Trim();
activity.Applicant = TextBoxApplicant.Text.Trim();
activity.Title = TextBoxTitle.Text.Trim();
activity.Budget = Convert.ToInt32(TextBoxBudget.Text.Trim());
activity.ATime = Convert.ToDateTime(TextBoxATime.Text);
activity.Place = TextBoxPlace.Text.Trim();
activity.AConten = TextBoxAcontent.Text.Trim();
activity.CheckStatus = TextBoxCheckStatus.Text.Trim();
activityBLL.Update(activity);
Response.Write("<script>alert('提交成功。')</script>");
}
protected void ButtonBack_Click(object sender, EventArgs e)
{
string activityId = HiddenFieldBack.Value.ToString();
DtCms.Model.Activity activity = new DtCms.Model.Activity();
DtCms.BLL.Activity activityBLL = new DtCms.BLL.Activity();
activity.ActivityId = activityId;
activity.ASuggestion = TextBoxSuggestion.Text.Trim();
activity.CheckStatus = "退回修改";
if (activity.ATime == null || activity.ATime == DateTime.MinValue)
{
activity.ATime = new DateTime(1900, 1, 1);
}
activityBLL.UpdateOneRecordAuditStatusBack(activityId);
activityBLL.UpdateFieldSu(activityId, TextBoxSuggestion.Text.Trim());
Response.Write("<script>alert('提交成功。')</script>");
}
protected void ActSubmit(object sender, EventArgs e)
{
DtCms.BLL.Activity planBLL = new DtCms.BLL.Activity();
if (planBLL.AcExists(Convert.ToDateTime(Request.Form["test5"]), DropDownAPlace.SelectedValue.Trim()) == true)
{
ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('该时间地点已被使用，请更换。')</script>");
}
else
{
DateTime dtDate;
if (DateTime.TryParse(Request.Form["test5"], out dtDate))
{
Console.WriteLine(dtDate);
}
else
{
throw new Exception("不是正确的日期格式类型！");
}
DtCms.Model.Activity plan = new DtCms.Model.Activity();
plan.ActivityId = TextBoxActivitySim.Text.Trim() + DateTime.Now.ToString("yyyyMMdd") + Session["TeamLeader"].ToString();
plan.Applicant = Session["TeamLeader"].ToString();
plan.Title = TextBoxActivity.Text.Trim();
plan.Budget = Convert.ToInt32(TextBoxBudget.Text.Trim());
plan.ATime = Convert.ToDateTime(Request.Form["test5"]);
plan.Place = DropDownAPlace.SelectedValue.Trim();
plan.AConten = Request.Form["txtAContent"];
plan.CheckStatus = TextBoxAudMode.Text;
plan.StandingNum = 0;
plan.SuperVIPNum = 0;
plan.VIPNum = 0;
plan.CommonNum = 0;
plan.TicketStatus = "未发布";
int result = planBLL.Add(plan);
if (result == 0)
{
Response.Write("<script>alert('提交成功。')</script>");
}
else
{
ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('提交失败。')</script>");
}
}
}
protected void ButtonEditSub_Click(object sender, EventArgs e)
{
DtCms.BLL.Activity activityBLL = new DtCms.BLL.Activity();
DtCms.Model.Activity activity = new DtCms.Model.Activity();
activity.ActivityId = TextBoxActivityId.Text.Trim();
activity.Applicant = TextBoxApplicant.Text.Trim();
activity.Title = TextBoxTitle.Text.Trim();
activity.Budget = Convert.ToInt32(TextBoxBudget.Text.Trim());
activity.ATime = Convert.ToDateTime(Request.Form["test5"]);
activity.Place = DropDownAPlace.SelectedValue.Trim();
activity.AConten = TextBoxAcontent.Text.Trim();
activity.CheckStatus = TextBoxCheckStatus.Text.Trim();
activity.ASuggestion = "无建议";
activityBLL.Update(activity);
Response.Write("<script>alert('提交成功。')</script>");
activityBLL.ReupdateOneRecordAuditStatus(TextBoxActivityId.Text.Trim());
GridView1.DataBind();
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DtCms.Model.Activity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_TacvitityApply(");
strSql.Append("ActivityId,Applicant,Title,Budget,ATime,AConten,AInTrodatction,Place,AddTime,CheckStatus,Preparation,Middle,LastPre,SuperVIPNum,VIPNum,CommonNum,StandingNum,TicketStatus,ASuggestion)");
strSql.Append(" values (");
strSql.Append("@ActivityId,@Applicant,@Title,@Budget,@ATime,@AConten,@AInTrodatction,@Place,@AddTime,@CheckStatus,@Preparation,@Middle,@LastPre,@SuperVIPNum,@VIPNum,@CommonNum,@StandingNum,@TicketStatus,@ASuggestion)");
SqlParameter[] parameters =
{
new SqlParameter("@ActivityId", SqlDbType.VarChar, 20),
new SqlParameter("@Applicant", SqlDbType.NVarChar, 20),
new SqlParameter("@Title", SqlDbType.NVarChar, 50),
new SqlParameter("@Budget", SqlDbType.Int),
new SqlParameter("@ATime", SqlDbType.DateTime),
new SqlParameter("@AConten", SqlDbType.NText),
new SqlParameter("@AInTrodatction", SqlDbType.NText),
new SqlParameter("@Place", SqlDbType.NVarChar, 50),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@CheckStatus", SqlDbType.NVarChar, 100),
new SqlParameter("@Preparation", SqlDbType.NText),
new SqlParameter("@Middle", SqlDbType.NText),
new SqlParameter("@LastPre", SqlDbType.NText),
new SqlParameter("@SuperVIPNum", SqlDbType.Int),
new SqlParameter("@VIPNum", SqlDbType.Int),
new SqlParameter("@CommonNum", SqlDbType.Int),
new SqlParameter("@StandingNum", SqlDbType.Int),
new SqlParameter("@TicketStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@ASuggestion", SqlDbType.NText)
};
parameters[0].Value = model.ActivityId;
parameters[1].Value = model.Applicant;
parameters[2].Value = model.Title;
parameters[3].Value = model.Budget;
parameters[4].Value = model.ATime;
parameters[5].Value = model.AConten;
parameters[6].Value = model.AInTrodatction;
parameters[7].Value = model.Place;
parameters[8].Value = model.AddTime;
parameters[9].Value = model.CheckStatus;
parameters[10].Value = model.Preparation;
parameters[11].Value = model.Middle;
parameters[12].Value = model.LastPre;
parameters[13].Value = model.SuperVIPNum;
parameters[14].Value = model.VIPNum;
parameters[15].Value = model.CommonNum;
parameters[16].Value = model.StandingNum;
parameters[17].Value = model.TicketStatus;
parameters[18].Value = model.ASuggestion;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public DtCms.Model.Activity QueryOneRecord(string activityId)
{
DtCms.Model.Activity activity;
string cmdstr = "Select * From dt_TacvitityApply Where ActivityId='" + activityId + "'";
SqlParameter[] SqlParam = new SqlParameter[1];
SqlParam[0] = new SqlParameter("@ActivityId", activityId);
//获取SqlDataReader对象
SqlDataReader dataReader = DbHelperSQL.ExecuteReader(cmdstr, SqlParam);
if (dataReader.Read())
{
activity = new DtCms.Model.Activity();
activity.ActivityId = dataReader["ActivityId"].ToString();
activity.Applicant = dataReader["Applicant"].ToString();
activity.Title = dataReader["Title"].ToString();
activity.Budget = Convert.ToInt32(dataReader["Budget"]);
activity.ATime = Convert.ToDateTime(dataReader["ATime"].ToString());
activity.AddTime = Convert.ToDateTime(dataReader["AddTime"].ToString());
activity.AConten = dataReader["AConten"].ToString();
activity.AInTrodatction = dataReader["AInTrodatction"].ToString();
activity.Place = dataReader["Place"].ToString();
activity.CheckStatus = dataReader["CheckStatus"].ToString();
activity.Preparation = dataReader["Preparation"].ToString();
activity.Middle = dataReader["Middle"].ToString();
activity.LastPre = dataReader["LastPre"].ToString();
activity.SuperVIPNum = Convert.ToInt32(dataReader["SuperVIPNum"]);
activity.VIPNum = Convert.ToInt32(dataReader["VIPNum"]);
activity.CommonNum = Convert.ToInt32(dataReader["CommonNum"]);
activity.StandingNum = Convert.ToInt32(dataReader["StandingNum"]);
activity.TicketStatus = dataReader["TicketStatus"].ToString();
if (dataReader["ASuggestion"] is System.DBNull)
{
activity.ASuggestion = "无建议";
}
else
{
activity.ASuggestion = dataReader["ASuggestion"].ToString();
}
if (dataReader["Preparation"] is System.DBNull)
{
activity.Preparation = "未提交";
}
else
{
activity.Preparation = dataReader["Preparation"].ToString();
}
if (dataReader["Middle"] is System.DBNull)
{
activity.Middle = "未提交";
}
else
{
activity.Middle = dataReader["Middle"].ToString();
}
if (dataReader["LastPre"] is System.DBNull)
{
activity.LastPre = "未提交";
}
else
{
activity.LastPre = dataReader["LastPre"].ToString();
}
}
else
{
activity = null;
}
dataReader.Close();
return(activity);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DtCms.Model.Activity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_TacvitityApply set ");
strSql.Append("Applicant=@Applicant,");
strSql.Append("Title=@Title,");
strSql.Append("Budget=@Budget,");
strSql.Append("ATime=@ATime,");
strSql.Append("AConten=@AConten,");
strSql.Append("AInTrodatction=@AInTrodatction,");
strSql.Append("Place=@Place,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("CheckStatus=@CheckStatus,");
strSql.Append("Preparation=@Preparation,");
strSql.Append("Middle=@Middle,");
strSql.Append("LastPre=@LastPre,");
strSql.Append("SuperVIPNum=@SuperVIPNum,");
strSql.Append("VIPNum=@VIPNum,");
strSql.Append("CommonNum=@CommonNum,");
strSql.Append("StandingNum=@StandingNum,");
strSql.Append("TicketStatus=@TicketStatus,");
strSql.Append("ASuggestion=@ASuggestion ");
strSql.Append(" where ActivityId=@ActivityId");
SqlParameter[] parameters =
{
new SqlParameter("@ActivityId", SqlDbType.VarChar, 20),
new SqlParameter("@Applicant", SqlDbType.NVarChar, 20),
new SqlParameter("@Title", SqlDbType.NVarChar, 50),
new SqlParameter("@Budget", SqlDbType.Int),
new SqlParameter("@ATime", SqlDbType.DateTime),
new SqlParameter("@AConten", SqlDbType.NText),
new SqlParameter("@AInTrodatction", SqlDbType.NText),
new SqlParameter("@Place", SqlDbType.NVarChar, 50),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@CheckStatus", SqlDbType.NVarChar, 100),
new SqlParameter("@Preparation", SqlDbType.NText),
new SqlParameter("@Middle", SqlDbType.NText),
new SqlParameter("@LastPre", SqlDbType.NText),
new SqlParameter("@SuperVIPNum", SqlDbType.Int),
new SqlParameter("@VIPNum", SqlDbType.Int),
new SqlParameter("@CommonNum", SqlDbType.Int),
new SqlParameter("@StandingNum", SqlDbType.Int),
new SqlParameter("@TicketStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@ASuggestion", SqlDbType.NText)
};
parameters[0].Value = model.ActivityId;
parameters[1].Value = model.Applicant;
parameters[2].Value = model.Title;
parameters[3].Value = model.Budget;
parameters[4].Value = model.ATime;
parameters[5].Value = model.AConten;
parameters[6].Value = model.AInTrodatction;
parameters[7].Value = model.Place;
parameters[8].Value = model.AddTime;
parameters[9].Value = model.CheckStatus;
parameters[10].Value = model.Preparation;
parameters[11].Value = model.Middle;
parameters[12].Value = model.LastPre;
parameters[13].Value = model.SuperVIPNum;
parameters[14].Value = model.VIPNum;
parameters[15].Value = model.CommonNum;
parameters[16].Value = model.StandingNum;
parameters[17].Value = model.TicketStatus;
parameters[18].Value = model.ASuggestion;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DtCms.Model.Activity model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DtCms.Model.Activity model)
{
return(dal.Add(model));
}
