/// <summary> /// 加载超过库存的物料列表 /// </summary> /// <param name="lst"></param> public void ShowFillData(List <YJMaterialStorage> lst) { gridControl1.DataSource = IniBindTable(); YJMaterialStorage YJMaterialStorage = new YJMaterialStorage(); //得到料件的信息 for (int i = 0; i < lst.Count; i++) { YJMaterialStorage = lst[i] as YJMaterialStorage; //填充数据 gridView1.AddNewRow(); gridView1.SetFocusedRowCellValue(gridMaterialID, YJMaterialStorage.MaterialID); gridView1.SetFocusedRowCellValue(gridMaterialName, YJMaterialStorage.MaterialName); gridView1.SetFocusedRowCellValue(gridMaterialSum, YJMaterialStorage.MaterialSum.ToString("g0")); gridView1.SetFocusedRowCellValue(gridStorageSum, YJMaterialStorage.StorageSum.ToString("g0")); gridView1.SetFocusedRowCellValue(gridStorageName, YJMaterialStorage.StorageName); } this.ShowDialog(); }
//------------------------------------------------------------ //判断当前需要出库的数量是否已经超过库存数量,如果超过则返回False public List <YJMaterialStorage> IsOverStorageNum() { List <YJMaterialStorage> lst = new List <YJMaterialStorage>(); YJMaterialStorage YJMaterialStorage = new YJMaterialStorage(); for (int i = 0; i < gridView1.RowCount; i++) { DataRowView dr = (DataRowView)(gridView1.GetRow(i)); string strMaterialGuid = dr["MaterialGuID"].ToString(); string strMaterialID = dr["MaterialID"].ToString(); string strMaterialName = dr["MaterialName"].ToString(); //得到当前料件在指定仓库中的数量 DataTable dtl = MaterialManage.sp_GetOneStorageSumData(txtOutStorage.Tag.ToString(), strMaterialGuid); if (dtl.Rows.Count > 0) { decimal decMaterialSum = 0; //库存中有数量,当前数量与库存中的比较,如果当前数量大于库存中的数量,则给出提示 if (dr["MaterialSum"].ToString().Trim() != "") { decMaterialSum = decimal.Parse(dr["MaterialSum"].ToString()); } decimal decStorageSum = decimal.Parse(dtl.Rows[0]["StorageSum"].ToString()); if (decMaterialSum > decStorageSum) { YJMaterialStorage = new YJMaterialStorage(); YJMaterialStorage.MaterialID = strMaterialID; YJMaterialStorage.MaterialName = strMaterialName; YJMaterialStorage.MaterialSum = decMaterialSum; YJMaterialStorage.StorageSum = decStorageSum; YJMaterialStorage.StorageName = txtOutStorage.Text; lst.Add(YJMaterialStorage); } } } return(lst); }