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