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