/// <summary>
/// grid 数据绑定
/// </summary>
/// <param name="paramPageIndex"></param>
/// <param name="paramPageSize"></param>
public void BindGrid(int paramPageIndex, int paramPageSize)
{
//开始时间
string logStartTime = txtLogStartTime.Value.ToString();
//结束时间
string logEndTime = txtLogEndTime.Value.ToString();
XMNick nick = XMNickService.GetXMNickByID(this.NickID);
//平台类型
int PlatformTypeId = 0;
List <XMNickAchieveValue> newList;
if (nick != null)
{
PlatformTypeId = nick.PlatformTypeId.Value;
var list = base.XMNickAchieveValueService.GetXMNickAchieveValueList();
newList = list.Where(p => p.NickId == this.NickID &&
(p.DateTime.Date >= DateTime.Parse(logStartTime) && p.DateTime.Date <= DateTime.Parse(logEndTime))
).ToList();
var pageList = new PagedList <XMNickAchieveValue>(newList, paramPageIndex, paramPageSize, this.Master.GridViewSortField, this.Master.GridViewSortDir.ToString());
if (this.RowEditIndex == -1)
{
this.gvNickTitle.EditIndex = pageList.Count();
//添加新增行
pageList.Add(new XMNickAchieveValue());
}
else
{
this.gvNickTitle.EditIndex = this.RowEditIndex;
}
this.Master.BindData(this.gvNickTitle, pageList, paramPageSize + 1);
}
}
protected void gvNick_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int nickId = 0;
int.TryParse(this.gvNick.DataKeys[e.RowIndex].Value.ToString(), out nickId);
var row = this.gvNick.Rows[e.RowIndex];
var txtNick = row.FindControl("txtNick") as TextBox;
var lblNick = row.FindControl("lblNick") as Label;
var chkIsEnable = row.FindControl("chkIsEnable") as CheckBox;
var ddlPlatFormType = row.FindControl("ddlPlatformTypeId") as DropDownList;
int projectId = 0;
int platFormTypeID = Convert.ToInt16(ddlPlatFormType.SelectedValue.ToString());
if (this.ProjectId == -1)
{
var ddProjectId = row.FindControl("ddProjectId") as DropDownList; //项目名称
projectId = int.Parse(ddProjectId.SelectedValue.Trim()); //项目id
}
else
{
projectId = this.ProjectId;
}
//判断店铺名称不能为空
if (txtNick.Text.Equals(""))
{
base.ShowMessage("店铺名称不能为空");
return;
}
if (nickId == 0) //新增
{
List <XMNick> nickList = base.XMNickService.GetXMNickListByNick(txtNick.Text.Trim()).Where(p => p.PlatformTypeId == platFormTypeID).ToList();
if (nickList != null && nickList.Count > 0)
{
base.ShowMessage("该店铺名称已存在,请选择其他平台");
return;
}
else
{
XMNick nick = new XMNick();
nick.nick = txtNick.Text.Trim();
nick.isEnable = chkIsEnable.Checked;
nick.ProjectId = projectId; //项目Id
nick.createPerson = HozestERPContext.Current.User.SCustomerInfo.FullName;
nick.createTime = DateTime.Now;
nick.updateTime = DateTime.Now;
nick.updatePerson = HozestERPContext.Current.User.SCustomerInfo.FullName;
nick.PlatformTypeId = int.Parse(ddlPlatFormType.SelectedValue.Trim());
base.XMNickService.InsertXMNick(nick);
}
}
else
{
//更新这条数据
var nick = base.XMNickService.GetXMNickByID(nickId);
if (nick != null)
{
nick.nick = txtNick.Text.Trim();
nick.isEnable = chkIsEnable.Checked; //是否在运营
nick.ProjectId = projectId; //项目Id
nick.updatePerson = HozestERPContext.Current.User.SCustomerInfo.FullName;
nick.updateTime = DateTime.Now;
nick.PlatformTypeId = int.Parse(ddlPlatFormType.SelectedValue.Trim());
base.XMNickService.UpdateXMNick(nick);
}
}
this.RowEditIndex = -1;
this.BindGrid(this.Master.PageIndex, this.Master.PageSize);
}
/// <summary>
/// 记录行 操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gvNickTitle_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int Id = 0;
decimal param = 0;
int Iprmam = 0;
int.TryParse(this.gvNickTitle.DataKeys[e.RowIndex].Value.ToString(), out Id);
var row = this.gvNickTitle.Rows[e.RowIndex];
#region 字符验证
var txtLogTime = row.FindControl("txtLogTime") as HtmlInputText;
var hfLogTime = row.FindControl("hfLogTime") as HiddenField;
var txtArriveSalesNum = row.FindControl("txtArriveSalesNum") as TextBox;
var lblArriveSalesNum = row.FindControl("lblArriveSalesNum") as Label;
lblArriveSalesNum.Text = "";
if (!int.TryParse(txtArriveSalesNum.Text.Trim(), out Iprmam))
{
if (txtArriveSalesNum.Text.Trim() != "")
{
lblArriveSalesNum.Text = "请输入正确的数值";
}
}
var txtArriveSalesMoney = row.FindControl("txtArriveSalesMoney") as TextBox;
var lblArriveSalesMoney = row.FindControl("lblArriveSalesMoney") as Label;
lblArriveSalesMoney.Text = "";
if (!decimal.TryParse(txtArriveSalesMoney.Text.Trim(), out param))
{
if (txtArriveSalesMoney.Text.Trim() != "")
{
lblArriveSalesMoney.Text = "输入正确的数值";
}
}
var txtNickPerTicketSales = row.FindControl("txtNickPerTicketSales") as TextBox;
var lblNickPerTicketSales = row.FindControl("lblNickPerTicketSales") as Label;
lblNickPerTicketSales.Text = "";
if (!decimal.TryParse(txtNickPerTicketSales.Text.Trim(), out param))
{
if (txtNickPerTicketSales.Text.Trim() != "")
{
lblNickPerTicketSales.Text = "请输入正确的数值";
}
}
var txtCost = row.FindControl("txtCost") as TextBox;
var lblCost = row.FindControl("lblCost") as Label;
lblCost.Text = "";
if (!decimal.TryParse(txtCost.Text.Trim(), out param))
{
if (txtCost.Text.Trim() != "")
{
lblCost.Text = "请输入正确的数值";
}
}
if (lblArriveSalesNum.Text != "" || lblArriveSalesMoney.Text != "" ||
lblNickPerTicketSales.Text != "")
{
return;
}
if (string.IsNullOrEmpty(txtLogTime.Value.ToString()))
{
base.ShowMessage("日期不能为空");
return;
}
#endregion
XMNickAchieveValue nickAchieveValue = base.XMNickAchieveValueService.GetXMNickAchieveValueById(Id);
int platformTypeId = 0;
XMNick nick = base.XMNickService.GetXMNickByID(this.NickID);
if (nick != null)
{
int.TryParse(nick.PlatformTypeId.ToString(), out platformTypeId);
}
//int count = base.XMNickAchieveValueService.GetXMNickAchieveValueListAll(this.NickID, Convert.ToDateTime(txtLogTime.Value.ToString()));
//if (count > 0)
//{
// base.ShowMessage("该日期下的数据已经存在！");
// return;
//}
//修改 目标设定
if (nickAchieveValue != null)
{
if (txtLogTime.Value.Equals(hfLogTime.Value))
{
nickAchieveValue.DateTime = DateTime.Parse(txtLogTime.Value.ToString());
nickAchieveValue.SaleCount = Convert.ToInt32(txtArriveSalesNum.Text.Trim());
nickAchieveValue.SalePrice = Convert.ToDecimal(txtArriveSalesMoney.Text.Trim());
nickAchieveValue.Cost = Convert.ToDecimal(txtCost.Text.Trim());
nickAchieveValue.GuestUnitPrice = Convert.ToDecimal(txtNickPerTicketSales.Text.Trim());
nickAchieveValue.Updater = HozestERPContext.Current.User.SCustomerInfo.CustomerID;
nickAchieveValue.UpdateDate = DateTime.Now;
base.XMNickAchieveValueService.UpdateXMNickAchieveValue(nickAchieveValue);
}
else
{
int count = base.XMNickAchieveValueService.GetXMNickAchieveValueListAll(this.NickID, Convert.ToDateTime(txtLogTime.Value.ToString()));
if (count > 0)
{
base.ShowMessage("该日期下的数据已经存在！");
return;
}
else
{
nickAchieveValue.DateTime = DateTime.Parse(txtLogTime.Value.ToString());
nickAchieveValue.SaleCount = Convert.ToInt32(txtArriveSalesNum.Text.Trim());
nickAchieveValue.SalePrice = Convert.ToDecimal(txtArriveSalesMoney.Text.Trim());
nickAchieveValue.Cost = Convert.ToDecimal(txtCost.Text.Trim());
nickAchieveValue.GuestUnitPrice = Convert.ToDecimal(txtNickPerTicketSales.Text.Trim());
nickAchieveValue.Updater = HozestERPContext.Current.User.SCustomerInfo.CustomerID;
nickAchieveValue.UpdateDate = DateTime.Now;
base.XMNickAchieveValueService.UpdateXMNickAchieveValue(nickAchieveValue);
}
}
}
//新增目标设定
else
{
int count = base.XMNickAchieveValueService.GetXMNickAchieveValueListAll(this.NickID, Convert.ToDateTime(txtLogTime.Value.ToString()));
if (count > 0)
{
base.ShowMessage("该日期下的数据已经存在！");
return;
}
else
{
XMNickAchieveValue nickAchieveValueAdd = new XMNickAchieveValue();
nickAchieveValueAdd.DateTime = DateTime.Parse(txtLogTime.Value.ToString());
nickAchieveValueAdd.NickId = this.NickID;
nickAchieveValueAdd.SaleCount = Convert.ToInt32(txtArriveSalesNum.Text.Trim());
nickAchieveValueAdd.SalePrice = Convert.ToDecimal(txtArriveSalesMoney.Text.Trim());
nickAchieveValueAdd.Cost = Convert.ToDecimal(txtCost.Text.Trim());
nickAchieveValueAdd.GuestUnitPrice = Convert.ToDecimal(txtNickPerTicketSales.Text.Trim());
nickAchieveValueAdd.IsEnable = false;//默认可用
nickAchieveValueAdd.CreateID = HozestERPContext.Current.User.SCustomerInfo.CustomerID;
nickAchieveValueAdd.CreateDate = DateTime.Now;
nickAchieveValueAdd.Updater = HozestERPContext.Current.User.SCustomerInfo.CustomerID;
nickAchieveValueAdd.UpdateDate = DateTime.Now;
base.XMNickAchieveValueService.InsertXMNickAchieveValue(nickAchieveValueAdd);
}
}
this.RowEditIndex = -1;
this.BindGrid(this.Master.PageIndex, this.Master.PageSize);
}
