public frmMedGuide(frmCropGuide fcg, frmMainShopSimpleWithMoney fms, frmPestGuide fpg) : base("收銀作業") { InitializeComponent(); this.fcg = fcg; frsm = fms; this.fpg = fpg; addMed(this.fpg.realcropcode, this.fpg.pestcode); }
public frshyscorp(frmMainShopSimpleWithMoney frsm, string barcodeNum, string name) { this.frsm = frsm; 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 frmDialogMed(frmMainShopSimpleWithMoney frs, int count, string barcode) { InitializeComponent(); frsm = 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(frmMainShopSimpleWithMoney frs, int count, string barcode) { InitializeComponent(); frsm = 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(frmMainShopSimpleWithMoney frsm, 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.frsm = frsm; this.commodityName = commodityName; this.commodityNum = commodityNum; this.CommodityClass = CommodityClass; _strSearchConditionCommodityStatus = strSearchConditionCommodityStatus; }