public static YKBoxInfo GetBoxByHu(string hu) { string sql = string.Format(@"SELECT * FROM dbo.YKBox WHERE Hu = '{0}' AND Status = 'S' SELECT * FROM dbo.YKBoxDetail WHERE Hu = '{0}'", hu); DataSet ds = DBHelper.GetDataSet(sql, false); YKBoxInfo result = null; if (ds?.Tables?.Count == 2) { DataTable dtMain = ds.Tables[0]; DataTable dtDetail = ds.Tables[1]; if (dtMain.Rows.Count > 0) { result = YKBoxInfo.BuildBoxInfo(dtMain.Rows[0]); if (dtDetail.Rows.Count > 0) { foreach (DataRow row in dtDetail.Rows) { result.Details.Add(YKBoxDetailInfo.BuildBoxDetailInfo(row)); } } } } return(result); }
public static List <YKBoxInfo> GetUnHandoverBoxList(string device) { List <YKBoxInfo> result = new List <YKBoxInfo>(); string sql = string.Format(@"SELECT * FROM dbo.YKBox WHERE EquipXindeco = '{0}' AND IsHandover = 0 AND Status='S' SELECT * FROM dbo.YKBoxDetail WHERE Hu IN (SELECT Hu FROM dbo.YKBox WHERE EquipXindeco = '{0}' AND IsHandover = 0 AND Status='S') ", device); DataSet ds = DBHelper.GetDataSet(sql, false); if (ds != null && ds.Tables.Count == 2) { result = new List <YKBoxInfo>(); DataTable dtBox = ds.Tables[0]; DataTable dtDetail = ds.Tables[1]; if (dtBox != null && dtBox.Rows.Count > 0) { foreach (DataRow row in dtBox.Rows) { YKBoxInfo item = YKBoxInfo.BuildBoxInfo(row); DataRow[] rowsDetail = dtDetail.Select(string.Format("Hu ='{0}'", item.Hu)); if (rowsDetail.Length > 0) { foreach (DataRow rowdetail in rowsDetail) { YKBoxDetailInfo detail = YKBoxDetailInfo.BuildBoxDetailInfo(rowdetail); item.Details.Add(detail); } } result.Add(item); } } } return(result); }