/// <summary> /// 获取未生成交接单的箱主信息和明细信息 /// </summary> /// <returns></returns> public static List <PBBoxInfo> GetUnGenerateBoxListWithDetail() { List <PBBoxInfo> result = null; string sql = @"SELECT * FROM dbo.PBBox WHERE IsGenerate=0 SELECT * FROM dbo.PBBoxDetail WHERE HU IN(SELECT HU FROM dbo.PBBox WHERE IsGenerate = 0)"; DataSet ds = DBHelper.GetDataSet(sql, false); if (ds != null && ds.Tables.Count == 2) { DataTable dtBox = ds.Tables[0]; DataTable dtBoxDetail = ds.Tables[1]; if (dtBox.Rows.Count > 0) { result = new List <PBBoxInfo>(); foreach (DataRow row in dtBox.Rows) { PBBoxInfo item = PBBoxInfo.BuildPBBoxInfo(row); if (dtBoxDetail != null && dtBoxDetail.Rows.Count > 0) { DataRow[] detailRows = dtBoxDetail.Select(string.Format("HU='{0}'", item.HU)); if (detailRows != null && detailRows.Length > 0) { foreach (DataRow detailRow in detailRows) { item.Details.Add(PBBoxDetailInfo.BuildPBBoxDetailInfo(detailRow)); } } } result.Add(item); } } } return(result); }
public static PBBoxInfo GetBoxByHu(string hu) { PBBoxInfo result = new PBBoxInfo(); string sql = string.Format(@"select * from PBBox WHERE HU='{0}' SELECT * FROM PBBoxDetail WHERE HU = '{0}'", hu); DataSet ds = DBHelper.GetDataSet(sql, false); if (ds != null && ds.Tables.Count == 2) { DataTable boxTable = ds.Tables[0]; if (boxTable != null && boxTable.Rows.Count > 0) { result = PBBoxInfo.BuildPBBoxInfo(boxTable.Rows[0]); } else { return(null); } DataTable detailTable = ds.Tables[1]; if (detailTable != null && detailTable.Rows.Count > 0) { foreach (DataRow row in detailTable.Rows) { result.Details.Add(PBBoxDetailInfo.BuildPBBoxDetailInfo(row)); } } } return(result); }
/// <summary> /// 获取需要生成交接单的所有箱主信息 /// </summary> /// <returns></returns> public static List <PBBoxInfo> GetNeedGenerateBoxListWithoutDetail() { List <PBBoxInfo> result = null; string sql = @"SELECT * FROM dbo.PBBox WHERE IsGenerate=0"; DataTable dt = DBHelper.GetTable(sql, false); if (dt != null && dt.Rows.Count > 0) { result = new List <PBBoxInfo>(); foreach (DataRow row in dt.Rows) { PBBoxInfo item = PBBoxInfo.BuildPBBoxInfo(row); result.Add(item); } } return(result); }