// Lista Lista locations public ResponseType GetActivities(string userName) { DataTable dt = new DataTable(); List <ActivitiesInfo> ActivitiesList = new List <ActivitiesInfo>(); var ret = new ResponseType(); // Carica Location dt = Database.GetData("SELECT Activity_id, ActivityCode, a.Name as ActivityName, a.Projects_id FROM Activity as a INNER JOIN Projects as b ON b.Projects_id = a.Projects_id WHERE a.active= 1 AND b.active = 1"); // carica Dictionary foreach (DataRow dr in dt.Rows) { ActivitiesInfo item = new ActivitiesInfo(); item.Activity_id = Convert.ToInt32(dr["Activity_id"].ToString()); item.ActivityCode = dr["ActivityCode"].ToString(); item.ActivityName = dr["ActivityName"].ToString(); item.Projects_id = Convert.ToInt32(dr["Projects_id"].ToString()); ActivitiesList.Add(item); } // prepara risposta if (ActivitiesList.Count > 0) { ret.status = true; ret.data = ActivitiesList; } else { ret.status = false; ret.data = null; } return(ret); }
public bool UpdateActivities(ActivitiesInfo activity) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("UPDATE Hishop_Activities SET ").Append("ActivitiesName=@ActivitiesName,").Append("ActivitiesType=@ActivitiesType,").Append("MeetMoney=@MeetMoney,").Append("ReductionMoney=@ReductionMoney,").Append("StartTime=@StartTime,").Append("EndTIme=@EndTIme,").Append("ActivitiesDescription=@ActivitiesDescription").Append(" WHERE ActivitiesId=@ActivitiesId"); System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString()); this.database.AddInParameter(sqlStringCommand, "ActivitiesName", System.Data.DbType.String, activity.ActivitiesName); this.database.AddInParameter(sqlStringCommand, "ActivitiesType", System.Data.DbType.Int32, activity.ActivitiesType); this.database.AddInParameter(sqlStringCommand, "MeetMoney", System.Data.DbType.Decimal, activity.MeetMoney); this.database.AddInParameter(sqlStringCommand, "ReductionMoney", System.Data.DbType.Decimal, activity.ReductionMoney); this.database.AddInParameter(sqlStringCommand, "StartTime", System.Data.DbType.DateTime, activity.StartTime); this.database.AddInParameter(sqlStringCommand, "EndTIme", System.Data.DbType.DateTime, activity.EndTIme); this.database.AddInParameter(sqlStringCommand, "ActivitiesDescription", System.Data.DbType.String, activity.ActivitiesDescription); this.database.AddInParameter(sqlStringCommand, "ActivitiesId", System.Data.DbType.Int32, activity.ActivitiesId); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
public int AddActivities(ActivitiesInfo activity) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("INSERT INTO Hishop_Activities(").Append("ActivitiesName,ActivitiesType,MeetMoney,ReductionMoney,StartTime,EndTIme,ActivitiesDescription,Type)").Append(" VALUES (").Append("@ActivitiesName,@ActivitiesType,@MeetMoney,@ReductionMoney,@StartTime,@EndTime,@ActivitiesDescription,@Type)"); System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString()); this.database.AddInParameter(sqlStringCommand, "ActivitiesName", System.Data.DbType.String, activity.ActivitiesName); this.database.AddInParameter(sqlStringCommand, "ActivitiesType", System.Data.DbType.Int32, activity.ActivitiesType); this.database.AddInParameter(sqlStringCommand, "MeetMoney", System.Data.DbType.Decimal, activity.MeetMoney); this.database.AddInParameter(sqlStringCommand, "ReductionMoney", System.Data.DbType.Decimal, activity.ReductionMoney); this.database.AddInParameter(sqlStringCommand, "StartTime", System.Data.DbType.DateTime, activity.StartTime); this.database.AddInParameter(sqlStringCommand, "EndTIme", System.Data.DbType.DateTime, activity.EndTIme); this.database.AddInParameter(sqlStringCommand, "ActivitiesDescription", System.Data.DbType.String, activity.ActivitiesDescription); this.database.AddInParameter(sqlStringCommand, "Type", System.Data.DbType.Int32, activity.Type); return(this.database.ExecuteNonQuery(sqlStringCommand)); }
public static bool UpdateActivities(ActivitiesInfo activity) { return(new ActivitiesDao().UpdateActivities(activity)); }
public static int AddActivities(ActivitiesInfo activity) { return(new ActivitiesDao().AddActivities(activity)); }
private void AAbiuZJB(object obj, EventArgs eventArg) { int num = 0; if (!this.txtStartDate.SelectedDate.HasValue) { this.ShowMsg("请选择开始日期!", false); return; } if (!this.txtEndDate.SelectedDate.HasValue) { this.ShowMsg("请选择结束日期!", false); return; } if (this.txtStartDate.SelectedDate.Value.CompareTo(this.txtEndDate.SelectedDate.Value) > 0) { this.ShowMsg("开始日期不能晚于结束日期!", false); return; } if (this.txtReductionMoney.Text.Trim() == "" || !int.TryParse(this.txtReductionMoney.Text.Trim(), out num)) { this.ShowMsg("减免金额请输入整数!", false); return; } if (this.txtMeetMoney.Text.Trim() == "" || !int.TryParse(this.txtMeetMoney.Text.Trim(), out num)) { this.ShowMsg("满足金额请输入整数!", false); return; } if (int.Parse(this.txtReductionMoney.Text.Trim()) >= int.Parse(this.txtMeetMoney.Text.Trim())) { this.ShowMsg("减免金额不能大于等于满足金额!", false); return; } ActivitiesInfo activitiesInfo = new ActivitiesInfo() { ActivitiesName = this.txtName.Text.Trim(), ActivitiesDescription = this.txtDescription.Text.Trim(), StartTime = this.txtStartDate.SelectedDate.Value, EndTIme = this.txtEndDate.SelectedDate.Value, MeetMoney = decimal.Parse(this.txtMeetMoney.Text.Trim()), ReductionMoney = decimal.Parse(this.txtReductionMoney.Text.Trim()) }; if (this.dropCategories.SelectedValue.ToString() == "0" || this.dropCategories.SelectedValue.ToString() == "") { activitiesInfo.ActivitiesType = 0; activitiesInfo.Type = 1; } else { int?selectedValue = this.dropCategories.SelectedValue; activitiesInfo.ActivitiesType = int.Parse(selectedValue.ToString()); activitiesInfo.Type = 0; } DataTable dataTable = new DataTable(); dataTable = (activitiesInfo.Type != 1 ? VShopHelper.GetType(1) : VShopHelper.GetType(0)); if (dataTable.Rows.Count > 0) { this.ShowMsg("类目和全部不能同时参加活动!", false); return; } if (VShopHelper.AddActivities(activitiesInfo) > 0) { base.Response.Redirect("ActivitiesList.aspx"); return; } this.ShowMsg("添加失败", false); }
private void btnEditActivity_Click(object sender, EventArgs e) { decimal result = 0M; decimal num2 = 0M; if (!this.txtStartDate.SelectedDate.HasValue) { this.ShowMsg("请选择开始日期!", false); } else if (!this.txtEndDate.SelectedDate.HasValue) { this.ShowMsg("请选择结束日期!", false); } else if (this.txtStartDate.SelectedDate.Value.CompareTo(this.txtEndDate.SelectedDate.Value) > 0) { this.ShowMsg("开始日期不能晚于结束日期!", false); } else if (this.txtReductionMoney.Text.Trim() == "") { this.ShowMsg("减免金额请输入整数!", false); } else if (!decimal.TryParse(this.txtReductionMoney.Text.Trim(), out result)) { this.ShowMsg("减免金额请输入整数", false); } else if (this.txtMeetMoney.Text.Trim() == "") { this.ShowMsg("满足金额请输入整数!", false); } else if (!decimal.TryParse(this.txtMeetMoney.Text.Trim(), out num2)) { this.ShowMsg("满足金额请输入整数", false); } else if (decimal.Parse(this.txtReductionMoney.Text.Trim()) >= decimal.Parse(this.txtMeetMoney.Text.Trim())) { this.ShowMsg("减免金额不能大于等于满足金额!", false); } else { ActivitiesInfo activity = new ActivitiesInfo { ActivitiesName = this.txtName.Text.Trim(), ActivitiesDescription = this.txtDescription.Text.Trim(), StartTime = this.txtStartDate.SelectedDate.Value, EndTIme = this.txtEndDate.SelectedDate.Value, MeetMoney = decimal.Parse(this.txtMeetMoney.Text.Trim()), ReductionMoney = decimal.Parse(this.txtReductionMoney.Text.Trim()) }; if ((this.dropCategories.SelectedValue.ToString() == "0") || (this.dropCategories.SelectedValue.ToString() == "")) { activity.Type = 1; activity.ActivitiesType = 0; } else { activity.Type = 0; activity.ActivitiesType = int.Parse(this.dropCategories.SelectedValue.ToString()); } activity.ActivitiesId = this.activitiesid; DataTable type = new DataTable(); if (activity.Type == 1) { type = VShopHelper.GetType(0); } else { type = VShopHelper.GetType(1); } if (type.Rows.Count > 0) { this.ShowMsg("类目和全部不能同时参加活动!", false); } else if (VShopHelper.UpdateActivities(activity)) { this.ShowMsg("修改成功", true); } else { this.ShowMsg("修改失败", false); } } }
private void btnEditActivity_Click(object obj, EventArgs eventArg) { decimal num = new decimal(0); decimal num1 = new decimal(0); if (!this.txtStartDate.SelectedDate.HasValue) { this.ShowMsg("请选择开始日期!", false); return; } if (!this.txtEndDate.SelectedDate.HasValue) { this.ShowMsg("请选择结束日期!", false); return; } if (this.txtStartDate.SelectedDate.Value.CompareTo(this.txtEndDate.SelectedDate.Value) > 0) { this.ShowMsg("开始日期不能晚于结束日期!", false); return; } if (this.txtReductionMoney.Text.Trim() == "") { this.ShowMsg("减免金额请输入整数!", false); return; } if (!decimal.TryParse(this.txtReductionMoney.Text.Trim(), out num)) { this.ShowMsg("减免金额请输入整数", false); return; } if (this.txtMeetMoney.Text.Trim() == "") { this.ShowMsg("满足金额请输入整数!", false); return; } if (!decimal.TryParse(this.txtMeetMoney.Text.Trim(), out num1)) { this.ShowMsg("满足金额请输入整数", false); return; } if (decimal.Parse(this.txtReductionMoney.Text.Trim()) >= decimal.Parse(this.txtMeetMoney.Text.Trim())) { this.ShowMsg("减免金额不能大于等于满足金额!", false); return; } ActivitiesInfo activitiesInfo = new ActivitiesInfo() { ActivitiesName = this.txtName.Text.Trim(), ActivitiesDescription = this.txtDescription.Text.Trim(), StartTime = this.txtStartDate.SelectedDate.Value, EndTIme = this.txtEndDate.SelectedDate.Value, MeetMoney = decimal.Parse(this.txtMeetMoney.Text.Trim()), ReductionMoney = decimal.Parse(this.txtReductionMoney.Text.Trim()) }; if (this.dropCategories.SelectedValue.ToString() == "0" || this.dropCategories.SelectedValue.ToString() == "") { activitiesInfo.Type = 1; activitiesInfo.ActivitiesType = 0; } else { activitiesInfo.Type = 0; int?selectedValue = this.dropCategories.SelectedValue; activitiesInfo.ActivitiesType = int.Parse(selectedValue.ToString()); } activitiesInfo.ActivitiesId = this.m_ActivitiesId; DataTable dataTable = new DataTable(); dataTable = (activitiesInfo.Type != 1 ? VShopHelper.GetType(1) : VShopHelper.GetType(0)); if (dataTable.Rows.Count > 0) { this.ShowMsg("类目和全部不能同时参加活动!", false); return; } if (VShopHelper.UpdateActivities(activitiesInfo)) { this.ShowMsg("修改成功", true); return; } this.ShowMsg("修改失败", false); }
private void btnAddActivity_Click(object sender, EventArgs e) { int result = 0; if (!this.txtStartDate.SelectedDate.HasValue) { this.ShowMsg("请选择开始日期!", false); } else if (!this.txtEndDate.SelectedDate.HasValue) { this.ShowMsg("请选择结束日期!", false); } else if (this.txtStartDate.SelectedDate.Value.CompareTo(this.txtEndDate.SelectedDate.Value) > 0) { this.ShowMsg("开始日期不能晚于结束日期!", false); } else if ((this.txtReductionMoney.Text.Trim() == "") || !int.TryParse(this.txtReductionMoney.Text.Trim(), out result)) { this.ShowMsg("减免金额请输入整数!", false); } else if ((this.txtMeetMoney.Text.Trim() == "") || !int.TryParse(this.txtMeetMoney.Text.Trim(), out result)) { this.ShowMsg("满足金额请输入整数!", false); } else if (int.Parse(this.txtReductionMoney.Text.Trim()) >= int.Parse(this.txtMeetMoney.Text.Trim())) { this.ShowMsg("减免金额不能大于等于满足金额!", false); } else { ActivitiesInfo activity = new ActivitiesInfo { ActivitiesName = this.txtName.Text.Trim(), ActivitiesDescription = this.txtDescription.Text.Trim(), StartTime = this.txtStartDate.SelectedDate.Value, EndTIme = this.txtEndDate.SelectedDate.Value, MeetMoney = decimal.Parse(this.txtMeetMoney.Text.Trim()), ReductionMoney = decimal.Parse(this.txtReductionMoney.Text.Trim()) }; if ((this.dropCategories.SelectedValue.ToString() == "0") || (this.dropCategories.SelectedValue.ToString() == "")) { activity.ActivitiesType = 0; activity.Type = 1; } else { activity.ActivitiesType = int.Parse(this.dropCategories.SelectedValue.ToString()); activity.Type = 0; } DataTable type = new DataTable(); if (activity.Type == 1) { type = VShopHelper.GetType(0); } else { type = VShopHelper.GetType(1); } if (type.Rows.Count > 0) { this.ShowMsg("类目和全部不能同时参加活动!", false); } else if (VShopHelper.AddActivities(activity) > 0) { base.Response.Redirect("ActivitiesList.aspx"); } else { this.ShowMsg("添加失败", false); } } }