private void btnIgual_Click(object sender, EventArgs e)
{
segundo = double.Parse(txtIntroducir.Text);
double SUM;
double RES;
double MUL;
double DIV;
switch (operador)
{
case "+":
SUM = obj.Sumar((primero), (segundo));
txtIntroducir.Text = SUM.ToString();
break;
case "-":
RES = obj2.Restar((primero), (segundo));
txtIntroducir.Text = RES.ToString();
break;
case "*":
MUL = obj3.Multiplicar((primero), (segundo));
txtIntroducir.Text = MUL.ToString();
break;
case "/":
DIV = obj4.Dividir((primero), (segundo));
txtIntroducir.Text = DIV.ToString();
break;
}
}
/*
* Parses TYPEDEF commands (First token, then delegates rest to specific TYPEDEF implementations).
* Populates typedef table.
*/
public static TYPEDEF Parse(string code, Dictionary <string, TYPEDEF> typedefTable)
{
if (String.IsNullOrEmpty(code))
{
throw new ArgumentNullException("code");
}
if (null == typedefTable)
{
throw new ArgumentNullException("typedefTable");
}
string[] tokens = code.Split(new char[] { ' ', '\t' }, StringSplitOptions.RemoveEmptyEntries);
if (tokens.Length < 3)
{
throw new ArgumentException("TYPEDEF statements must consist of at least three tokens (TYPEDEF <NAME> <TYPE>), received: " + code);
}
if (tokens[0].ToUpper() != "TYPEDEF")
{
throw new ArgumentException("TYPEDEFs must start with keyword TYPEDEF, but received: " + tokens[0]);
}
TYPEDEF parsedType = null;
string Type = tokens[2].ToUpper();
if (Type == "BASIC")
{
parsedType = new BASIC(tokens, typedefTable);
}
else if (Type == "PRODUCT")
{
parsedType = new PRODUCT(tokens, typedefTable);
}
else if (Type == "SUM")
{
parsedType = new SUM(tokens, typedefTable);
}
else if (Type == "SEQUENCE")
{
parsedType = new SEQUENCE(tokens, typedefTable);
}
else if (Type == "FUNCTION")
{
parsedType = new FUNCTION(tokens, typedefTable);
}
else if (Type == "SUBTYPE")
{
parsedType = new SUBTYPE(tokens, typedefTable);
}
else
{
throw new SyntacticException("Not a valid TYPEDEF: " + code);
}
return(parsedType);
}
private void bunifuThinButton21_Click(object sender, EventArgs e)
{
try
{
conn.Open();
string sql = "SELECT DATEDIFF (day, NGAYDEN, NGAYDI) AS ngayo From PHONGTHUE, KHACHHANG WHERE SOPHONG = '" + sophong + "' AND khachhang.MAKH = '" + makh.Trim() + "'";
SqlCommand cmd1 = new SqlCommand(sql, conn);
cmd1.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd1);
DataTable dt = new DataTable();
da.Fill(dt);
object SUM;
SUM = dt.Compute("Max(ngayo)", "");
thanhtientext.Text = SUM.ToString();
int ngayo = Int32.Parse(thanhtientext.Text); // so ngay o
string sql2 = "SELECT gia AS GIA From PHONGTHUE, KHACHHANG, LOAIPHONG, PHONG WHERE KHACHHANG.MAKH = PHONGTHUE.MAKH AND PHONGTHUE.SOPHONG = PHONG.SOPHONG AND PHONG.LOAIPHONG = LOAIPHONG.LOAIPHONG AND PHONGTHUE.SOPHONG = '" + sophong + "' AND khachhang.MAKH = '" + makh.Trim() + "'";
SqlCommand cmd2 = new SqlCommand(sql2, conn);
cmd2.CommandType = CommandType.Text;
SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
DataTable dt2 = new DataTable();
da2.Fill(dt2);
object GIA;
GIA = dt2.Compute("Max(GIA)", "");
thanhtientext.Text = GIA.ToString();
double gia = Convert.ToDouble(thanhtientext.Text); //so tien trong 1 ngay
thanhtientext.Text = (gia * ngayo).ToString(); // tong tien
string doanhthu = "UPDATE DOANHTHU SET TONGTIEN = TONGTIEN + " + thanhtientext.Text + " WHERE THANG = " + DateTime.Today.Month.ToString();
SqlCommand cmddoanhthu = new SqlCommand(doanhthu, conn); //cong tien vao doanh thu trong thang
cmddoanhthu.ExecuteNonQuery();
string sql3 = "UPDATE PHONGTHUE SET NGAYDI = GETDATE() WHERE MAKH ='" + makhtxt.Text + "' ";
SqlCommand cmd3 = new SqlCommand(sql3, conn);
cmd3.ExecuteNonQuery(); // UPDATE NGAYDI = HOM NAY
sql2 = "SELECT distinct SOPHONG FROM PHONGTHUE WHERE NGAYDEN <= '" + DateTime.Now.ToString("yyyy/MM/dd") + "' AND NGAYDI > '" + DateTime.Now.ToString("yyyy/MM/dd") + "'";
showdata(sql2);
}
catch
{
MessageBox.Show("Loi!!! vui long kiem tra lai");
}
finally
{
conn.Close();
}
FormChinh.LoadTrangThai();
}
public void Test_Sum()
{
int summary = 12;
List <int> sum = new List <int>()
{
2, 4, 3, 3,
};
var numbers = new SUM();
int output = numbers.Summary(sum);
Assert.AreEqual(output, summary);
}
public void CalcTest()
{
SUM target = new SUM();
byte[] bytes = new byte[] { 255, 255, 255 };
int begin = 0;
int length = bytes.Length;
byte expected = 0xfd;
byte[] actual;
actual = target.Calc(bytes, begin, length);
Assert.AreEqual(expected, actual[0]);
}
public DocumentCollector AddAggregateFunction(AggregateFunctionType type, IEvaluable field)
{
if (_aggregations == null)
{
_aggregations = new List <DocumentCollector>();
}
IAggregation function;
switch (type)
{
case AggregateFunctionType.AVG:
function = new AVG();
break;
case AggregateFunctionType.COUNT:
function = new COUNT();
break;
case AggregateFunctionType.MAX:
function = new MAX();
break;
case AggregateFunctionType.MIN:
function = new MIN();
break;
case AggregateFunctionType.SUM:
function = new SUM();
break;
//case AggregateFunctionType.FIRST:
// function = new FIRST(field);
// break;
//case AggregateFunctionType.LAST:
// function = new LAST(field);
// break;
default:
throw new QuerySystemException(ErrorCodes.Query.AGGREGATION_INVALID_FUNCTION);
}
var aggregator = new DocumentCollector(function, field);
_aggregations.Add(aggregator);
return(aggregator);
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
int C = 0;
F2.sqlConnection1.Open();
SqlCommand CMD2 = new SqlCommand("select count(INVOICE_ID) from dbo.INVOICE_Table ", F2.sqlConnection1);
SqlDataReader dr2 = CMD2.ExecuteReader();
if (dr2.Read())
{
C = Convert.ToInt32(dr2[0]);
C++;
textBox2.Text = textBox12.Text + C.ToString();
}
F2.sqlConnection1.Close();
this.textBox14.Text = "67";
this.textBox11.Text = "YES";
F2.sqlConnection1.Open();
SqlCommand CMD = new SqlCommand("SELECT *FROM dbo.Delivery_challan_Table WHERE DC_ID='" + comboBox1.Text + "'", F2.sqlConnection1);
SqlDataReader DR = CMD.ExecuteReader();
if (DR.Read())
{
textBox3.Text = DR["SO_ID"].ToString();
textBox4.Text = DR["C_ID"].ToString();
textBox5.Text = DR["P_ID"].ToString();
textBox6.Text = DR["C_NAME"].ToString();
dateTimePicker1.Text = DR["DELIVERY_DATE"].ToString();
textBox7.Text = DR["P_NAME"].ToString();
textBox10.Text = DR["P_PRICE"].ToString();
textBox9.Text = DR["P_QTY"].ToString();
textBox8.Text = DR["TOTAL_AMOUNT"].ToString();
}
F2.sqlConnection1.Close();
int A, B, SUM;
A = Convert.ToInt32(textBox14.Text);
B = Convert.ToInt32(textBox8.Text);
SUM = A * B;
textBox15.Text = SUM.ToString();
}
public override string Eval(List <Expression> expList, Dictionary <string, TYPEDEF> typedefTable, Dictionary <string, VARDECL> symbolTable)
{
if (expList.Count != 2)
{
throw new SemanticException("EMBED Operator requires a SUM name, a field, and one expression (EMBED <product name> <field> <exp> ).");
}
string sumname = expList[0].Eval(typedefTable, symbolTable);
if (!typedefTable.ContainsKey(sumname))
{
throw new SemanticException("A SUM of type " + sumname + " was never defined, please add a TYPEDEF " + sumname + " PRODUCT ... above.");
}
if (typedefTable[sumname].Type != "SUM")
{
throw new SemanticException("Expression " + expList[0] + " evaluates to type " + typedefTable[sumname].Type + " but expected type SUM.");
}
SUM sum = typedefTable[sumname] as SUM;
if (null == sum)
{
throw new SemanticException("First param to EMBED is not actually a SUM.");
}
string exptype = expList[1].Eval(typedefTable, symbolTable);
VariableExpression varexp = (expList[1] as VariableExpression); // fieldname
if (null == varexp)
{
throw new SemanticException("Second param to EMBED is not actually a field value, but an expression of some sort.");
}
if (!sum.ArgPairs.ContainsValue(exptype))
{
throw new SemanticException("The SUM " + sum.Name + " can not be expressed as type " + exptype + ".");
}
return(sum.Name);
}
private void ButtonTimKiem_Click(object sender, EventArgs e)
{
string sql = "";
int dong = DataGridPhongDaChon.RowCount;
for (int j = 0; j < dong; j++)
{
Random radmadk = new Random();
int madk = radmadk.Next(0, 99999);
try
{
sql = "INSERT INTO PHONGTHUE VALUES('" + madk + "','" + madoantxt.Text + "','" + DataGridPhongDaChon.Rows[j].Cells[0].Value + "'," + DateTime.Today.ToString("yyyy/MM/dd") + ",'" + ngaydenttoan + "','" + ngaydittoan + "'," + DateTime.Today.ToString("yyyy/MM/dd") + ")";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
catch
{
MessageBox.Show("Loi phong so " + DataGridPhongDaChon.Rows[j].Cells[0].Value);
}
}
sql = "SElECT SUM(GIA) tong FROM PHONG, PHONGTHUE, LOAIPHONG WHERE PHONGTHUE.SOPHONG = PHONG.SOPHONG AND LOAIPHONG.LOAIPHONG = PHONg.LOAIPHONG AND MAKH = '" + madoantxt.Text + "'";
SqlCommand cmd1 = new SqlCommand(sql, conn);
cmd1.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd1);
DataTable dt = new DataTable();
da.Fill(dt);
object SUM;
SUM = dt.Compute("Max(tong)", "");
Tinhtientxt.Text = SUM.ToString();
string doanhthu = "UPDATE DOANHTHU SET TONGTIEN = TONGTIEN + " + Tinhtientxt.Text + " WHERE THANG = " + DateTime.Today.Month.ToString();
SqlCommand cmddoanhthu = new SqlCommand(doanhthu, conn); //cong tien vao doanh thu trong thang
cmddoanhthu.ExecuteNonQuery();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
int C = 0;
F2.sqlConnection1.Open();
SqlCommand CMD2 = new SqlCommand("select count(DC_ID) from dbo.Delivery_challan_Table ", F2.sqlConnection1);
SqlDataReader dr2 = CMD2.ExecuteReader();
if (dr2.Read())
{
C = Convert.ToInt32(dr2[0]);
C++;
textBox1.Text = textBox6.Text + C.ToString();
}
F2.sqlConnection1.Close();
F2.sqlConnection1.Open();
SqlCommand CMD = new SqlCommand("SELECT *FROM dbo.SALESORDER_Table WHERE SO_ID='" + comboBox1.Text + "'", F2.sqlConnection1);
SqlDataReader DR = CMD.ExecuteReader();
if (DR.Read())
{
textBox7.Text = DR["C_ID"].ToString();
textBox3.Text = DR["C_NAME"].ToString();
textBox8.Text = DR["PR_ID"].ToString();
textBox4.Text = DR["PR_TYPE"].ToString();
textBox5.Text = DR["PR_QTY"].ToString();
textBox10.Text = DR["PR_PRICE"].ToString();
}
F2.sqlConnection1.Close();
int A, B, SUM;
A = Convert.ToInt32(textBox10.Text);
B = Convert.ToInt32(textBox5.Text);
SUM = A * B;
textBox9.Text = SUM.ToString();
}
static void Main(string[] args)
{
Console.WriteLine("Enter the Number");
int num = Convert.ToInt32(Console.ReadLine());
int a = 1, remainder, N, SUM, i;
string sum = string.Empty; string b = string.Empty;
N = num;
while (num != 0)
{
SUM = 0;
remainder = num % 10;
SUM = a + remainder;
sum = sum + SUM.ToString();
num = num / 10;
}
for (i = sum.Length - 1; i >= 0; i--)
{
b = b + sum[i];
}
Console.WriteLine("the new number is={0}", b);
Console.ReadLine();
}
public static void fillLbl(Label label, string query, string query1, params string[] columns)
{
try
{
string text = string.Empty;
var MapOfArticleQuantiy = new Dictionary <Int32, Decimal>();
var MapOfArticleStorageQuantiy = new Dictionary <Int32, Decimal>();
var MapOfPackagingQuantity = new Dictionary <Int32, Decimal>();
var MapOfPackagingStorageQuantity = new Dictionary <Int32, Decimal>();
int QuantityStorageArticleId = 0, QuantityArticleId = 0, QuantityPackagingId = 0, QuantityStoragePackagingId = 0;
decimal QuantityStorageArticle = 0, QuantityArticle = 0, QuantityStoragePackaging = 0, QuantityPackaging = 0, SUM;
_databaseConnection.Open();
MySqlCommand mySqlCommand = _databaseConnection.CreateCommand();
mySqlCommand.CommandText = query;
using MySqlDataReader reader = mySqlCommand.ExecuteReader();
while (reader.Read())
{
foreach (string column in columns)
{
switch (column)
{
case "QuantityArticleId":
QuantityArticleId = reader.GetInt32(column);
break;
case "QuantityArts":
QuantityArticle = reader.GetDecimal(column);
MapOfArticleQuantiy.Add(QuantityArticleId, QuantityArticle);
break;
case "QuantityPackagingId":
QuantityPackagingId = reader.GetInt32(column);
break;
case "QuantityPackg":
QuantityPackaging = reader.GetDecimal(column);
MapOfPackagingQuantity.Add(QuantityPackagingId, QuantityPackaging);
break;
default:
break;
}
}
}
_databaseConnection.Close();
if (query1 == "")
{
foreach (KeyValuePair <Int32, Decimal> item in MapOfArticleQuantiy)
{
bool state = true;
foreach (KeyValuePair <Int32, Decimal> item1 in MapOfArticleStorageQuantiy)
{
if (item1.Key == item.Key)
{
state = false;
SUM = item.Value - item1.Value;
text += $"{SUM.ToString()}";
}
}
if (state != false)
{
text += $"{item.Value.ToString()}";
}
}
foreach (KeyValuePair <Int32, Decimal> item in MapOfPackagingQuantity)
{
bool state = true;
foreach (KeyValuePair <Int32, Decimal> item1 in MapOfPackagingStorageQuantity)
{
if (item1.Key == item.Key)
{
state = false;
SUM = item.Value - item1.Value;
text += $"{SUM.ToString()}";
}
}
if (state != false)
{
text += $"{item.Value.ToString()}";
}
}
label.Text = text;
return;
}
_databaseConnection.Open();
MySqlCommand mySqlCommand1 = _databaseConnection.CreateCommand();
mySqlCommand1.CommandText = query1;
using MySqlDataReader reader1 = mySqlCommand1.ExecuteReader();
while (reader1.Read())
{
foreach (string column in columns)
{
switch (column)
{
case "QuantityStorageArticleId":
QuantityStorageArticleId = reader1.GetInt32(column);
break;
case "QuantityStorageArticle":
QuantityStorageArticle = reader1.GetDecimal(column);
MapOfArticleStorageQuantiy.Add(QuantityStorageArticleId, QuantityStorageArticle);
break;
case "QuantityStoragePackagingId":
QuantityStoragePackagingId = reader1.GetInt32(column);
break;
case "QuantityStoragePackaging":
QuantityStoragePackaging = reader1.GetDecimal(column);
MapOfPackagingStorageQuantity.Add(QuantityStoragePackagingId, QuantityStoragePackaging);
break;
default:
break;
}
}
}
foreach (KeyValuePair <Int32, Decimal> item in MapOfArticleQuantiy)
{
bool state = true;
foreach (KeyValuePair <Int32, Decimal> item1 in MapOfArticleStorageQuantiy)
{
if (item1.Key == item.Key)
{
state = false;
SUM = item.Value - item1.Value;
text += $"{SUM.ToString()}";
}
}
if (state != false)
{
text += $"{item.Value.ToString()}";
}
}
foreach (KeyValuePair <Int32, Decimal> item in MapOfPackagingQuantity)
{
bool state = true;
foreach (KeyValuePair <Int32, Decimal> item1 in MapOfPackagingStorageQuantity)
{
if (item1.Key == item.Key)
{
state = false;
SUM = item.Value - item1.Value;
text += $"{SUM.ToString()}";
}
}
if (state != false)
{
text += $"{item.Value.ToString()}";
}
}
label.Text = text;
}
catch (Exception e)
{
if (_databaseConnection.State != ConnectionState.Open)
{
return;
}
}
finally
{
_databaseConnection.Close();
}
}
//int Channel(int channel)
//{
// for (int i = 1; i <=11; i++)
// {
// if (channel == i)
// {
// channel1 = 2407 + 5*i;
// }
// }
// return channel1;
//}
private void btnstart_Click(object sender, EventArgs e)
{
//Control.CheckForIllegalCrossThreadCalls = false;
try
{
int i = 1;
ListDataTest.Items.Clear();
listtest.Clear();
//
foreach (var item in lines)
{
//MessageBox.Show(item);
bool ret = convertInputData(item, ref listtest);
//MessageBox.Show();
}
int j = 0;
foreach (var ditem in listtest)
{
_wifi = ditem.wifi;
_bandwith = ditem.bandwidth;
_anten = ditem.anten;
_channel = ditem.channel;
_rate = ditem.rate;
_power = ditem.power;
ListDataTest.Items.Add("wifi=" + _wifi + ";anten=" + _anten + ";Channel=" + _channel + ";rate=" + _rate + ";Power=" + _power + "\n");
lbdisplay.Text = "--";
//Check data inputed is ok/ng
//if (!InputedDataValid()) return;
//Generate command
S80211 wifiUnit = null;
GenerateCommand(ref wifiUnit);
//Write command into DUT
Clear();
string msg = "";
MethodInvoker invoker_Ok = delegate
{
WriteCode(msg);
lbdisplay.Text = "OK";
};
MethodInvoker invoker_Ng = delegate
{
lbdisplay.Text = "NG";
WriteCode("FAIL.");
};
//Thread t = new Thread(() =>
//{
#region wifi
if (_wifi == "802.11nHT20")
{
wifi1 = "N20";
}
if (_wifi == "802.11nHT40")
{
wifi1 = "N40";
}
if (_wifi == "802.11b")
{
wifi1 = "BG";
}
if (_wifi == "802.11g")
{
wifi1 = "GDO";
}
#endregion
#region Channel
if (_channel == "1")
{
channel1 = "2412";
}
if (_channel == "2")
{
channel1 = "2417";
}
if (_channel == "3")
{
channel1 = "2422";
}
if (_channel == "4")
{
channel1 = "2427";
}
if (_channel == "5")
{
channel1 = "2432";
}
if (_channel == "6")
{
channel1 = "2437";
}
if (_channel == "7")
{
channel1 = "2442";
}
if (_channel == "8")
{
channel1 = "2447";
}
if (_channel == "9")
{
channel1 = "2452";
}
if (_channel == "10")
{
channel1 = "2457";
}
if (_channel == "11")
{
channel1 = "2462";
}
#endregion
if (wifiUnit.txCommandList.Count > 0)
{
ontDevice.sendListCommand(wifiUnit.txCommandList, out msg);
this.Invoke(invoker_Ok);
Application.DoEvents();
}
else
{
this.Invoke(invoker_Ng);
}
//});
//t.Start();
E6640AVISA = new E6640A_VISA("TCPIP0::192.168.1.2::inst0::INSTR");
E6640AVISA.config_HT20_RxTest_Transmitter(channel1, wifi1, "25", "RFB");
if (_wifi == "802.11nHT20" || _wifi == "802.11nHT40" || _wifi == "802.11g")
{
SUM = E6640AVISA.HienThi();
string[] array = SUM.Split(',');
string Power = Convert.ToDouble(array[19]).ToString("00.00");
string Ferqerror = Convert.ToDouble(array[7]).ToString("00.00");
string sym = Convert.ToDouble(array[11]).ToString("00.00");
string EVM = Convert.ToDouble(array[1]).ToString("00.00");
List <string> lData = new List <string>();
lData.Add(Power);
lData.Add(Ferqerror);
lData.Add(sym);
lData.Add(EVM);
dgv.DataSource = lData;
//string[] array1 = { Power, Ferqerror, sym, EVM + "\n" };
//dgv.DataSource = array1;
////dgv.ColumnCount = 4;
//dgv.Rows.Add();
////dgv.Rows[j].Cells[0].Value = j;
//dgv.Rows[j].Cells[1].Value = Power;
//dgv.Rows[j].Cells[2].Value = Ferqerror;
//dgv.Rows[j].Cells[3].Value = sym;
//dgv.Rows[j].Cells[4].Value = EVM;
j++;
ListDataTest.Items.Add("Power: " + Convert.ToDouble(array[19]).ToString("00.00") + ";EVM: " + Convert.ToDouble(array[1]).ToString("00.00"));
//ListDataTest.Items.Add(SUM + "\n");
}
else if (_wifi == "802.11b")
{
SUM = E6640AVISA.HienThi();
string[] array = SUM.Split(',');
string Power = Convert.ToDouble(array[35]).ToString("00.00");
string Ferqerror = Convert.ToDouble(array[7]).ToString("00.00");
string chip = Convert.ToDouble(array[11]).ToString("00.00");
string EVM = Convert.ToDouble(array[1]).ToString("00.00") + "%";
List <string> lData = new List <string>();
lData.Add(Power);
lData.Add(Ferqerror);
lData.Add(chip);
lData.Add(EVM);
dgv.DataSource = lData;
//string[] array1 = { Power, Ferqerror, sym, EVM + "\n" };
//dgv.ColumnCount = 4;
//dgv.Rows.Add();
////dgv.Rows[j].Cells[0].Value = j;
//dgv.Rows[j].Cells[1].Value = Power;
//dgv.Rows[j].Cells[2].Value = Ferqerror;
//dgv.Rows[j].Cells[3].Value = sym;
//dgv.Rows[j].Cells[4].Value = EVM;
j++;
//dgv.DataSource = array1;
ListDataTest.Items.Add("Power: " + Power + ";EVM: " + EVM + ";Fer Error: " + Ferqerror + ";Chip Clock Error: " + chip + "\n");
}
for (int k = 0; k < 50; k++)
{
Thread.Sleep(100);
Application.DoEvents();
}
ListDataTest.Items.Add("Hoan thanh bai thu " + i);
i++;
//while (t.IsAlive) ;
}
//dgv.DataSource = listtest;
//dgv.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
//throw;
}
}
