/// <summary>
/// 绑定到货箱信息列表
/// </summary>
protected void BindGrid()
{
BArrangeBillBB arrangeBillBB = new BArrangeBillBB();
try
{
DataSet ds = new DataSet();
ds = arrangeBillBB.ArrangedBoxInfoReport(this.tbBoxNo.Text.Trim().ToUpper(), this.tbMaterial.Text.Trim().ToUpper(),
this.tbPalletNo.Text.Trim().ToUpper(), this.ddlWare.SelectedValue, this.ddlWareLocator.SelectedValue,
this.tbArriveBillNo.Text.Trim(), this.tbFinanceBillNo.Text.Trim(), this.ddlIsOutStock.SelectedValue);
this.grid.DataSource = ds.Tables[0];
this.grid.DataBind();
//赋值记录条数、页面总数
this.Label3.Text = ds.Tables[0].Rows.Count.ToString();
this.Label2.Text = this.grid.PageCount.ToString();
this.currPage.Text = (this.grid.PageIndex + 1).ToString();
}
finally
{
arrangeBillBB.Dispose();
}
}
/// <summary>
/// 删除排拖单明细
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gridDetail_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
BArrangeBillBB arrangeBillBB = new BArrangeBillBB();
try
{
string rowid = this.gridDetail.DataKeys[e.RowIndex].Values["rowId"].ToString();//标志
string arrangeBillNo = this.gridDetail.DataKeys[e.RowIndex].Values["arrangeBillNo"].ToString();//标志
BArrangeBillData arrangeBillModel = new BArrangeBillData();
DataRow[] myDataRowArray_Result = null;
//根据rowid查找排托明细
myDataRowArray_Result = this.DtResult.Select("rowid='" + rowid + "'");
if (myDataRowArray_Result.Length > 0)
{
//更改删除标志
myDataRowArray_Result[0]["isdel"] = "1";//删除
myDataRowArray_Result[0]["boxNum"] = 0;
//判断排托单是否已经提交
arrangeBillModel = arrangeBillBB.GetModel(arrangeBillNo);
if (arrangeBillModel != null && arrangeBillModel.instantState != "01")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('已提交数据不允许删除！');", true);
return;
}
}
}
catch (Exception ex)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true);
return;
}
finally
{
this.BindDetailTable();//绑定排托明细列表
this.SaveStencilDetailViewState();//保存
this.BindGrid();//绑定到货明细列表
arrangeBillBB.Dispose();
}
}
/// <summary>
/// 保存或保存并提交公共方法
/// </summary>
/// <param name="isSubmit"></param>
protected void SubmitArrangeBill(bool isSubmit)
{
this.SaveStencilDetailViewState();//保存
if (this.ValidateArrangeDetail())
{
BArrangeBillBC arrangeBillBC = new BArrangeBillBC();
BArrangeBillBB arrangeBillBB = new BArrangeBillBB();
try
{
BArrangeBillData data = arrangeBillBB.GetModel("PT" + this.ArriveBillNo);
if (data == null)
{
data = new BArrangeBillData();
data.arrangeBillNo = "PT" + this.ArriveBillNo;
data.id = 0;
data.isrtDt = DateTime.Now.ToString();
data.isrtEmpId = this.currentUser.empId;
data.arriveBillNo = this.ArriveBillNo;
if (isSubmit)
{
data.instantState = "02";
data.commitDt = DateTime.Now.ToString();
data.commitEmpId = this.currentUser.empId;
}
else
{
data.instantState = "01";
data.updtDt = DateTime.Now.ToString();
data.updtEmpId = this.currentUser.empId;
}
}
else
{
if (data.instantState != "01")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert9", "alert(\"当前排拖单已经提交,无法修改！\");", true);
return;
}
data.updtDt = DateTime.Now.ToString();
data.updtEmpId = this.currentUser.empId;
if (isSubmit)
{
data.instantState = "02";
data.commitDt = DateTime.Now.ToString();
data.commitEmpId = this.currentUser.empId;
}
else
{
data.instantState = "01";
data.updtDt = DateTime.Now.ToString();
data.updtEmpId = this.currentUser.empId;
}
}
if (arrangeBillBC.SaveBArrangeBill(data, this.DtResult, isSubmit))
{
this.DtResult = null;
this.InitData();
this.BindDetailTable();//绑定排托明细列表
this.BindGrid();//绑定到货明细列表
if (isSubmit)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert12", "alert(\"排拖单提交成功！\");" + (isSubmit ? "location.replace('../BArriveBill/BArriveBillList.aspx?&itemno=" + this.itemNo + "&pTypeNo=main');" : ""), true);
}
else
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert12", "alert(\"排拖单维护成功！\");", true);
}
}
else
{
this.BindDetailTable();//绑定排托明细列表
this.BindGrid();//绑定到货明细列表
this.ClientScript.RegisterStartupScript(this.GetType(), "alert12", "alert(\"排拖单维护失败！\");", true);
}
}
catch (Exception ex)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true);
return;
}
finally
{
arrangeBillBB.Dispose();
arrangeBillBC.Dispose();
}
}
}
