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