private void btnDelete_Click(object sender, EventArgs e)
{
if (txtIMGid.Text.Equals(""))
{
picImage.Image = null;
}
else
{
if (ss.Equals("ShowQManag"))
{
int delImage = ClassQute.deleteQuteImg(int.Parse(txtIMGid.Text));
dt = ClassQute.selectimgforQute(DocID);
MessageBox.Show("Done . .");
txtIMGid.Text = "";
picImage.Image = null;
}
else if (ss.Equals("ShowOManag"))
{
int delImage = ClassOrder.deleteImgForOrder(int.Parse(txtIMGid.Text));
dt = ClassOrder.selectImgOrder(DocID);
MessageBox.Show("Done . .");
txtIMGid.Text = "";
picImage.Image = null;
}
}
numOfImag = dt.Rows.Count;
btnFirstIMG_Click(null, null);
}
private void btnsave_Click(object sender, EventArgs e)
{
try
{
DataTable order_det = new DataTable();
order_det.Columns.Add("P_ID");
order_det.Columns.Add("Qty");
order_det.Columns.Add("P_Price");
for (int i = 0; i < dgvProduct.Rows.Count; i++)
{
order_det.Rows.Add(dgvProduct.Rows[i].Cells[0].Value,
dgvProduct.Rows[i].Cells[3].Value,
dgvProduct.Rows[i].Cells[2].Value);
}
ClassOrder.sp_order_insert(reqdate.Value, txttotal.Text,
int.Parse(txtCuID.Text), txtsellerName.Text, order_det);
MessageBox.Show("تم حفظ الفاتورة بنجاح");
btnprint.Enabled = btnnewOrder.Enabled = true;
btnsave.Enabled = btnDelete.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show("البيانات المدخلة غير كافية");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (ss.Equals("ShowQManag"))
{
try
{
if (txtIMGid.Text.Equals("") && picImage.Image != null)
{
int addIMG = ClassQute.AddImgQute(arr, DocID);
dt = ClassQute.selectimgforQute(DocID);
MessageBox.Show("Done . .");
numOfImag = dt.Rows.Count;
btnFirstIMG_Click(null, null);
}
}
catch (Exception) { }
}
else if (ss.Equals("ShowOManag"))
{
try
{
if (txtIMGid.Text.Equals("") && picImage.Image != null)
{
int addIMG = ClassOrder.AddImageOrder(arr, DocID);
dt = ClassOrder.selectImgOrder(DocID);
MessageBox.Show("Done . .");
numOfImag = dt.Rows.Count;
btnFirstIMG_Click(null, null);
}
}
catch (Exception) { }
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtType.Text.Equals("") || txtOwnDoc.Text.Equals(""))
{
MessageBox.Show("الرجاء ملئ الحقول الضرورية");
}
else
{
int addDoc = ClassOrder.AddNewOrder(txtType.Text, txtOwnDoc.Text, txtNumber.Text, dtpDoc.Value, rtxtNote.Text, 1, Qute_Id, FRM_Main.emp_fname + " " + FRM_Main.emp_lname);
if (NumOfImage > 0)
{
DataTable LastOne = ClassOrder.selectlastOrder();
for (int i = 0; i < images.Count; i++)
{
int AddImg = ClassOrder.AddImageOrder(images[i], int.Parse(LastOne.Rows[0][0].ToString()));
}
}
int updateQute = ClassQute.UpdateStatQute(Qute_Id);
Qute_Id = 0;
txtNumber.Text = txtOwnDoc.Text = txtType.Text = rtxtNote.Text = "";
lbNumIMG.Text = "0";
NumOfImage = 0;
images.Clear();
label7.Text = "0";
MessageBox.Show("تمت عملية الحفظ بنجاح");
}
}
catch (Exception) { MessageBox.Show("يجب اختيار عرض اسعار مرتبط بالطلبية"); }
}
public FRM_ShowImage(int id, string s)
{
InitializeComponent();
DocID = id;
ss = s;
if (s.Equals("ShowQ"))
{
btnSave.Visible = btnDelete.Visible = btnSelectOne.Visible = btnExport.Visible = btnPrint.Visible = false;
dt = ClassQute.selectimgforQute(DocID);
}
if (s.Equals("ShowO"))
{
btnSave.Visible = btnDelete.Visible = btnSelectOne.Visible = btnExport.Visible = btnPrint.Visible = false;
dt = ClassOrder.selectImgOrder(DocID);
}
if (s.Equals("ShowQManag"))
{
dt = ClassQute.selectimgforQute(DocID);
}
if (s.Equals("ShowOManag"))
{
dt = ClassOrder.selectImgOrder(DocID);
}
numOfImag = dt.Rows.Count;
try
{
txtIMGid.Text = dt.Rows[0][0].ToString();
byte[] arr = (byte[])(dt.Rows[0][1]);
MemoryStream ms = new MemoryStream(arr);
picImage.Image = Image.FromStream(ms);
}
catch (Exception) { }
}
private void btnprint_Click(object sender, EventArgs e)
{
RPT.RRM_Reports frm = new RPT.RRM_Reports();
RPT.rpt_order_print rop = new RPT.rpt_order_print();
rop.SetParameterValue("@order_id", ClassOrder.max_id_order());
frm.crystalReportViewer1.ReportSource = rop;
frm.ShowDialog();
}
static void Main(string[] args)
{
ClassOrder Order = new ClassOrder {
Id = 1080, Time = DateTime.Now, Status = OrderStatus.PendingPaym
};
Console.WriteLine(Order);
}
void fullcmb()
{
DataTable dt = ClassOrder.selectAllStateOrder();
cmbState.DataSource = dt;
cmbState.DisplayMember = "Order_state";
cmbState.ValueMember = "Order_state_id";
}
//用于将信息封装成一个order实体类
public ClassOrder toClassOrder(int orderId, int goodsId, string goodsName, int goodsNumber, int goodsPrice, DateTime dataTime, int orderState)
{
ClassOrder classOrder = new ClassOrder();
classOrder.OrderId = orderId;
classOrder.GoodsId = goodsId;
classOrder.GoodsNumber = goodsNumber;
classOrder.GoodsName = goodsName;
classOrder.GoodsPrice = goodsPrice;
classOrder.DataTime = dataTime;
classOrder.OrderState = orderState;
return(classOrder);
}
public int purchase(ClassOrder classOrder, ClassUser classUser)
{
myConnection.Open();
string strCmd = "insert into t_goodsOrder (orderId,goodsId,goodsName,goodsNumber,goodsPrice,orderDate,orderState)values('" + classOrder.OrderId + "','" + classOrder.GoodsId + "' ,'" + classOrder.GoodsName + "', '" + classOrder.GoodsNumber + "','" + classOrder.GoodsPrice + "','" + classOrder.DataTime + "','" + classOrder.OrderState + "' )";
SqlCommand cmd = new SqlCommand(strCmd, myConnection);
int result1 = cmd.ExecuteNonQuery();//用于返回影响行数，如果为1则插入失败
string strCmd2 = "insert into t_userOrder(account,orderId)values('" + classUser.Account + "','" + classOrder.OrderId + "')";
SqlCommand cmd2 = new SqlCommand(strCmd2, myConnection);
int result2 = cmd2.ExecuteNonQuery();//用于返回影响行数，如果为1则插入失败
myConnection.Close();
return(result);
}
private void btnExcute_Click(object sender, EventArgs e)
{
if (!txtID.Text.Equals(""))
{
int i = ClassOrder.UpdateStateOrder(int.Parse(txtID.Text), (int)cmbStateOrder.SelectedValue);
MessageBox.Show("تمت العملية بنجاح");
txtID.Text = txtSearch.Text = "";
display();
}
else
{
MessageBox.Show("الرجاء تحديد طلبية ");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtID.Text.Equals("") || txttype.Text.Equals("") || txtown.Text.Equals("") || txtnum.Text.Equals(""))
{
MessageBox.Show("الرجاء ملئ جميع الجقول");
}
else
{
int i = ClassOrder.updateOrder(int.Parse(txtID.Text), txttype.Text, txtown.Text, txtnum.Text, dtpdate.Value, rtxtNote.Text, (int)cmbState.SelectedValue);
MessageBox.Show("تمت عملية التعديل بنجاح");
display();
txtID.Text = txtnum.Text = txtown.Text = txttype.Text = rtxtNote.Text = "";
QuteID = 0;
}
}
private void button2_Click(object sender, EventArgs e)
{
if (txtID.Text.Equals(""))
{
MessageBox.Show("الرجاء تحديد طلبية اولا");
}
else
{
int delImg = ClassOrder.deleteImgWithIDOrder(int.Parse(txtID.Text));
int delOrder = ClassOrder.deleteOrder(int.Parse(txtID.Text));
int updateQutestate = ClassQute.FreeStatQuteOrder(QuteID);
MessageBox.Show("تمت عملية الحذف بنجاح");
display();
txtID.Text = txtnum.Text = txtown.Text = txttype.Text = rtxtNote.Text = "";
QuteID = 0;
}
}
private void btnQuotationSelect_Click(object sender, EventArgs e)
{
FRM_QuotationSelected s = new FRM_QuotationSelected();
s.ShowDialog();
try
{
txtBriName.Text = s.dgvQuotations.CurrentRow.Cells[3].Value.ToString();
txtBatName.Text = s.dgvQuotations.CurrentRow.Cells[4].Value.ToString();
txtSarName.Text = s.dgvQuotations.CurrentRow.Cells[5].Value.ToString();
txtContactName.Text = s.dgvQuotations.CurrentRow.Cells[2].Value.ToString();
txtLegal.Text = s.dgvQuotations.CurrentRow.Cells[6].Value.ToString();
id = s.dgvQuotations.CurrentRow.Cells[0].Value.ToString();
dgvQuotationDet.DataSource = ClassOrder.sp_IDSelectedQuotaionsDet(int.Parse(id));
}
catch (Exception ex)
{
}
}
public ClassBIZ()
{
textLock = "true";
comboLock = "false";
classCallWebAPI = new ClassCallWebAPI();
classLuxYachtDieselDB = new ClassLuxYachtDieselDB();
currency = new ClassCurrency();
selectedCustomer = new ClassCustomer();
selectedSupplier = new ClassSupplier();
fallbackCustomer = new ClassCustomer();
fallbackSupplier = new ClassSupplier();
listCountry = GetAllCountries();
listDieselPrice = GetAllDieselPricesForListFromDB();
//country = new List<ClassCountry>();
listCustomers = GetAllCustomersForListFromDB();
listSupplier = GetAllSuplliersForListFromDB();
dieselPrice = GetDieselPriceFromDB();
order = new ClassOrder();
}
private void dgvOrder_DoubleClick(object sender, EventArgs e)
{
try
{
txtID.Text = dgvOrder.CurrentRow.Cells[0].Value.ToString();
txttype.Text = dgvOrder.CurrentRow.Cells[1].Value.ToString();
txtown.Text = dgvOrder.CurrentRow.Cells[2].Value.ToString();
txtnum.Text = dgvOrder.CurrentRow.Cells[3].Value.ToString();
dtpdate.Value = DateTime.Parse(dgvOrder.CurrentRow.Cells[4].Value.ToString());
rtxtNote.Text = dgvOrder.CurrentRow.Cells[5].Value.ToString();
cmbState.Text = dgvOrder.CurrentRow.Cells[7].Value.ToString();
DataTable dt = ClassOrder.selectQuteIdwithOrder(int.Parse(txtID.Text));
QuteID = int.Parse(dt.Rows[0][0].ToString());
}
catch (Exception)
{
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (dgvQuotation.Rows.Count == 0 || txtBriName.Text.Equals(""))
{
MessageBox.Show("Data Not Completed.");
}
else
{
int i = ClassOrder.sp_broOrder(DateTime.Now.Date, txtContactName.Text, txtBriName.Text, txtBatName.Text, txtSarName.Text, txtLegal.Text, code);
for (int num = 0; num < dgvQuotation.Rows.Count; num++)
{
int x = ClassOrder.sp_briOrderDet(dgvQuotation.Rows[num].Cells[0].Value.ToString(), dgvQuotation.Rows[num].Cells[1].Value.ToString(), dgvQuotation.Rows[num].Cells[2].Value.ToString(), dgvQuotation.Rows[num].Cells[3].Value.ToString());
}
int z = ClassOrder.briUpdateQuotExE(int.Parse(id));
btnDelete.Enabled = btnUpdate.Enabled = btnSave.Enabled = btnInsert.Enabled = txtContactName.Enabled = btnCancel.Enabled = btnQuotationSelect.Enabled = false;
btnPrint.Enabled = true;
MessageBox.Show("Done");
}
}
/// <summary>
/// This method saves(inserts) new orders in the DB
/// </summary>
/// <param name="inOrder"></param>
public void SaveOrderToDB(ClassOrder inOrder)
{
SqlCommand command = new SqlCommand(); //
command.Connection = con; // Tell which db to connect to, con is declared in ClassDbCon
command.CommandType = CommandType.StoredProcedure; // Declare which type of command we want to run
command.CommandText = "spOrders_Insert"; // Name of our stored procedure
// Our parameters for
command.Parameters.Add("@customerId", SqlDbType.Int).Value = inOrder.customer.Id;
command.Parameters.Add("@supplierId", SqlDbType.Int).Value = inOrder.supplier.Id;
command.Parameters.Add("@volume", SqlDbType.Int).Value = inOrder.volume;
command.Parameters.Add("@date", SqlDbType.Date).Value = inOrder.date;
command.Parameters.Add("@price", SqlDbType.Decimal).Value = inOrder.price;
command.Parameters.Add("@customerRate", SqlDbType.Decimal).Value = inOrder.customerRate;
command.Parameters.Add("@supplierRate", SqlDbType.Decimal).Value = inOrder.supplierRate;
command.Parameters.Add("@profit", SqlDbType.Decimal).Value = inOrder.ownProfit;
MakeCallToStoredProcedure(command); // Call method with our command as paramter. Is returned as a datatable
}
private void txtbarcode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyData == Keys.Enter)
{
if (txtbarcode.Text != "")
{
DataTable dt = ClassOrder.SP_GET_PRODUCT_BARCODE_buy(txtbarcode.Text);
if (dt.Rows.Count == 0)
{
MessageBox.Show("هذا المنتج غير موجود في المستودع يرجى الذهاب الى (اضافة منتج جديد) لاضافته");
}
foreach (DataRow dr in dt.Rows)
{
txtProID.Text = dr[0].ToString();
txtProName.Text = dr[1].ToString();
txtPrice.Text = dr[2].ToString();
}
txtbarcode.Text = "";
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (Label3.Text.ToString() == "1" && Label4.Text.ToString() == "1")
{
Random rd = new Random();
int orderId = rd.Next(1, 100000000);//生成随机订单号
int goodsId = 2001;
string goodsName = "华为 P20手机 渐变色";
int goodsNumber = Convert.ToInt32(TextBox1.Text);
int price = Convert.ToInt32(Label1.Text);
DateTime dataTime = DateTime.Now;
int orderState = 0;//下单先是为0，未发货状态
ClassOrder classOrder = new ClassOrder();
EntityFactory entityFactory = new EntityFactory();
classOrder = entityFactory.toClassOrder(orderId, goodsId, goodsName, goodsNumber, price, dataTime, orderState);
Dao dao = new Dao();
dao.purchase(classOrder, classUser);
}
if (Label3.Text.ToString() == "2" && Label4.Text.ToString() == "1")
{
Random rd = new Random();
int orderId = rd.Next(1, 100000000);//生成随机订单号
int goodsId = 2002;
string goodsName = "华为 P20手机 灰橙";
int goodsNumber = Convert.ToInt32(TextBox1.Text);
int price = Convert.ToInt32(Label1.Text);
DateTime dataTime = DateTime.Now;
int orderState = 0;//下单先是为0，未发货状态
ClassOrder classOrder = new ClassOrder();
EntityFactory entityFactory = new EntityFactory();
classOrder = entityFactory.toClassOrder(orderId, goodsId, goodsName, goodsNumber, price, dataTime, orderState);
Dao dao = new Dao();
dao.purchase(classOrder, classUser);
}
Response.Write("<script>alert('购买成功，请到订单详情查询！');top.location='../main.aspx' </script>");
}
/// <summary>
/// This method handles the user regretting creating a new order
/// </summary>
public void RegretNewOrderForDB()
{
order = new ClassOrder();
}
public void purchase(ClassOrder classOrder, object classUser)
{
throw new NotImplementedException();
}
public FRM_QuotDetails(string s)
{
InitializeComponent();
id = s;
dgvDetails.DataSource = ClassOrder.sp_IDSelectedQuotaionsDet(int.Parse(s));
}
void display()
{
dgvOrder.DataSource = ClassOrder.selectOrder();
}
public FRM_QuotationSelected()
{
InitializeComponent();
dgvQuotations.DataSource = ClassOrder.sp_selectQuotaions(FRM_BriOrder.code);
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvQuotations.DataSource = ClassOrder.sp_searchSelectedQuotaions(txtSearch.Text);
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvOrder.DataSource = ClassOrder.searchOrderAll(txtSearch.Text);
}
private void btnDisplay_Click(object sender, EventArgs e)
{
dgvOrderAll.DataSource = ClassOrder.sp_order_select();
}
