private void ItemSearch() { dgvItem.Rows.Clear(); DataGridViewRowCollection rows = dgvItem.Rows; InventoryInfo view = new InventoryInfo(APConfig.Conn); view.Conditions = " 1=1 "; view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.status.ToString(), InventoryStatus.庫存中.ToString()); if (!string.IsNullOrEmpty(txtName.Text)) { view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.LKverdor.ToString(), txtName.Text); } if (!string.IsNullOrEmpty(txtType.Text)) { view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.LKtype.ToString(), txtType.Text); } if (!string.IsNullOrEmpty(sernolist)) { view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.NINsernolist.ToString(), sernolist); } view.OrderBy = string.Format("{0} , {1}", view.getOptionOrderBy(InventoryInfo.ncOrderBy.ODBverdor.ToString()), view.getOptionOrderBy(InventoryInfo.ncOrderBy.ODBmodifydttm.ToString())); view.load(); while (!view.IsEof) { rows.Add(new Object[] { view.INV_SERNO, view.INV_VENDOR, view.INV_NAME, view.INV_TYPE, view.INV_COLOR, view.INV_INAMT, view.INV_INDTTM.ToShortDateString() }); view.next(); } }
private void ItemSearch() { dgvItem.Rows.Clear(); DataGridViewRowCollection rows = dgvItem.Rows; InventoryInfo view = new InventoryInfo(APConfig.Conn); int totalamount = 0; view.Conditions = " 1=1 "; view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.status.ToString(), InventoryStatus.寄庫品.ToString()); if (!string.IsNullOrEmpty(txtName.Text)) { view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.LKname.ToString(), txtName.Text); } if (!string.IsNullOrEmpty(sernolist)) { view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.NINsernolist.ToString(), sernolist); } view.OrderBy = view.getOptionOrderBy(InventoryInfo.ncOrderBy.ODBname.ToString()); view.load(); while (!view.IsEof) { rows.Add(new Object[] { view.INV_SERNO, view.INV_NAME, view.INV_POSTAMT, view.INV_POSTDTTM.ToShortDateString() }); totalamount += view.INV_POSTAMT; view.next(); } lblTotalCount.Text = string.Format("總件數:{0}", view.calculateCount()); lblTotalAmt.Text = string.Format("總金額:{0}", totalamount); }
private void loadData() { dgvInventory.Rows.Clear(); string info = ""; DataGridViewRowCollection rows = dgvInventory.Rows; InventoryInfo view = new InventoryInfo(APConfig.Conn); view.Conditions = " 1=1 "; view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.sernolist.ToString(), sernolist); view.OrderBy = view.getOptionOrderBy(InventoryInfo.ncOrderBy.ODBcode.ToString()); view.load(); while (!view.IsEof) { if (string.IsNullOrEmpty(view.INV_CODE)) { info = string.Format("寄庫品( 寄庫金額:{0:n0}元 / 寄庫時間:{1} )", view.INV_POSTAMT, view.INV_POSTDTTM.ToShortDateString()); rows.Add(new Object[] { view.INV_SERNO, view.INV_STATUS, true, info }); } else { rows.Add(new Object[] { view.INV_SERNO, view.INV_STATUS, true, view.INV_CODE }); } view.next(); } }
private void loadData() { if (tabControl1.SelectedIndex == 0) { dgvItem.Rows.Clear(); DataGridViewRowCollection rows = dgvItem.Rows; InventoryInfo view = new InventoryInfo(APConfig.Conn); view.Conditions = " 1=1 "; view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.status.ToString(), InventoryStatus.庫存中.ToString()); if (!string.IsNullOrEmpty(txtCode.Text)) { view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.LKcode.ToString(), txtCode.Text); } if (!string.IsNullOrEmpty(txtName.Text)) { view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.LKname.ToString(), txtName.Text); } if (!string.IsNullOrEmpty(sernolist)) { view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.NINsernolist.ToString(), sernolist); } view.load(); while (!view.IsEof) { rows.Add(new Object[] { view.INV_SERNO, view.INV_CODE }); view.next(); } } else if (tabControl1.SelectedIndex == 1) { dgvPost.Rows.Clear(); DataGridViewRowCollection rows = dgvPost.Rows; InventoryInfo view = new InventoryInfo(APConfig.Conn); view.Conditions = " 1=1 "; view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.status.ToString(), InventoryStatus.寄庫品.ToString()); if (!string.IsNullOrEmpty(txtCode.Text)) { view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.LKcode.ToString(), txtCode.Text); } if (!string.IsNullOrEmpty(txtName.Text)) { view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.LKname.ToString(), txtName.Text); } if (!string.IsNullOrEmpty(sernolist)) { view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.NINsernolist.ToString(), sernolist); } view.OrderBy = view.getOptionOrderBy(InventoryInfo.ncOrderBy.ODBname.ToString()); view.load(); while (!view.IsEof) { rows.Add(new Object[] { view.INV_SERNO, view.INV_NAME, view.INV_POSTAMT, view.INV_POSTDTTM.ToShortDateString() }); view.next(); } } }
private void loadData() { dgvInventory.Rows.Clear(); string info = ""; DataGridViewRowCollection rows = dgvInventory.Rows; InventoryInfo view = new InventoryInfo(APConfig.Conn); view.Conditions = " 1=1 "; view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.sernolist.ToString(), sernolist); view.load(); while (!view.IsEof) { rows.Add(new Object[] { view.INV_SERNO, true, view.INV_STATUS, view.INV_VENDOR, view.INV_NAME, view.INV_TYPE, view.INV_COLOR, view.INV_SIZE }); view.next(); } }
private void loadData() { dgvItem.Rows.Clear(); string info = ""; DataGridViewRowCollection rows = dgvItem.Rows; InventoryInfo view = new InventoryInfo(APConfig.Conn); view.Conditions = " 1=1 "; view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.sernolist.ToString(), sernolist); view.OrderBy = view.getOptionOrderBy(InventoryInfo.ncOrderBy.ODBstatus.ToString()); view.load(); while (!view.IsEof) { rows.Add(new Object[] { view.INV_SERNO, view.INV_STATUS, view.INV_VENDOR, view.INV_NAME, view.INV_INAMT, view.INV_INDTTM.ToShortDateString(), view.INV_OUTAMT, view.INV_OUTDTTM.ToShortDateString() }); view.next(); } }
private void ItemSearch() { dgvItem.Rows.Clear(); DataGridViewRowCollection rows = dgvItem.Rows; InventoryInfo view = new InventoryInfo(APConfig.Conn); view.Conditions = " 1=1 "; view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.status.ToString(), InventoryStatus.庫存中.ToString()); if (!string.IsNullOrEmpty(txtName.Text)) { view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.LKcode.ToString(), txtName.Text); } if (!string.IsNullOrEmpty(sernolist)) { view.Conditions += " AND " + view.getCondition(InventoryInfo.ncConditions.NINsernolist.ToString(), sernolist); } view.OrderBy = view.getOptionOrderBy(InventoryInfo.ncOrderBy.ODBcode.ToString()); view.load(); while (!view.IsEof) { rows.Add(new Object[] { view.INV_SERNO, view.INV_CODE }); view.next(); } }