/// <summary>
/// 绑定Grid
/// </summary>
protected void BindGrid()
{
BArriveBillBB arriveBillBB = new BArriveBillBB();
try
{
string strWhere = this.StrWhere;
DataSet ds = new DataSet();
//到货通知单编号
if (txtBillNo.Text.Trim() != "")
{
strWhere += " and billNo like '%" + txtBillNo.Text.Replace("'", "''") + "%'";
}
//供应商
if (txtSupple.Text.Trim() != "")
{
strWhere += " and (custNo='" + txtSupple.Text.Replace("'", "''")
+ "' or custNm like '%" + txtSupple.Text.Replace("'", "''") + "%')";
}
//到货日期
if (this.beginDt.Text != "")
{
strWhere += " and arriveDt >='" + this.beginDt.Text.Trim() + "'";
}
if (this.endDt.Text != "")
{
strWhere += " and arriveDt <'" + Convert.ToDateTime(this.endDt.Text).AddDays(1).ToShortDateString() + "'";
}
//是否收货完成
if (this.ddlIsFinishReceive.SelectedValue != "")
{
if (this.ddlIsFinishReceive.SelectedValue == "1")//收货完成
{
strWhere += " and not exists(select 1 from dbo.BArriveDetail as t where t.arriveBillNo=dbo.vBArriveBill.billNo and t.isFinishReceive=0)";
}
else//未收货完成
{
strWhere += " and exists(select 1 from dbo.BArriveDetail as t where t.arriveBillNo=dbo.vBArriveBill.billNo and t.isFinishReceive=0)";
}
}
//只是获取生产订单的状态
ds = arriveBillBB.GetVListSC(strWhere);
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
{
arriveBillBB.Dispose();
}
}
/// <summary>
/// 生成排拖单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnPaiFact_Click(object sender, EventArgs e)
{
//获取选中的数据Id
foreach (GridViewRow gvrow in this.grid.Rows)
{
CheckBox chkId = (CheckBox)gvrow.FindControl("chkId");
if (chkId.Checked == true)
{
string strBillNo = "", strCustNm = "", strArriveDt = "", strSate = "";
strBillNo = chkId.ValidationGroup;
strCustNm = this.grid.DataKeys[gvrow.RowIndex].Values["custNm"].ToString();
strArriveDt = this.grid.DataKeys[gvrow.RowIndex].Values["arriveDt"].ToString();
//实时获取订单状态
using (BArriveBillBB billBB = new BArriveBillBB())
{
DataSet ds = billBB.GetVList(" billNo='" + strBillNo + "'");
if (ds.Tables[0].Rows.Count > 0)
{
strSate = ds.Tables[0].Rows[0]["instantState"].ToString();
}
}
//判断到货单明细是否全部完成
using (BArriveDetailBB arriveDetailBB = new BArriveDetailBB())
{
DataTable dtArriveDetail = arriveDetailBB.GetList("arriveBillNo='" + strBillNo + "'").Tables[0];
foreach (DataRow row in dtArriveDetail.Rows)
{
if (Convert.ToBoolean(row["isFinishReceive"]) == false)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"当前到货单未收货完成！\");", true);
return;
}
}
}
if (strSate != "03" && strSate != "04" && strSate != "05")
{
Response.Redirect("../BArriveDetail/BArriveDetailList.aspx?billNo=" + strBillNo
+ "&custnm=" + Server.UrlEncode(strCustNm) + "&arriveDt=" + Server.UrlEncode(strArriveDt) + "&itemNo=" + this.itemNo + "&pTypeNo=edit", false);
return;
}
else
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"订单流程已提交或已收货状态，不能修改信息！\");", true);
return;
}
}
}
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"请选择一条记录！\");", true);
return;
}
/// <summary>
/// 提交排托单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnCommit_Click(object sender, EventArgs e)
{
BArriveBillBB arriveBillBB = new BArriveBillBB();
BArrangeBillBC arrangeBillBC = new BArrangeBillBC();
try
{
//获取选中的数据Id
foreach (GridViewRow gvrow in this.grid.Rows)
{
CheckBox chkId = (CheckBox)gvrow.FindControl("chkId");
if (chkId.Checked == true)
{
string strBillNo = "", strSate = "";
DataSet ds = new DataSet();
strBillNo = chkId.ValidationGroup;
//实时获取到货单状态
ds = arriveBillBB.GetList(" billNo='" + strBillNo + "'");
if (ds.Tables[0].Rows.Count > 0)
{
strSate = ds.Tables[0].Rows[0]["instantState"].ToString();
}
if (strSate != "02")//当前到货单状态必须为“已生成排托单”
{
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"当前到货单未生成排托单、排托单已提交或已开始收货，不允许提交！\");", true);
return;
}
else
{
arrangeBillBC.CommitArrangeBill(strBillNo);//提交排托单
this.BindGrid();//重新绑定到货单列表
return;
}
}
}
this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"请选择一条记录！\");", true);
return;
}
finally
{
arriveBillBB.Dispose();
arrangeBillBC.Dispose();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.StrWhere = "1=1";
string id= Request.QueryString["id"];
BArriveDetailBB arriveDetailBB = new BArriveDetailBB();
BArriveBillBB arriveBillBB = new BArriveBillBB();
DataSet ds = new DataSet();
try
{
vBArriveBillData data = arriveBillBB.GetVModel(Convert.ToInt32(id));
this.IdValue = data.billNo;
this.StrWhere = " arriveBillNo='" + data.billNo + "'";
txtBillNo.Text = data.billNo;
txtSupple.Text = data.custNm;
txtarrageBillNo.Text = "PT" + data.billNo;
txtarriveDt.Text = Convert.ToDateTime(data.arriveDt).ToString("yyyy-MM-dd");
this.DtDetail = arriveDetailBB.GetVList(this.StrWhere).Tables[0];
}
finally
{
arriveDetailBB.Dispose();
}
this.BindGrid();
}
InitPageData();
}
public DataTable GetArriveBillList()
{
BArriveBillBB arriveBillBB = new BArriveBillBB();
try
{
DataTable dt = new DataTable();
dt = arriveBillBB.GetVList("instantState in ('03','04')").Tables[0];
return dt;
}
finally
{
arriveBillBB.Dispose();
}
}