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