/*แสดงข้อมูลใบเบิกสินค้าเพื่อส่งไปฝากขาย*/
private void ShowDgvProduct()
{
String a = "";
String whereQ = "";
receive.FrmNewReceive frm = new receive.FrmNewReceive();
if (StrPoId.Count != 0)
{
for (int j = 0; j < StrPoId.Count; j++)
{
String select = "select CQHeadId FROM CO_REQ_HEAD r " +
"where r.CQHeadId = '" + StrPoId[j] + "'";
String productid = Class.DBConnString.clsDB.QueryExecuteScalar(select).ToString();
if (j == 0)
{
a = "'" + StrPoId[j] + "'";
}
else
{
a += "," + "'" + StrPoId[j] + "'";
}
}
if (a != "")
{
a = " AND CO_REQ_HEAD.CQHeadId not in (" + a + ") ";
}
}
String StrFind = TbxFind.Text.Trim();
String sql = "SELECT top(20) CO_REQ_HEAD.CQHeadId,CO_REQ_HEAD.CQHeadDate,GrStockDetail.GrStockDetailLName,CO_REQ_HEAD.Total FROM CO_REQ_HEAD " +
"INNER JOIN GrStockDetail ON CO_REQ_HEAD.GrStockDetailId=GrStockDetail.GrStockDetailId WHERE CO_REQ_HEAD.ConfirmId='3' AND CO_REQ_HEAD.COStatusId='0' " +
"AND CO_REQ_HEAD.GrStockDetailId='" + Stock + "' " +
"AND CO_REQ_HEAD.CQHeadId LIKE '%" + StrFind + "%' " +
"" + a + " " +
"ORDER BY CO_REQ_HEAD.CQHeadDate DESC";
DgvProduct.DataSource = Class.DBConnString.clsDB.QueryDataTable(sql);
formatDgvPo();
foreach (DataGridViewRow row in DgvProduct.Rows)
{
foreach (var elm in list)
{
if (elm.Key == row.Cells[0].Value.ToString())
{
row.Cells[3].Value = Convert.ToDouble(row.Cells[3].Value) - elm.Value;
}
}
}
}
private void dgvHead_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1) { return; }
if (dgvHead.Rows[e.RowIndex].Cells[20].Value.ToString() + "" != "-")
{
if (dgvHead.Rows[e.RowIndex].Cells[6].Value.ToString() + "" != "")
{
receive.FrmNewReceive frm = new receive.FrmNewReceive(dgvHead.Rows[e.RowIndex].Cells[0].Value.ToString());
frm.ShowDialog();
if (frm.DialogResult == DialogResult.OK)
{
FindSearch();
}
}
else {
receive.FrmNewReceiveDep frm = new receive.FrmNewReceiveDep(dgvHead.Rows[e.RowIndex].Cells[0].Value.ToString());
frm.ShowDialog();
if (frm.DialogResult == DialogResult.OK)
{
dgvHead.DataSource = callHeadDep(FSearchDep());
formatDgvHead();
callGrid();
}
}
}
else {
if (dgvHead.Rows[e.RowIndex].Cells[6].Value.ToString() + "" != "")
{
receive.frmReceivePrice frm = new frmReceivePrice();
frm.setReceiveId = dgvHead.Rows[e.RowIndex].Cells[0].Value.ToString();
frm.ShowDialog();
}
else {
StockAsiaDrink.frmPriceReceiveAsiaDrink frm = new StockAsiaDrink.frmPriceReceiveAsiaDrink();
frm.setEditId = dgvHead.Rows[e.RowIndex].Cells[0].Value.ToString();
frm.ShowDialog();
}
}
}
private void dgvHead_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Down || e.KeyCode == Keys.Up)
{
if (dgvHead.Rows.Count > 0)
{
int a = 0;
if (e.KeyCode == Keys.Down)
{
a = (dgvHead.CurrentRow.Index + 1 > dgvHead.Rows.Count - 1) ? dgvHead.Rows.Count - 1 : dgvHead.CurrentRow.Index + 1;
}
if (e.KeyCode == Keys.Up)
{
a = (dgvHead.CurrentRow.Index - 1 < 0) ? 0 : dgvHead.CurrentRow.Index - 1;
}
try
{
callDgvDetail(dgvHead.Rows[a].Cells[0].Value.ToString());
if (dgvDetail.Rows.Count < 1)
{
dgvDetail.DataSource = null;
dgvWeight.DataSource = null;
return;
}
if (dgvDetail.Rows[0].Cells[17].Value.ToString() + "" != "")
{
callDgvWeight(dgvDetail.Rows[0].Cells[1].Value.ToString(), dgvDetail.Rows[0].Cells[17].Value.ToString(), dgvDetail.Rows[0].Cells["ProductId"].Value.ToString());
}
else
{
callDgvWeightProduct(dgvDetail.Rows[0].Cells[1].Value.ToString(), dgvDetail.Rows[0].Cells[4].Value.ToString(), dgvDetail.Rows[0].Cells["ProductId"].Value.ToString());
}
}
catch { }
}
}
if (e.KeyCode == Keys.Enter)
{
if (dgvHead.Rows.Count > 0)
{
dgvHead.Select();
dgvHead.CellClick += new DataGridViewCellEventHandler(dgvHead_CellClick);
if (dgvHead.CurrentRow.Cells[20].Value.ToString() + "" != "-")
{
receive.FrmNewReceive frm = new receive.FrmNewReceive(dgvHead.CurrentRow.Cells[0].Value.ToString());
frm.Show();
}
else
{
receive.frmReceivePrice frm = new frmReceivePrice();
frm.setReceiveId = dgvHead.CurrentRow.Cells[0].Value.ToString();
frm.ShowDialog();
}
}
}
}
private void txtreceive_KeyUp(object sender, KeyEventArgs e)
{
FindSearch2();
if (e.KeyCode == Keys.Enter)
{
try
{
if (dgvHead.CurrentRow.Cells[20].Value.ToString() + "" != "-")
{
if (dgvHead.CurrentRow.Cells[6].Value.ToString() + "" != "")
{
receive.FrmNewReceive frm = new receive.FrmNewReceive(dgvHead.CurrentRow.Cells[0].Value.ToString());
frm.Show();
}
else
{
receive.FrmNewReceiveDep frm = new receive.FrmNewReceiveDep(dgvHead.CurrentRow.Cells[0].Value.ToString());
frm.Show();
}
}
else
{
if (dgvHead.CurrentRow.Cells[6].Value.ToString() + "" != "")
{
receive.frmReceivePrice frm = new frmReceivePrice();
frm.setReceiveId = dgvHead.CurrentRow.Cells[0].Value.ToString();
frm.ShowDialog();
}
else
{
StockAsiaDrink.frmPriceReceiveAsiaDrink frm = new StockAsiaDrink.frmPriceReceiveAsiaDrink();
frm.setEditId = dgvHead.CurrentRow.Cells[0].Value.ToString();
frm.ShowDialog();
}
}
}
catch { }
dgvHead.Select();
}
}
