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