private void PurAdd_Click(object sender, EventArgs e) { try { if (ClsSales.VerifyItemsQty(Convert.ToInt32(TxtItemId.Text), Convert.ToDouble(TxtQTE.Text)).Rows.Count < 1) { MessageBox.Show("الكمية المدخلة لهذا المنتج غير متاحة بالمخزن" + Environment.NewLine + "كمية الصنف الحالية الموجودة بالمخزن هى :" + Qt.ToString(), "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); clear(); return; } try { for (int i = 0; i < DGV_salesOrder.Rows.Count; i++) { if (DGV_salesOrder.Rows[i].Cells[0].Value.ToString() == TxtItemId.Text) { clear(); MessageBox.Show("هذا المنتج تم إدخاله مسبقا", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } } catch { return; } if (TxtItemName.Text == string.Empty || TxtSalePrice.Text == string.Empty || TxtQTE.Text == string.Empty) { return; } DataRow r = Dt.NewRow(); r[0] = TxtItemId.Text; r[1] = TxtBarCode.Text; r[2] = TxtItemName.Text; r[3] = TxtSalePrice.Text; r[4] = TxtQTE.Text; r[5] = TxtAmount.Text; r[6] = TxtDiscount.Text; r[7] = TxtTotal.Text; Dt.Rows.Add(r); DGV_salesOrder.DataSource = Dt; clear(); TxtBarCode.Focus(); Tablesum(); //Sum_Qty(); //} } catch { return; } }
private void PurAdd_Click(object sender, EventArgs e) { try { if (ClsSales.VerifyItemsQty(Convert.ToInt32(TxtItemId.Text), Convert.ToDouble(TxtQTE.Text)).Rows.Count < 1) { MessageBox.Show("الكمية المدخلة لهذا المنتج غير متاحة بالمخزن", "واى إن للبرمجيات", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); clear(); return; } for (int i = 0; i < DGV_salesOrder.Rows.Count; i++) { if (DGV_salesOrder.Rows[i].Cells[0].Value.ToString() == TxtItemId.Text) { DGV_salesOrder.Rows[i].Cells[4].Value = Convert.ToDouble(DGV_salesOrder.Rows[i].Cells[4].Value) + Convert.ToDouble(TxtQTE.Text); clear(); DGV_salesOrder.Rows[i].Cells[5].Value = Convert.ToDouble(DGV_salesOrder.Rows[i].Cells[3].Value) * Convert.ToDouble(DGV_salesOrder.Rows[i].Cells[4].Value); clear(); TXT_TOTAL1.Text = (from DataGridViewRow row in DGV_salesOrder.Rows where row.Cells[5].FormattedValue.ToString() != string.Empty select Convert.ToDouble(row.Cells[5].FormattedValue)).Sum().ToString(); } } if (TxtItemName.Text == string.Empty || TxtUnitPrice.Text == string.Empty || TxtQTE.Text == string.Empty) { return; } DataRow r = Dt.NewRow(); r[0] = TxtItemId.Text; r[1] = TxtBarCode.Text; r[2] = TxtItemName.Text; r[3] = TxtUnitPrice.Text; r[4] = TxtQTE.Text; r[5] = TxtTotal.Text; Dt.Rows.Add(r); DGV_salesOrder.DataSource = Dt; clear(); CalculateTotalAmount(); CalculateDisCount(); TxtBarCode.Focus(); } catch { return; } }
private void BtnNew_Click(object sender, EventArgs e) { try { PosOrderId.Text = ClsPos.PosOrderMaxId().Rows[0][0].ToString(); BtnNew.Enabled = false; BtnAdd.Enabled = true; TxtBarCode.Focus(); } catch { return; } }
public FrmSales() { InitializeComponent(); var dateNow = DateTime.Now; SalesOrder_Date.DateTime = dateNow; User_SalesOrder.Text = Program.UserName; BtnAdd.Enabled = false; panelCust.Enabled = false; CreateDataTable(); CalculateTotalAmount(); SandatCalculateAmount(); TxtBarCode.Focus(); CMB_TSDID.SelectedIndex = 0; }
void clear() { TxtItemId.Text = ""; TxtBarCode.Text = ""; TxtItemName.Text = ""; TxtUnitPrice.Text = ""; TxtQTE.Text = ""; TxtSalePrice.Text = ""; TxtTotal.Text = ""; var dateNow = DateTime.Now; SalesOrder_Date.DateTime = dateNow; UserName.Text = Program.UserName; UserType.Text = Program.UserType; TxtBarCode.Focus(); }
private void BtnNew_Click(object sender, EventArgs e) { try { SalesOrder_Id.Text = ClsSales.SalesOrderMaxId().Rows[0][0].ToString(); VoucherCode.Text = ClsRV.GetMaxVoucher().Rows[0][0].ToString(); BtnNew.Enabled = false; BtnAdd.Enabled = true; TxtBarCode.Focus(); SalesOrder_Desc.Text = "فاتورة مبيعات جديدة " + SalesOrder_Id.Text; Cust_ID.Text = "1"; Cust_Name.Text = "بدون عميل"; } catch { return; } }
private void BtnitemSave_Click(object sender, EventArgs e) { SqlConnection conn = sqlcon.getcon(""); //string strwhere = "select item_no,M_name,khdw,m_product.id as pid from m_product " + // " where ITEM_NO ='" + this.TxtBarCode.Text.ToString() + "' "; string strwhere = "SELECT ITEM_NO,M_name,khdw,S_COLOR,CO_CODE,m_SizeDetails.cade as SDcade,m_SizeDetails.[name] as SDName," + "m_ProductSub.pid,M_productsub.id as colourID,m_SizeDetails.id sdid FROM m_product LEFT JOIN m_ProductSub " + "ON m_ProductSub.PID=m_product.ID left join m_ProductSize on m_ProductSize.pid=m_product.ID " + "LEFT join m_SizeDetails on m_SizeDetails.sizeid=m_ProductSize.sizeid " + "where cast(ITEM_NO as varchar(20))+cast(CO_CODE as varchar(20))+m_SizeDetails.Cade='" + TxtBarCode.Text.ToString() + "' "; DataSet ds = new DataSet(); SqlDataAdapter sqlDaper = new SqlDataAdapter(strwhere, conn); //SqlDataAdapter sqlDaper = sqlcon.getread(strwhere); conn.Open(); sqlDaper.Fill(ds, "HDS"); conn.Close(); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ((DataTable)DGVDetailList.DataSource).NewRow(); dr["Item_no"] = ds.Tables["HDS"].Rows[0]["Item_no"].ToString(); dr["M_name"] = ds.Tables["HDS"].Rows[0]["M_name"].ToString(); dr["khdw"] = ds.Tables["HDS"].Rows[0]["khdw"].ToString(); dr["S_COLOR"] = ds.Tables["HDS"].Rows[0]["S_COLOR"].ToString(); dr["CO_CODE"] = ds.Tables["HDS"].Rows[0]["CO_CODE"].ToString(); dr["SDName"] = ds.Tables["HDS"].Rows[0]["SDName"].ToString(); dr["pid"] = ds.Tables["HDS"].Rows[0]["pid"].ToString(); dr["ColourID"] = ds.Tables["HDS"].Rows[0]["ColourID"].ToString(); dr["Sdid"] = ds.Tables["HDS"].Rows[0]["Sdid"].ToString(); dr["Qty"] = TxtQty.Text.ToString(); ((DataTable)DGVDetailList.DataSource).Rows.Add(dr); } else { MessageBox.Show("查无此条码"); } //TxtBarCode.Text = ""; TxtBarCode.Focus(); TxtBarCode.SelectAll(); }
private void BtnitemSave_Click(object sender, EventArgs e) { SqlConnection conn = sqlcon.getcon(""); string strwhere = "select item_no,M_name,khdw,co_code,s_color,m_SizeDetails.NAME as SDName,m_product.id as pid,m_ProductSub.id as colourID,m_SizeDetails.id as sdid from m_product " + "left join m_productsize on m_product.id=m_productsize.pid " + "left join m_ProductSub on m_product.id=m_ProductSub.pid " + "left join m_SizeDetails on m_SizeDetails.sizeid=m_productsize.sizeid where cast(ITEM_NO as varchar(20))+cast(CO_CODE as varchar(20))+m_SizeDetails.Cade='" + this.TxtBarCode.Text.ToString() + "' "; DataSet ds = new DataSet(); SqlDataAdapter sqlDaper = new SqlDataAdapter(strwhere, conn); //SqlDataAdapter sqlDaper = sqlcon.getread(strwhere); conn.Open(); sqlDaper.Fill(ds, "Rks"); conn.Close(); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ((DataTable)DGVDetailList.DataSource).NewRow(); dr["Item_no"] = ds.Tables["RKs"].Rows[0]["Item_no"].ToString(); dr["co_code"] = ds.Tables["RKs"].Rows[0]["co_code"].ToString(); dr["s_color"] = ds.Tables["RKs"].Rows[0]["s_color"].ToString(); dr["M_name"] = ds.Tables["RKs"].Rows[0]["M_name"].ToString(); dr["khdw"] = ds.Tables["RKs"].Rows[0]["khdw"].ToString(); dr["SDName"] = ds.Tables["RKs"].Rows[0]["SDName"].ToString(); dr["pid"] = ds.Tables["RKs"].Rows[0]["pid"].ToString(); dr["colourID"] = ds.Tables["RKs"].Rows[0]["colourID"].ToString(); dr["sdid"] = ds.Tables["RKs"].Rows[0]["sdid"].ToString(); dr["Qty"] = TxtQty.Text.ToString(); ((DataTable)DGVDetailList.DataSource).Rows.Add(dr); } else { MessageBox.Show("查无此条码"); } //TxtBarCode.Text = ""; TxtBarCode.Focus(); TxtBarCode.SelectAll(); }
private void ActivityEditFrm_Load(object sender, EventArgs e) { SqlConnection conn = sqlcon.getcon(""); SqlDataAdapter sqlDaper3 = new SqlDataAdapter("SELECT Cade,CadeDate,Name,Remarks,Type from SS_ActivityList where ID='" + Rows + "' ", conn); DataSet ds = new DataSet(); conn.Open(); sqlDaper3.Fill(ds, "LIST"); conn.Close(); if (ds.Tables["LIST"].Rows.Count > 0) { TxtCade.Text = ds.Tables["LIST"].Rows[0]["Cade"].ToString(); TxtName.Text = ds.Tables["LIST"].Rows[0]["Name"].ToString(); DTPCadeDate.Text = ds.Tables["LIST"].Rows[0]["CadeDate"].ToString(); TxtRemarks.Text = ds.Tables["LIST"].Rows[0]["Remarks"].ToString(); if (ds.Tables["LIST"].Rows[0]["Type"].ToString() == "1") { RBtnYJ.Checked = true; } else { RBtnStorage.Checked = true; } } else { TxtCade.Text = getDate.uppacking("SS_ActivityList", DTPCadeDate.Value.ToString("yyyyMM"), "HD" + (RBtnYJ.Checked == true?"YJ":"FH")); } string strwhere = "select SS_ActivityDetailList.ID,item_no,M_name,khdw,co_code,s_color,m_SizeDetails.name SDName,Qty,m_product.id pid,m_SizeDetails.id sdid,m_ProductSub.id ColourID from SS_ActivityDetailList " + "left join m_product on m_product.id=SS_ActivityDetailList.pid LEFT JOIN m_ProductSub ON m_ProductSub.ID=SS_ActivityDetailList.Sdid LEFT join m_SizeDetails on m_SizeDetails.ID=SDID where RID='" + Rows + "'"; SqlDataAdapter sqlDaper2 = new SqlDataAdapter(strwhere, conn); //SqlDataAdapter sqlDaper = sqlcon.getread(strwhere); conn.Open(); sqlDaper2.Fill(ds, "HD"); conn.Close(); DGVDetailList.DataSource = ds.Tables["HD"]; DGVDetailList.Columns["item_no"].HeaderText = "款号"; DGVDetailList.Columns["item_no"].ReadOnly = true; DGVDetailList.Columns["co_code"].HeaderText = "色号"; DGVDetailList.Columns["co_code"].ReadOnly = true; DGVDetailList.Columns["M_name"].HeaderText = "品名"; DGVDetailList.Columns["M_name"].ReadOnly = true; DGVDetailList.Columns["khdw"].HeaderText = "单位"; DGVDetailList.Columns["khdw"].ReadOnly = true; DGVDetailList.Columns["s_color"].HeaderText = "颜色"; DGVDetailList.Columns["s_color"].ReadOnly = true; DGVDetailList.Columns["SDName"].HeaderText = "尺码"; DGVDetailList.Columns["SDName"].ReadOnly = true; DGVDetailList.Columns["Qty"].HeaderText = "数量"; DGVDetailList.Columns["Qty"].ReadOnly = false; DGVDetailList.Columns["pid"].Visible = false; DGVDetailList.Columns["Sdid"].Visible = false; DGVDetailList.Columns["ColourID"].Visible = false; DGVDetailList.Columns["ID"].Visible = false; TxtBarCode.Focus(); if (Rows == 0) { this.Text = "活动登记!!"; } else { this.Text = "活动修改!!"; } if (Brow == 0) { BtnSave.Enabled = false; BtnitemSave.Enabled = false; } }
private void rStorageNew_Load(object sender, EventArgs e) { SqlConnection conn = sqlcon.getcon(""); SqlDataAdapter sqlDaper3 = new SqlDataAdapter("SELECT Cade,Fid,StockID,OrderCade,Remarks from BR_RStorageList where ID='" + Rows + "' ", conn); SqlDataAdapter sqlDaper1 = new SqlDataAdapter("SELECT StockID,StockName from M_Stock ", conn); SqlDataAdapter sqlDaper = new SqlDataAdapter("select ID,Title from m_Factory ", conn); DataSet ds = new DataSet(); conn.Open(); sqlDaper3.Fill(ds, "LIST"); sqlDaper1.Fill(ds, "Stock"); sqlDaper.Fill(ds, "Factory"); conn.Close(); if (ds.Tables["Stock"].Rows.Count > 0) { CBOStorage.DataSource = ds.Tables["Stock"]; CBOStorage.ValueMember = "StockID"; CBOStorage.DisplayMember = "StockName"; } if (ds.Tables["Factory"].Rows.Count > 0) { CboFID.DataSource = ds.Tables["Factory"]; CboFID.ValueMember = "ID"; CboFID.DisplayMember = "Title"; } if (ds.Tables["LIST"].Rows.Count > 0) { TxtCade.Text = ds.Tables["LIST"].Rows[0]["Cade"].ToString(); TxtorderCade.Text = ds.Tables["LIST"].Rows[0]["OrderCade"].ToString(); TxtRemarks.Text = ds.Tables["LIST"].Rows[0]["Remarks"].ToString(); CboFID.SelectedValue = ds.Tables["LIST"].Rows[0]["Fid"].ToString(); CBOStorage.SelectedValue = ds.Tables["LIST"].Rows[0]["StockID"].ToString(); } else { TxtCade.Text = getDate.uppacking("BR_RStorageList", DTPCadeDate.Value.ToString("yyyyMM"), "RKDJ"); } string strwhere = "select BR_RStroageDetailList.ID,item_no,M_name,khdw,co_code,s_color,m_SizeDetails.NAME as SDName,Qty,m_product.id pid,Sdid,ColourID from BR_RStroageDetailList " + "left join m_product on m_product.id=BR_RStroageDetailList.pid " + "left join m_ProductSub on m_ProductSub.id=BR_RStroageDetailList.Colourid " + "left join m_SizeDetails on m_SizeDetails.id=BR_RStroageDetailList.Sdid where RID='" + Rows + "'"; SqlDataAdapter sqlDaper2 = new SqlDataAdapter(strwhere, conn); //SqlDataAdapter sqlDaper = sqlcon.getread(strwhere); conn.Open(); sqlDaper2.Fill(ds, "Rk"); conn.Close(); DGVDetailList.DataSource = ds.Tables["Rk"]; DGVDetailList.Columns["item_no"].HeaderText = "款号"; DGVDetailList.Columns["item_no"].ReadOnly = true; DGVDetailList.Columns["co_code"].HeaderText = "色号"; DGVDetailList.Columns["co_code"].ReadOnly = true; DGVDetailList.Columns["M_name"].HeaderText = "品名"; DGVDetailList.Columns["M_name"].ReadOnly = true; DGVDetailList.Columns["khdw"].HeaderText = "单位"; DGVDetailList.Columns["khdw"].ReadOnly = true; DGVDetailList.Columns["s_color"].HeaderText = "颜色"; DGVDetailList.Columns["s_color"].ReadOnly = true; DGVDetailList.Columns["SDName"].HeaderText = "尺码"; DGVDetailList.Columns["SDName"].ReadOnly = true; DGVDetailList.Columns["Qty"].HeaderText = "数量"; DGVDetailList.Columns["Qty"].ReadOnly = false; DGVDetailList.Columns["pid"].Visible = false; DGVDetailList.Columns["Sdid"].Visible = false; DGVDetailList.Columns["ColourID"].Visible = false; DGVDetailList.Columns["ID"].Visible = false; TxtBarCode.Focus(); if (Rows == 0) { this.Text = "入库登记!!"; } else { this.Text = "入库修改!!"; } if (Brow == 0) { BtnSave.Enabled = false; BtnitemSave.Enabled = false; } }