/*แสดงข้อมูลใบเบิกสินค้าเพื่อส่งไปฝากขาย*/ 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(); } }