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