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