public frmMedGuide(frmCropGuide fcg, frmMainShopSimple fms, frmPestGuide fpg)
: base("收銀作業")
{
InitializeComponent();
this.fcg = fcg;
frs = fms;
this.fpg = fpg;
addMed(this.fpg.realcropcode, this.fpg.pestcode);
}
public frshyscorp(frmMainShopSimple fms, string barcodeNum, string name)
{
this.fms = fms;
this.barcodeNum = barcodeNum;
InitializeComponent();
string[] strWhereParameterArray = new string[1]
{
barcodeNum
};
DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "*", "hypos_GOODSLST", "GDSNO = {0}", "", null, strWhereParameterArray, CommandOperationType.ExecuteReaderReturnDataTable);
hyscope.Text = "【" + getCommodityName(dataTable.Rows[0]) + "】" + hyscope.Text.ToString();
_pesticideId = dataTable.Rows[0]["pesticideId"].ToString();
_formCode = dataTable.Rows[0]["formCode"].ToString();
_contents = dataTable.Rows[0]["contents"].ToString();
loaddata();
}
public frmMainShopSimpleCheckout(frmMainShopSimple fms, DataGridView temp)
: base("銷售作業")
{
this.fms = fms;
infolist1 = new DataGridView();
string text = DateTime.Now.ToString("yyyyMMdd");
string[] strWhereParameterArray = new string[1]
{
text
};
DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "*", "ECRHDHS", "Hdate = {0}", "", null, strWhereParameterArray, CommandOperationType.ExecuteReaderReturnDataTable);
if (dataTable.Rows.Count > 0)
{
string text2 = dataTable.Rows.Count.ToString();
if (text2.Length == 1)
{
HseqNo = text + "00" + text2;
}
else if (text2.Length == 2)
{
HseqNo = text + "0" + text2;
}
else
{
HseqNo = text + text2;
}
}
else
{
HseqNo = text + "001";
}
setMasterFormName("銷售作業 | 單號: " + HseqNo);
InitializeComponent();
for (int i = 0; i < temp.Rows.Count; i++)
{
infolist1.Rows.Add(temp.Rows[i].Cells[0].Value, temp.Rows[i].Cells[1].Value, temp.Rows[i].Cells[2].Value, temp.Rows[i].Cells[3].Value);
items.Text = fms.gettotalprice();
total.Text = fms.gettotalpriceDiscount();
}
}
public frmDialogMed(frmMainShopSimple frs, int count, string barcode)
{
InitializeComponent();
this.frs = frs;
this.count = count;
barcodeid = barcode;
string[] strWhereParameterArray = new string[1]
{
barcodeid
};
DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "GDName", "hypos_GOODSLST", "GDSNO = {0}", "", null, strWhereParameterArray, CommandOperationType.ExecuteReaderReturnDataTable);
label1.Text = "【" + dataTable.Rows[0]["GDName"].ToString() + "】用藥範圍設定";
string sql = "select cropId,pestId from hypos_user_pair where barcode = '" + barcodeid + "' order by total desc";
DataTable dataTable2 = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, sql, null, CommandOperationType.ExecuteReaderReturnDataTable);
if (dataTable2.Rows.Count <= 0)
{
return;
}
foreach (DataRow row in dataTable2.Rows)
{
string[] strWhereParameterArray2 = new string[1]
{
row["cropId"].ToString()
};
DataTable dataTable3 = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "code,name", "HyCrop", "code = {0}", "", null, strWhereParameterArray2, CommandOperationType.ExecuteReaderReturnDataTable);
string[] strWhereParameterArray3 = new string[1]
{
row["pestId"].ToString()
};
DataTable dataTable4 = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "code,name", "HyBlight", "code = {0}", "", null, strWhereParameterArray3, CommandOperationType.ExecuteReaderReturnDataTable);
infolist.Rows.Add(dataTable3.Rows[0]["name"].ToString(), dataTable4.Rows[0]["name"].ToString(), barcodeid, dataTable3.Rows[0]["code"].ToString(), dataTable4.Rows[0]["code"].ToString());
DataGridViewButtonColumn dataGridViewButtonColumn = new DataGridViewButtonColumn();
dataGridViewButtonColumn.Text = "選擇";
dataGridViewButtonColumn.Name = "btn";
dataGridViewButtonColumn.HeaderText = "選取";
dataGridViewButtonColumn.UseColumnTextForButtonValue = true;
infolist.Columns.Add(dataGridViewButtonColumn);
}
}
public frmDialogMedNew(frmMainShopSimple frs, int count, string barcode)
{
InitializeComponent();
this.frs = frs;
this.count = count;
barcodeid = barcode;
string[] strWhereParameterArray = new string[1]
{
barcodeid
};
DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "*", "hypos_GOODSLST", "GDSNO = {0}", "", null, strWhereParameterArray, CommandOperationType.ExecuteReaderReturnDataTable);
_pesticideId = dataTable.Rows[0]["pesticideId"].ToString();
_formCode = dataTable.Rows[0]["formCode"].ToString();
_content = dataTable.Rows[0]["contents"].ToString();
hyscope.Text = "【" + getCommodityName(dataTable.Rows[0]) + "】用藥範圍設定";
string sql = "select cropId,pestId from hypos_user_pair where barcode = '" + barcodeid + "' order by total desc";
DataTable dataTable2 = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, sql, null, CommandOperationType.ExecuteReaderReturnDataTable);
if (dataTable2.Rows.Count <= 0)
{
return;
}
foreach (DataRow row in dataTable2.Rows)
{
string[] strWhereParameterArray2 = new string[1]
{
row["cropId"].ToString()
};
DataTable dataTable3 = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "code,name", "HyCrop", "code = {0}", "", null, strWhereParameterArray2, CommandOperationType.ExecuteReaderReturnDataTable);
string[] strWhereParameterArray3 = new string[1]
{
row["pestId"].ToString()
};
DataTable dataTable4 = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "code,name", "HyBlight", "code = {0}", "", null, strWhereParameterArray3, CommandOperationType.ExecuteReaderReturnDataTable);
infolist.Rows.Add(dataTable3.Rows[0]["name"].ToString(), dataTable4.Rows[0]["name"].ToString(), "選擇", "用藥說明", barcodeid, dataTable3.Rows[0]["code"].ToString(), dataTable4.Rows[0]["code"].ToString());
}
}
public frmCommdityList(frmMainShopSimple frs, string commodityName, string commodityNum, string CommodityClass, string[] strSearchConditionCommodityStatus)
: base("銷售作業")
{
InitializeComponent();
ucMembers = new CommodityInfoforSearch[10]
{
uC_Member1,
uC_Member2,
uC_Member3,
uC_Member4,
uC_Member5,
uC_Member6,
uC_Member7,
uC_Member8,
uC_Member9,
uC_Member10
};
this.frs = frs;
this.commodityName = commodityName;
this.commodityNum = commodityNum;
this.CommodityClass = CommodityClass;
_strSearchConditionCommodityStatus = strSearchConditionCommodityStatus;
}
public void setfms(frmMainShopSimple fms)
{
this.fms = fms;
}
public printsimple(frmMainShopSimple frs, DataGridView infolist)
{
InitializeComponent();
string text = DateTime.Now.ToString("yyyyMMdd HH:mm:ss");
string[,] strFieldArray = new string[11, 2]
{
{
"sellNo",
frs.getHseqNo()
},
{
"sellTime",
text
},
{
"memberId",
"test"
},
{
"sum",
"0"
},
{
"sumDiscount",
"0"
},
{
"sumRebate",
"0"
},
{
"cash",
"0"
},
{
"Credit",
"0"
},
{
"items",
frs.gettotalprice()
},
{
"itemstotal",
frs.gettotalpriceDiscount()
},
{
"status",
"1"
}
};
DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Insert, "", "hypos_main_sell", "", "", strFieldArray, null, CommandOperationType.ExecuteNonQuery);
for (int i = 0; i < infolist.Rows.Count; i++)
{
strFieldArray = new string[10, 2]
{
{
"sellNo",
frs.getHseqNo()
},
{
"barcode",
infolist.Rows[i].Cells[3].Value.ToString()
},
{
"fixedPrice",
"0"
},
{
"sellingPrice",
"0"
},
{
"num",
infolist.Rows[i].Cells[2].Value.ToString()
},
{
"discount",
"0"
},
{
"subtotal",
"0"
},
{
"total",
"0"
},
{
"PRNO",
"test"
},
{
"BLNO",
"test2"
}
};
DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Insert, "", "hypos_detail_sell", "", "", strFieldArray, null, CommandOperationType.ExecuteNonQuery);
}
MessageBox.Show("新增成功");
Barcode barcode = new Barcode();
barcode.IncludeLabel = true;
barcode.LabelFont = new Font("Verdana", 8f);
barcode.Width = 120;
barcode.Height = 60;
Image image = barcode.Encode(TYPE.CODE128, frs.getHseqNo(), barcode.Width, barcode.Height);
barcodeimg.Image = image;
label8.Text = frs.getHseqNo();
label9.Text = text;
itemsnum.Text = frs.gettotalprice();
totalnum.Text = frs.gettotalpriceDiscount();
tableLayoutPanel1.RowCount = 1;
Label label = new Label();
label.Text = "商品名稱";
Label label2 = label;
label2.Anchor = AnchorStyles.None;
tableLayoutPanel1.Controls.Add(label2, 1, 0);
Label label3 = new Label();
label3.Text = "數量";
label2 = label3;
label2.Anchor = AnchorStyles.None;
tableLayoutPanel1.Controls.Add(label2, 2, 0);
Label label4 = new Label();
label4.Text = "用藥範圍";
label2 = label4;
label2.Anchor = AnchorStyles.None;
tableLayoutPanel1.Controls.Add(label2, 3, 0);
for (int j = 0; j < infolist.Rows.Count; j++)
{
tableLayoutPanel1.RowCount += 1;
tableLayoutPanel1.RowStyles.Add(new RowStyle(SizeType.Percent, 100f));
Label label5 = new Label();
label5.Text = infolist.Rows[j].Cells[0].Value.ToString();
label2 = label5;
label2.Anchor = AnchorStyles.None;
tableLayoutPanel1.Controls.Add(label2, 0, tableLayoutPanel1.RowCount - 1);
Label label6 = new Label();
label6.Text = infolist.Rows[j].Cells[1].Value.ToString();
label2 = label6;
label2.Anchor = AnchorStyles.None;
tableLayoutPanel1.Controls.Add(label2, 1, tableLayoutPanel1.RowCount - 1);
Label label7 = new Label();
label7.Text = infolist.Rows[j].Cells[2].Value.ToString();
label2 = label7;
label2.Anchor = AnchorStyles.None;
tableLayoutPanel1.Controls.Add(label2, 2, tableLayoutPanel1.RowCount - 1);
}
}
