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