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