/// <summary> /// 获得数据列表(比DataSet效率高,推荐使用) /// </summary> public List <VAN_OA.Model.EFrom.Tb_ExpInvs> GroupByListArray(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select InvNum , isnull(SumExpNum,0)as SumExpNum , InvNum-isnull(SumExpNum,0) as lastNum ,Tb_Inventory.Id from Tb_Inventory left join "); strSql.Append(" ( select InvId,sum(isnull(expNum,0))as SumExpNum from Tb_ExpInv_NoReurnInvView group BY InvId) "); strSql.Append("as newGroupExpInvNums on Tb_Inventory.Id=newGroupExpInvNums.InvId"); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } List <VAN_OA.Model.EFrom.Tb_ExpInvs> list = new List <VAN_OA.Model.EFrom.Tb_ExpInvs>(); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { while (dataReader.Read()) { Tb_ExpInvs model = new Tb_ExpInvs(); model.InvId = Convert.ToInt32(dataReader["Id"]); model.InvName = string.Format("小计:总数 {0} 借出 {1} 剩余 {2}", dataReader["InvNum"] + " ", dataReader["SumExpNum"] + " ", dataReader["lastNum"] + " "); model.ExpNum = Convert.ToDecimal(dataReader["lastNum"]); list.Add(model); } } } return(list); }
private void setValue(Tb_ExpInvs model) { ddlInvs.SelectedValue = model.InvId.ToString(); ddlExpState.SelectedValue = model.ExpState; txtExpNum.Text = model.ExpNum.ToString(); txtExpRemark.Text = model.ExpRemark; txtExpUse.Text = model.ExpUse; if (model.ReturnTime != null) { txtReturnTime.Text = model.ReturnTime.Value.ToString("yyyy-MM-dd"); } }
protected void gvList_RowEditing(object sender, GridViewEditEventArgs e) { if (ddlPers.Visible == false && lblOutState.Text != "已发货") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('必须先确认发货才能修改!');</script>"); return; } int index = e.NewEditIndex; ViewState["index"] = index; if (Session["ProInvs"] != null) { List <Tb_ExpInvs> projectInvsList = Session["ProInvs"] as List <Tb_ExpInvs>; Tb_ExpInvs model = projectInvsList[index]; setValue(model); btnAdd.Enabled = false; btnSave.Enabled = true; btnCancel.Enabled = true; ViewState["state"] = "edit"; } }
protected void btnSave_Click(object sender, EventArgs e) { if (ddlInvs.Text.Trim() == "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择货品!');</script>"); ddlInvs.Focus(); return; } try { Convert.ToDecimal(txtExpNum.Text); } catch (Exception) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('数量格式错误!');</script>"); txtExpNum.Focus(); return; } if (Convert.ToDecimal(txtExpNum.Text) <= 0) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写数量!');</script>"); txtExpNum.Focus(); return; } int InvId = int.Parse(ddlInvs.SelectedItem.Value); decimal ExpNum = decimal.Parse(this.txtExpNum.Text); string ExpUse = this.txtExpUse.Text; string ExpState = this.ddlExpState.Text; string ExpRemark = this.txtExpRemark.Text; VAN_OA.Model.EFrom.Tb_ExpInvs model = new VAN_OA.Model.EFrom.Tb_ExpInvs(); model.InvId = InvId; model.ExpNum = ExpNum; model.ExpUse = ExpUse; model.ExpState = ExpState; model.ExpRemark = ExpRemark; model.InvName = ddlInvs.SelectedItem.Text; if (txtResultRemark.Visible == true && txtReturnTime.Text != "") { try { model.ReturnTime = Convert.ToDateTime(txtReturnTime.Text); } catch (Exception) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('归还时间格式有误!');</script>"); txtResultRemark.Focus(); return; } } else { model.ReturnTime = null; } if (ViewState["state"] != null) { if (ViewState["state"].ToString() == "add") { List <Tb_ExpInvs> POOrders = Session["ProInvs"] as List <Tb_ExpInvs>; POOrders.Add(model); Session["ProInvs"] = POOrders; gvList.DataSource = POOrders; gvList.DataBind(); ddlInvs.SelectedIndex = -1; txtExpNum.Text = "0"; txtExpRemark.Text = ""; txtExpUse.Text = ""; ddlInvs.Focus(); ViewState["state"] = "add"; return; } if (ViewState["state"].ToString() == "edit" && ViewState["index"] != null) { int index = Convert.ToInt32(ViewState["index"]); if (Session["ProInvs"] != null) { List <Tb_ExpInvs> POOrders = Session["ProInvs"] as List <Tb_ExpInvs>; Tb_ExpInvs modelPro = POOrders[index]; model.Id = modelPro.Id; model.IfUpdate = true; POOrders[index] = model; Session["ProInvs"] = POOrders; gvList.DataSource = POOrders; gvList.DataBind(); } } } btnAdd.Enabled = true; btnSave.Enabled = false; btnCancel.Enabled = false; }