/// <summary>
/// 绑定明细模版
/// </summary>
protected void BindDetailTable()
{
#region 绑定明细模版
if (DtResult == null)
{
BArrangeBillDetailBB arrangeBillDetailBB = new BArrangeBillDetailBB();
try
{
string strwhere = "arriveBillNo=@arriveBillNo";
SqlParameter[] param = new SqlParameter[] { new SqlParameter("arriveBillNo", IdValue) };
DataSet ds = arrangeBillDetailBB.GetVList(strwhere, param);
if (ds != null && ds.Tables.Count > 0)
{
this.DtResult = ds.Tables[0];
#region 添加合计行
//DataRow drHJ = this.DtResult.NewRow();
//drHJ["id"] = -1;
//drHJ["materielNo"] = "合计：";
//this.DtResult.Rows.Add(drHJ);
#endregion
this.DtResult.Columns.Add(new DataColumn("rowId", typeof(string)));
this.DtResult.Columns.Add(new DataColumn("isdel", typeof(string)));
this.DtResult.Columns.Add(new DataColumn("ischeck", typeof(string)));
this.DtResult.Columns.Add(new DataColumn("hideAmount", typeof(string)));
foreach (DataRow dr in this.DtResult.Rows)
{
dr["rowId"] = Guid.NewGuid().ToString();
dr["isdel"] = "0";
dr["ischeck"] = "false";
#region 记录合计行
if (dr["boxNum"] != null && dr["boxNum"] != DBNull.Value)
{
//初始化时保存amount的原始值
dr["hideAmount"] = dr["boxNum"].ToString() == "" ? "0" : dr["boxNum"].ToString();
}
else
{
dr["hideAmount"] = "0";
}
#endregion
}
}
}
catch (Exception ex)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",4);", true);
return;
}
finally
{
arrangeBillDetailBB.Dispose();
}
}
DataView dv = this.DtResult.DefaultView;
dv.RowFilter = "isdel=0";
dv.Sort = "palletIndex";
this.GridView1.DataSource = dv;
this.GridView1.DataBind();
HS.Function.CommFunction.MergeCol(GridView1, 1);
HS.Function.CommFunction.MergeColRefer(GridView1, 0, 1);
HS.Function.CommFunction.MergeColRefer(GridView1, 2, 1);
#endregion
}
public DataTable GetArrangeBillDetail_Region(string strArriveBillNo, string strPalletIndex, int region)
{
BArrangeBillDetailBB arrangeBillDetailBB = new BArrangeBillDetailBB();
try
{
DataTable dt = new DataTable();
dt = arrangeBillDetailBB.GetVList("arriveBillNo='" + strArriveBillNo
+ "' and palletIndex='" + strPalletIndex + "' and region=" + region.ToString()).Tables[0];
return dt;
}
finally
{
arrangeBillDetailBB.Dispose();
}
}
/// <summary>
/// 初始化数据
/// </summary>
private void InitData()
{
BArriveDetailBB arriveDetailBB = new BArriveDetailBB();
BArrangeBillDetailBB arrangeBillDetailBB = new BArrangeBillDetailBB();
try
{
#region 生成到货明细数据源
//到货明细
this.DtDetail = arriveDetailBB.GetVList(" arriveBillNo='" + this.ArriveBillNo + "'").Tables[0];
#endregion 生成到货明细数据源
#region 生成排托明细数据源
//排托明细
string strWhere = "arriveBillNo=@arriveBillNo";
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@arriveBillNo", this.ArriveBillNo) };
DataSet ds = arrangeBillDetailBB.GetVList(strWhere, param);
if (ds != null && ds.Tables.Count > 0)
{
this.DtResult = ds.Tables[0];
this.DtResult.Columns.Add(new DataColumn("rowId", typeof(string)));
this.DtResult.Columns.Add(new DataColumn("isdel", typeof(string)));
this.DtResult.Columns.Add(new DataColumn("ischeck", typeof(string)));
this.DtResult.Columns.Add(new DataColumn("hideAmount", typeof(string)));
foreach (DataRow dr in this.DtResult.Rows)
{
dr["rowId"] = Guid.NewGuid().ToString();
dr["isdel"] = "0";
dr["ischeck"] = "false";
#region 记录合计行
if (dr["boxNum"] != null && dr["boxNum"] != DBNull.Value)
{
//初始化时保存amount的原始值
dr["hideAmount"] = dr["boxNum"].ToString() == "" ? "0" : dr["boxNum"].ToString();
}
else
{
dr["hideAmount"] = "0";
}
#endregion
}
}
#endregion 生成排托明细数据源
}
finally
{
arriveDetailBB.Dispose();
arrangeBillDetailBB.Dispose();
}
}
public DataTable GetArrangeBillDetail(string strArriveBillNo, string strPalletIndex)
{
BArrangeBillDetailBB arrangeBillDetailBB = new BArrangeBillDetailBB();
try
{
DataTable dt = new DataTable();
dt = arrangeBillDetailBB.GetVList("arriveBillNo='" + strArriveBillNo + "' and palletIndex='" + strPalletIndex + "'").Tables[0];
return dt;
}
finally
{
arrangeBillDetailBB.Dispose();
}
}