private static string GetDBHardDiskSerialNo() { string sql = "SELECT HardDiskSerialNo FROM hypos_RegisterLicense where isApproved = 'Y' order by CreateDate desc limit 1"; string text = Convert.ToString(DataBaseUtilities.DBOperation(ConnectionString, sql, null, CommandOperationType.ExecuteScalar)); if ("-1".Equals(text)) { return(""); } return(text); }
private void loaddata() { string strWhereClause = " hypos_user_pair.barcode = '" + barcodeNum + "' and hypos_user_pair.cropId = HyCrop.code and hypos_user_pair.pestId = HyBlight.code "; dt = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "HyBlight.name as Blname,HyCrop.name as cropname,hypos_user_pair.cropId as hcropid,hypos_user_pair.pestId as hpestId ", "hypos_user_pair,HyBlight,HyCrop", strWhereClause, "", null, null, CommandOperationType.ExecuteReaderReturnDataTable); foreach (DataRow row in dt.Rows) { infolist.Rows.Add(row["cropname"].ToString(), row["Blname"].ToString(), "選擇", "用藥說明", barcodeNum, row["hcropid"].ToString(), row["hpestId"].ToString()); infolist.Rows[0].Selected = false; } }
private void btn_statusSuspend_Click(object sender, EventArgs e) { status = " status = 1 "; dt = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "CreateDate,SupplierNo,SupplierName,SupplierIdNo,Status", "hypos_Supplier", getWhereString(), orderByString, null, null, CommandOperationType.ExecuteReaderReturnDataTable); changePage(1); btn_statusAll.ForeColor = Color.FromArgb(247, 106, 45); btn_statusAll.BackColor = Color.White; btn_statusNormal.ForeColor = Color.FromArgb(247, 106, 45); btn_statusNormal.BackColor = Color.White; btn_statusSuspend.ForeColor = Color.White; btn_statusSuspend.BackColor = Color.FromArgb(247, 106, 45); }
private void btn_statusSuspend_Click(object sender, EventArgs e) { status = "'1'"; dt = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, selectStr, "hypos_DeliveryGoods_Master a, hypos_Supplier b", getWhereStr(), orderByStr, null, null, CommandOperationType.ExecuteReaderReturnDataTable); changePage(1); btn_statusAll.ForeColor = Color.FromArgb(247, 106, 45); btn_statusAll.BackColor = Color.White; btn_statusNormal.ForeColor = Color.FromArgb(247, 106, 45); btn_statusNormal.BackColor = Color.White; btn_statusCancel.ForeColor = Color.White; btn_statusCancel.BackColor = Color.FromArgb(247, 106, 45); }
private void dialogChooseSupplier_Load(object sender, EventArgs e) { DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "SupplierNo,SupplierName,SupplierIdNo,Status,vendorType", "hypos_Supplier", " Status = 0 and vendorType in (0,1)", " CreateDate Desc", null, null, CommandOperationType.ExecuteReaderReturnDataTable); if (dataTable.Rows.Count > 0) { for (int i = 0; i < dataTable.Rows.Count; i++) { dataGridView1.Rows.Insert(i, dataTable.Rows[i]["SupplierNo"].ToString(), dataTable.Rows[i]["SupplierIdNo"].ToString(), dataTable.Rows[i]["SupplierName"].ToString(), "選擇"); } } }
private void btnSubmit_Click(object sender, EventArgs e) { try { if (txtOrgID.Text.Length <= 0) { MessageBox.Show("組織代碼不得為空"); } else if (!CommonUtilities.isInteger(txtOrgID.Text)) { MessageBox.Show("請輸入正確組織代碼格式"); } else if (NetworkInfo.IsConnectionExist(Program.WebServiceHostNameOL)) { Service service = new Service(); service.Url = Program.OLPUrl; service.Timeout = 800000; switch (service.UploadSN(lblsysSerialNo.Text, txtOrgID.Text)) { case "0": MessageBox.Show("上傳成功!"); DataBaseUtilities.DBOperation(Program.ConnectionString, "Update SysParam set OrgID = {0}", new string[1] { txtOrgID.Text }, CommandOperationType.ExecuteNonQuery); base.DialogResult = DialogResult.OK; Close(); break; case "1": MessageBox.Show("上傳失敗,請輸入正確組織代碼!"); break; case "2": MessageBox.Show("上傳組織代碼失敗,請稍候重試。"); break; default: MessageBox.Show("上傳主機失敗,請稍候重試。"); break; } } else { MessageBox.Show("目前無法連上主機,請稍候重試。"); } } catch (Exception) { MessageBox.Show("目前無法連上主機,請稍候重試。"); Close(); } }
private static void AutoBackupDT() { string text = DataBaseUtilities.DBOperation(ConnectionString, TableOperation.Select, "AutoBackupPath", "hypos_CommonManage", "", "", null, null, CommandOperationType.ExecuteScalar).ToString(); if (!Directory.Exists(text)) { Directory.CreateDirectory(text); } string str = "db_DT_" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".db3"; File.Copy(DataPath + "\\db.db3", text + "\\" + str); }
private DataTable getGoodsList(List <string> barCodeList) { string strSelectField = "CLA1NO, GDSNO, pesticideId, ISWS, SubsidyFertilizer"; string text = "GDSNO in ("; for (int i = 0; i < barCodeList.Count; i++) { text = text + "{" + i + "},"; } text = text.Substring(0, text.Length - 1) + ")"; return((DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, strSelectField, "hypos_GOODSLST", text, "", null, barCodeList.ToArray(), CommandOperationType.ExecuteReaderReturnDataTable)); }
private void CommonUtilities() { if (!Directory.Exists("TempBarCode")) { Directory.CreateDirectory("TempBarCode"); } _ExePath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location); string sql = "SELECT ShopName FROM hypos_RegisterLicense where isApproved = 'Y' order by CreateDate desc limit 1"; _shopName = Convert.ToString(DataBaseUtilities.DBOperation(Program.ConnectionString, sql, null, CommandOperationType.ExecuteScalar)); string sql2 = "SELECT barcode, num, sellingPrice, subtotal, BatchNo, MFGDate, POSBatchNo FROM hypos_DeliveryGoods_Detail where DeliveryNo='" + _DeliveryNo + "'"; DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, sql2, null, CommandOperationType.ExecuteReaderReturnDataTable); List <string> list = new List <string>(); for (int i = 0; i < dataTable.Rows.Count; i++) { list.Add(dataTable.Rows[i]["barcode"].ToString()); } _detailSell = dataTable; _detailList = list; string strSelectField = "GDSNO,GDName,CName,contents,brandName,spec,capacity,formCode"; string text = "GDSNO in ("; for (int j = 0; j < _detailList.Count; j++) { text = text + "{" + j + "},"; } text = text.Substring(0, text.Length - 1) + ")"; DataTable dataTable2 = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, strSelectField, "hypos_GOODSLST", text, "", null, _detailList.ToArray(), CommandOperationType.ExecuteReaderReturnDataTable); Dictionary <string, int> dictionary = new Dictionary <string, int>(); for (int k = 0; k < dataTable2.Rows.Count; k++) { dictionary.Add(dataTable2.Rows[k]["GDSNO"].ToString(), k); } _barCode = dataTable2; _barCodeMap = dictionary; string sql3 = "SELECT ReceiveType, ReceivePrinterName FROM hypos_PrinterManage "; DataTable dataTable3 = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, sql3, null, CommandOperationType.ExecuteReaderReturnDataTable); _printerType = "A4"; _printerName = dataTable3.Rows[0]["ReceivePrinterName"].ToString(); string str = _DeliveryNo + ".gif"; string filename = _imagePath = _ExePath + "\\TempBarCode\\" + str; Barcode barcode = new Barcode(); barcode.IncludeLabel = true; barcode.LabelFont = new Font("Verdana", 8f); barcode.Width = 181; barcode.Height = 54; barcode.Encode(TYPE.CODE128, _DeliveryNo, barcode.Width, barcode.Height).Save(filename, ImageFormat.Gif); }
private void button1_Click(object sender, EventArgs e) { string sql = "SELECT SystemMode FROM hypos_SysParam"; string text = DataBaseUtilities.DBOperation(Program.ConnectionString, sql, null, CommandOperationType.ExecuteScalar).ToString(); if ("".Equals(text)) { switchForm(new frmMode()); return; } Program.SystemMode = int.Parse(text); switchForm(new frmMain()); }
public void UpdateDeliveryMangemnetPage() { status = ""; dt = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, selectStr, "hypos_DeliveryGoods_Master a, hypos_Supplier b", getWhereStr(), orderByStr, null, null, CommandOperationType.ExecuteReaderReturnDataTable); pageTotal = (int)Math.Ceiling((double)dt.Rows.Count / (double)pageSize); changePage(1); btn_statusAll.ForeColor = Color.White; btn_statusAll.BackColor = Color.FromArgb(247, 106, 45); btn_statusNormal.ForeColor = Color.FromArgb(247, 106, 45); btn_statusNormal.BackColor = Color.White; btn_statusCancel.ForeColor = Color.FromArgb(247, 106, 45); btn_statusCancel.BackColor = Color.White; }
public frmNoSaleReport() : base("無銷售回報") { InitializeComponent(); string sql = "SELECT RegisterCode FROM hypos_RegisterLicense where isApproved = 'Y' order by CreateDate desc limit 1"; _RegisterCode = Convert.ToString(DataBaseUtilities.DBOperation(Program.ConnectionString, sql, null, CommandOperationType.ExecuteScalar)); string text = ""; string str = Uri.EscapeDataString(_RegisterCode); text = "https://pest.baphiq.gov.tw/BAPHIQ/wSite/upos/sale_no.jsp?applySerial=" + str + "&version=" + Program.Version; webBrowser1.Navigate(text); }
private void btn_statusNormal_Click(object sender, EventArgs e) { status = "'0','1'"; dt = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, selectStr, "hypos_PurchaseGoods_Master a, hypos_Supplier b", getWhereStr(), orderByStr, null, null, CommandOperationType.ExecuteReaderReturnDataTable); pageTotal = (int)Math.Ceiling((double)dt.Rows.Count / (double)pageSize); changePage(1); btn_statusAll.ForeColor = Color.FromArgb(247, 106, 45); btn_statusAll.BackColor = Color.White; btn_statusNormal.ForeColor = Color.White; btn_statusNormal.BackColor = Color.FromArgb(247, 106, 45); btn_statusCancel.ForeColor = Color.FromArgb(247, 106, 45); btn_statusCancel.BackColor = Color.White; }
private void btn_statusAll_Click(object sender, EventArgs e) { dt = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "hms.sellNo,hms.sellTime,hms.memberId,hms.items,hcr.Name,hcr.Mobile ,hcr.IdNo,hcr.CompanyIdNo,hms.cash,hms.Credit,hms.sum ", "hypos_main_sell as hms left outer join hypos_CUST_RTL as hcr on hms.memberId= hcr.VipNo", "", "", null, null, CommandOperationType.ExecuteReaderReturnDataTable); pageTotal = (int)Math.Ceiling((double)dt.Rows.Count / 8.0); changePage(1); btn_statusAll.ForeColor = Color.White; btn_statusAll.BackColor = Color.FromArgb(247, 106, 45); btn_statusNormal.ForeColor = Color.FromArgb(247, 106, 45); btn_statusNormal.BackColor = Color.White; btn_statusSuspend.ForeColor = Color.FromArgb(247, 106, 45); btn_statusSuspend.BackColor = Color.White; button3.ForeColor = Color.FromArgb(247, 106, 45); button3.BackColor = Color.White; }
private void clslit3_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 1) { string text = clslit3["code", e.RowIndex].Value.ToString(); string text2 = clslit3["cropId", e.RowIndex].Value.ToString(); string text3 = clslit3["pestId", e.RowIndex].Value.ToString(); string formCode = clslit3["formcode", e.RowIndex].Value.ToString(); string text4 = clslit3["Contents", e.RowIndex].Value.ToString(); new dialogMedDescription(text, text2, text3, formCode, text4).ShowDialog(); return; } barcodelist.Clear(); clslit4.Rows.Clear(); string text5 = clslit3.CurrentRow.Cells["cropId"].Value.ToString(); string text6 = clslit3.CurrentRow.Cells["pestId"].Value.ToString(); string text7 = clslit3.CurrentRow.Cells["code"].Value.ToString(); string text8 = clslit3.CurrentRow.Cells["formcode"].Value.ToString(); string text9 = clslit3.CurrentRow.Cells["Contents"].Value.ToString(); string[] strWhereParameterArray = new string[3] { text7, text8, text9 }; DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "licType,licNo,pesticideName,domManufId,domManufName", "HyLicence", "pesticideId={0} and formCode={1} and contents={2} and isDelete='N'", "licNo", null, strWhereParameterArray, CommandOperationType.ExecuteReaderReturnDataTable); if (dataTable.Rows.Count <= 0) { return; } foreach (DataRow row in dataTable.Rows) { string[] strWhereParameterArray2 = new string[2] { row["licNo"].ToString(), row["licType"].ToString() }; DataTable dataTable2 = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "spec,GDSNO,capacity,GDName", "hypos_GOODSLST", "domManufId={0} and licType ={1} and status !='D' ", "barcode", null, strWhereParameterArray2, CommandOperationType.ExecuteReaderReturnDataTable); if (dataTable2.Rows.Count <= 0) { continue; } foreach (DataRow row2 in dataTable2.Rows) { clslit4.Rows.Add(row2["GDName"].ToString() + "[" + row["domManufName"].ToString() + "] \r\n" + row2["spec"].ToString() + " " + row2["capacity"].ToString(), row2["GDSNO"].ToString(), text5, text6, text7, text8, text9); } } }
private void dialogChooseVendors_Load(object sender, EventArgs e) { DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "SupplierNo,SupplierName,SupplierIdNo,Status", "hypos_Supplier", " Status = 0", " CreateDate Desc", null, null, CommandOperationType.ExecuteReaderReturnDataTable); if (dataTable.Rows.Count > 0) { for (int i = 0; i < dataTable.Rows.Count; i++) { dataGridView1.Rows.Insert(i, false, dataTable.Rows[i]["SupplierIdNo"].ToString(), dataTable.Rows[i]["SupplierName"].ToString(), "選擇", dataTable.Rows[i]["SupplierNo"].ToString()); } } tb_keyword.Focus(); tb_keyword.SelectionStart = tb_keyword.Text.Length; }
private void dialogPurchaseUpdateLog_Load(object sender, EventArgs e) { DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "*", "hypos_PurchaseGoods_Detail_Log l, hypos_GOODSLST g", " l.GDSNO = g.GDSNO and PurchaseNo = {0}", " updateDate Desc", null, new string[1] { _PurchaseNo }, CommandOperationType.ExecuteReaderReturnDataTable); if (dataTable.Rows.Count <= 0) { return; } string text = ""; string text2 = ""; for (int i = 0; i < dataTable.Rows.Count; i++) { if (string.IsNullOrEmpty(text)) { text = dataTable.Rows[i]["updateDate"].ToString(); } if (!text.Equals(dataTable.Rows[i]["updateDate"].ToString())) { dataGridView1.Rows.Add(dataGridView1.RowCount + 1, text, text2); text2 = ""; text = dataTable.Rows[i]["updateDate"].ToString(); } string text3 = (Math.Sign(int.Parse(dataTable.Rows[i]["adjustQuantity"].ToString())) >= 0) ? ("+" + dataTable.Rows[i]["adjustQuantity"].ToString()) : dataTable.Rows[i]["adjustQuantity"].ToString(); string text4 = (Math.Sign(int.Parse(dataTable.Rows[i]["adjustMoney"].ToString())) >= 0) ? ("+" + dataTable.Rows[i]["adjustMoney"].ToString()) : dataTable.Rows[i]["adjustMoney"].ToString(); string text5 = ""; string a = dataTable.Rows[i]["adjustType"].ToString(); if (!(a == "E")) { if (a == "F") { text5 = "(過期退回)"; } } else { text5 = "(原廠退貨)"; } text2 = text2 + dataTable.Rows[i]["GDSNO"].ToString() + "\n" + getCommodityName(dataTable.Rows[i]) + "(" + text3 + "/" + text4 + ")" + text5 + "\n"; } if (!string.IsNullOrEmpty(text2)) { dataGridView1.Rows.Add(dataGridView1.RowCount + 1, text, text2); text2 = ""; } }
public frmSearchCommodityDeliverySummary(DataTable dt_summary, DataTable dt_details, string strFromDate, string strToDate, string data_type, string goods_type, string goods_status) : base("報表查詢") { _dt_summary = dt_summary; _dt_details = dt_details; _strFromDate = strFromDate; _strToDate = strToDate; _data_type = data_type; _goods_type = goods_type; _goods_status = goods_status; string text = "出貨商品:"; InitializeComponent(); label3.Text = strFromDate + " ~ " + strToDate; if (_dt_details.Rows.Count > 0) { int num = 0; int num2 = 0; int result = 0; for (int i = 0; i < _dt_details.Rows.Count; i++) { int.TryParse(_dt_details.Rows[i]["total"].ToString(), out result); num += result; int.TryParse(_dt_details.Rows[i]["num"].ToString(), out result); num2 += result; text = text + "[" + _dt_details.Rows[i]["GDName"].ToString() + "]"; dataGridView2.Rows.Add(string.IsNullOrEmpty(_dt_details.Rows[i]["barcode"].ToString()) ? "" : _dt_details.Rows[i]["barcode"].ToString(), _dt_details.Rows[i]["GDName"].ToString() + "[" + _dt_details.Rows[i]["CName"].ToString() + "-" + _dt_details.Rows[i]["formCode"].ToString() + "." + _dt_details.Rows[i]["contents"].ToString() + "-" + _dt_details.Rows[i]["brandName"].ToString() + "]" + _dt_details.Rows[i]["spec"].ToString() + _dt_details.Rows[i]["capacity"].ToString(), string.IsNullOrEmpty(_dt_details.Rows[i]["num"].ToString()) ? "" : _dt_details.Rows[i]["num"].ToString(), string.IsNullOrEmpty(_dt_details.Rows[i]["total"].ToString()) ? "" : _dt_details.Rows[i]["total"].ToString()); List <string> list = new List <string>(); int num3 = 0; string text2 = "SELECT pgb.*,dgd.DeliveryDate FROM hypos_PurchaseGoodsBatchNo_log as pgb inner join hypos_DeliveryGoods_Master as dgd on pgb.PurchaseNo = dgd.DeliveryNo left JOIN hypos_GOODSLST as gl on pgb.barcode = gl.GDSNO where pgb.barcode = '" + _dt_details.Rows[i]["barcode"].ToString() + "' and gl.CLA1NO = '0302' "; text2 = text2 + " and dgd.DeliveryDate between {" + num3 + "} "; list.Add(strFromDate); num3++; text2 = text2 + " and datetime(date( {" + num3 + "} ), '+1 days') "; list.Add(strToDate); num3++; DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, text2, list.ToArray(), CommandOperationType.ExecuteReaderReturnDataTable); if (dataTable.Rows.Count > 0) { for (int j = 0; j < dataTable.Rows.Count; j++) { dataGridView2.Rows.Add("", dataTable.Rows[j]["BatchNo"].ToString() + "/" + dataTable.Rows[j]["DeliveryDate"].ToString(), dataTable.Rows[j]["num"].ToString()); } } } dataGridView1.Rows.Add(num, num2, _dt_details.Rows.Count); } label2.Text = text; }
private int CheckRepeat_fuzzy() { int num = 0; DataTable dataTable = new DataTable(); string text = "SELECT * FROM Record WHERE LogicDel=0 AND VaccineCode = '" + cb_VaccineCode.SelectedValue.ToString() + "' AND "; dataTable = (DataTable)DataBaseUtilities.DBOperation(sql: (!(tb_RocID.Text.Trim() != "")) ? (text + "ParentRocID = '" + tb_ParentRocID.Text + "' AND BirthSeq='" + cb_BirthSeq.Text + "' AND Birthday = '" + Utility.ToRocDateString(Convert.ToDateTime(tb_Birthday2.Text)) + "' and (ExportedDate is null or ExportedDate='" + Utility.ToRocDateString(DateTime.Now) + "')") : (text + "RocID = '" + tb_RocID.Text + "' AND Birthday = '" + Utility.ToRocDateString(Convert.ToDateTime(tb_Birthday.Text)) + "' and (ExportedDate is null or ExportedDate='" + Utility.ToRocDateString(DateTime.Now) + "')"), ConnectionString: Program.ConnectionString, strParameterArray: null, cmdType: CommandOperationType.ExecuteReaderReturnDataTable); if (tb_RocID.Text.Trim() != "") { DataRow[] array = dt.Select("VaccineCode='" + cb_VaccineCode.SelectedValue.ToString() + "' and RocID = '" + tb_RocID.Text + "'"); return(dataTable.Rows.Count + array.Length); } DataRow[] array2 = dt.Select("VaccineCode='" + cb_VaccineCode.SelectedValue.ToString() + "' and ParentRocID = '" + tb_ParentRocID.Text + "'"); return(dataTable.Rows.Count + array2.Length); }
protected string GetStoreID(string id) { DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "shipDateTime, storedId, strBARCODE, batchNO, MFD, shipQTY, shipOrReturn , b.SupplierName , b.SupplierIdNo ", " HyShipData_sub a join hypos_Supplier b on a.storedId = b.vendorId ", " 1=1 and a.LogicDel = 'N' and b.vendorName = {0} ", "", null, new string[1] { id }, CommandOperationType.ExecuteReaderReturnDataTable); string text = ""; if (dataTable.Rows.Count > 0) { text = dataTable.Rows[0]["storedId"].ToString(); } id = text; return(id); }
private void Form_Main_Load(object sender, EventArgs e) { string sql = "select VaccineCode,VaccineNo,VaccBatchNo,VaccineCode || ' ('||ChName|| ')' ChName from VaccineData"; DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, sql, null, CommandOperationType.ExecuteReaderReturnDataTable); if (dataTable.Rows.Count == 0) { MessageBox.Show("尚未匯入疫苗批次資料,請先進行檔案匯入!", "系統提醒", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); Form_ImportBatchNo form_ImportBatchNo = new Form_ImportBatchNo(); form_ImportBatchNo.FormClosed += ChildFormClosed; form_ImportBatchNo.AgencyCode = AgencyCode; form_ImportBatchNo.Show(this); Hide(); } }
private void btn_UpdatePrice_Click(object sender, EventArgs e) { int result = 0; string text = tb_newPrice.Text.Trim(); if (int.TryParse(tb_newPrice.Text.Trim(), out result)) { DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_DeliveryPrice_log set status = 'N' where GDSNO = {0}", new string[1] { _GDSNO }, CommandOperationType.ExecuteNonQuery); DataBaseUtilities.DBOperation(Program.ConnectionString, "UPDATE hypos_GOODSLST set DeliveryPrice = {1} where GDSNO = {0}", new string[2] { _GDSNO, text }, CommandOperationType.ExecuteNonQuery); string[,] strFieldArray = new string[5, 2] { { "GDSNO", _GDSNO }, { "Account", Program.Casher }, { "price", text }, { "status", "Y" }, { "editDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") } }; DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Insert, "", "hypos_DeliveryPrice_log", null, null, strFieldArray, null, CommandOperationType.ExecuteNonQuery); if (base.Owner != null) { (base.Owner as frmEditCommodity).textBox1.Text = text; (base.Owner as frmEditCommodity)._DeliveryPrice = text; } dialogDeliveryPriceLog_Load(sender, e); } }
protected string GetshipDateTime2(string stroreid, string barcode, string batchNO) { DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "shipDateTime, storedId, strBARCODE, batchNO, MFD, shipQTY, shipOrReturn , b.SupplierName , b.SupplierIdNo ", " HyShipData_sub a join hypos_Supplier b on a.storedId = b.vendorId ", " 1=1 and a.LogicDel = 'N' and a.storeName = {0} and strBARCODE = {1} and batchNO = {2} and shipOrReturn = 'K' ", "", null, new string[3] { stroreid, barcode, batchNO }, CommandOperationType.ExecuteReaderReturnDataTable); string result = ""; if (dataTable.Rows.Count > 0) { result = dataTable.Rows[0]["shipDateTime"].ToString(); } return(result); }
private void btn_quickSearch_Click(object sender, EventArgs e) { dataGridView1.Rows.Clear(); DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "SupplierNo,SupplierName,SupplierIdNo,Status", "hypos_Supplier", " Status = 0 and (SupplierIdNo like {0} or SupplierName like {0})", " CreateDate Desc", null, new string[1] { "%" + tb_keyword.Text + "%" }, CommandOperationType.ExecuteReaderReturnDataTable); if (dataTable.Rows.Count > 0) { for (int i = 0; i < dataTable.Rows.Count; i++) { dataGridView1.Rows.Insert(i, false, dataTable.Rows[i]["SupplierIdNo"].ToString(), dataTable.Rows[i]["SupplierName"].ToString(), "選擇", dataTable.Rows[i]["SupplierNo"].ToString()); } } }
public string retailData() { Program.Logger.Info("[驗證店家購肥帳密] -- 開始"); string result = ""; if (NetworkInterface.GetIsNetworkAvailable()) { DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "FertilizerAccount,FertilizerPassword,DealerNo", "hypos_ShopInfoManage", "", "ShopIdNo limit 1", null, null, CommandOperationType.ExecuteReaderReturnDataTable); if (dataTable.Rows.Count > 0) { try { Program.Logger.Info("[驗證店家購肥帳密] -- 資料上傳至WS 開始"); POSService pOSService = new POSService(); pOSService.Url = Program.VerificationURL; Program.Logger.Info("[驗證店家購肥帳密] -- 上傳資料\nL:" + Program.LincenseCode + "\nFA:" + dataTable.Rows[0]["FertilizerAccount"].ToString() + "\nFP:" + dataTable.Rows[0]["FertilizerPassword"].ToString() + "\nD:" + dataTable.Rows[0]["DealerNo"].ToString() + "\n"); string xml = pOSService.sendRetailData(Program.LincenseCode, dataTable.Rows[0]["FertilizerAccount"].ToString(), dataTable.Rows[0]["FertilizerPassword"].ToString(), dataTable.Rows[0]["DealerNo"].ToString()); Program.Logger.Info("[驗證店家購肥帳密] -- 資料上傳至WS 結束"); XmlDocument xmlDocument = new XmlDocument(); xmlDocument.LoadXml(xml); XmlNodeList xmlNodeList = xmlDocument.SelectNodes("//RetailData"); if (xmlNodeList.Count <= 0) { return("無WebService驗證回傳資料"); } for (int i = 0; i < xmlNodeList.Count; i++) { string innerText = xmlNodeList[i].SelectSingleNode("status").InnerText; result = ((!"Y".Equals(innerText)) ? "購肥帳號密碼驗證錯誤" : "驗證成功"); Program.Logger.Info("[驗證店家購肥帳密] -- 由WS收到訊息為\nS:" + (string.IsNullOrEmpty(innerText) ? "Null" : innerText)); } return(result); } catch (Exception ex) { Program.Logger.Fatal("[驗證店家購肥帳密] -- 發生例外狀況:" + ex.ToString()); return("發生錯誤 : " + ex.Message); } } } else { Program.Logger.Info("[驗證店家購肥帳密] -- 離線中,請檢查網路"); result = "偵測不到網路連線,請確認網路正常後再選入商品"; } return(result); }
private void dialogChooseSupplier_Load(object sender, EventArgs e) { DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, TableOperation.Select, "SupplierNo,SupplierName,SupplierIdNo,Status", "hypos_Supplier", " Status = 0", " CreateDate Desc", null, null, CommandOperationType.ExecuteReaderReturnDataTable); if (dataTable.Rows.Count > 0) { for (int i = 0; i < dataTable.Rows.Count; i++) { dataGridView1.Rows.Add(false, dataTable.Rows[i]["SupplierIdNo"].ToString(), dataTable.Rows[i]["SupplierName"].ToString(), dataTable.Rows[i]["SupplierNo"].ToString()); } } if (dataGridView1.CurrentCell != null) { dataGridView1.ClearSelection(); dataGridView1.CurrentRow.Selected = false; } }
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(); }
private void btn_enter_Click(object sender, EventArgs e) { if (tb_vipNo.Text == "請輸入會員編號" && tb_vipName.Text == "請輸入會員姓名" && tb_vipTelNo.Text == "請輸入會員電話" && tb_IdNo.Text == "請輸入身分證字號") { AutoClosingMessageBox.Show("必須輸入查詢條件"); return; } btn_pageLeft.Visible = true; btn_pageRight.Visible = true; l_pageInfo.Visible = true; label1.Text = "會員搜尋結果"; int num = 0; List <string> list = new List <string>(); string text = "SELECT * FROM hypos_CUST_RTL WHERE status = 0 "; if (tb_vipNo.Text != "請輸入會員編號") { text = text + " AND VipNo like {" + num + "}"; list.Add("%" + tb_vipNo.Text + "%"); num++; } if (tb_vipName.Text != "請輸入會員姓名") { text = text + " AND Name like {" + num + "}"; list.Add("%" + tb_vipName.Text + "%"); num++; } if (tb_IdNo.Text != "請輸入身分證字號") { text = text + " AND IdNo like {" + num + "}"; list.Add("%" + tb_vipTelNo.Text + "%"); num++; } if (tb_vipTelNo.Text != "請輸入會員電話") { text = text + " AND (Telphone like {" + num + "}"; list.Add("%" + tb_vipTelNo.Text + "%"); num++; text = text + " OR Mobile like {" + num + "})"; list.Add("%" + tb_vipTelNo.Text + "%"); num++; } dt = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, text, list.ToArray(), CommandOperationType.ExecuteReaderReturnDataTable); changePage(1); }
private void btn_Export_Click(object sender, EventArgs e) { try { DataTable dataTable = new DataTable(); DataTable dataTable2 = new DataTable(); string str = ""; string str2 = ""; if (aa == 1) { str = str + "select RocID,CaseName, Sex,Birthday,BirthSeq,Address,Tel,ParentRocID,AgencyCode,InoculationDate,VaccineCode,VaccineNo,VaccBatchNo,'' as '疫苗廠商',(select BatchType from VaccineData where VaccBatchNo=Record.VaccBatchNo order by BatchType desc LIMIT 1 ) 疫苗型別,'' AS '曾接種流感疫苗' from Record where isFlu=0 and (ExportedDate is null or ExportedDate='" + Utility.ToRocDateString(DateTime.Now) + "');"; str2 = str2 + "select RocID,CaseName,Birthday,Address,Tel,ParentRocID,AgencyCode,InoculationDate,VaccBatchNo, (select ChName from VaccineData where VaccBatchNo=Record.VaccBatchNo order by ChName desc limit 1),VaccineNo from Record where isFlu=1 and (ExportedDate is null or ExportedDate='" + Utility.ToRocDateString(DateTime.Now) + "');"; } else { str += "select RocID,CaseName, Sex,Birthday,BirthSeq,Address,Tel,ParentRocID,AgencyCode,InoculationDate,VaccineCode,VaccineNo,VaccBatchNo,'' as '疫苗廠商',(select BatchType from VaccineData where VaccBatchNo=Record.VaccBatchNo order by BatchType desc LIMIT 1 ) as '疫苗型別','' as '曾接種流感疫苗' from Record where isFlu=0 and ExportedDate is null;"; str2 += "select RocID,CaseName,Birthday,Address,Tel,ParentRocID,AgencyCode,InoculationDate,VaccBatchNo, (select ChName from VaccineData where VaccBatchNo=Record.VaccBatchNo order by ChName desc limit 1),VaccineNo from Record where isFlu=1 and ExportedDate is null;"; } string str3 = "update Record set ExportedDate='" + Utility.ToRocDateString(DateTime.Now) + "' where ExportedDate is null"; dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, str, null, CommandOperationType.ExecuteReaderReturnDataTable); dataTable2 = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, str2 + str3, null, CommandOperationType.ExecuteReaderReturnDataTable); FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog(); folderBrowserDialog.ShowDialog(); if (folderBrowserDialog.SelectedPath == "") { MessageBox.Show("請選擇匯出檔案要儲存的資料夾"); } else { string str4 = folderBrowserDialog.SelectedPath + "\\"; string text = "預注資料" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv"; GenFile(dataTable, str4 + text); string text2 = "流感資料" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv"; GenFile_Flu(dataTable2, str4 + text2); MessageBox.Show(text + "、" + text2 + " 匯出成功!", "匯出成功", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); Close(); } } catch (Exception ex) { MessageBox.Show("匯出失敗,原因:" + ex.Message, "發生錯誤", MessageBoxButtons.OK, MessageBoxIcon.Hand); string str5 = "C:\\NIISOL\\"; Utility.WriteToFile(str5 + "\\" + DateTime.Now.ToString("yyyy-MM-dd") + "_log.txt", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "\tForm_Export.cs: " + ex.Message, 'A', ""); } }
private void btn_view_Click(object sender, EventArgs e) { DateTime dateTime = DateTime.Now.AddMonths(-2); DateTime now = DateTime.Now; string text = new DateTime(dateTime.Year, dateTime.Month, 1, 0, 0, 0).ToString("yyyy-MM-dd HH:mm:ss"); string text2 = new DateTime(now.Year, now.Month, DateTime.DaysInMonth(now.Year, now.Month), 23, 59, 59).ToString("yyyy-MM-dd HH:mm:ss"); string sql = "SELECT hms.sellNo,hms.sellTime,hms.memberId,hms.items,hcr.Name,hcr.Mobile ,hcr.IdNo,hcr.CompanyIdNo,hms.cash,hms.Credit,hms.sum FROM hypos_main_sell as hms left outer join hypos_CUST_RTL as hcr on hms.memberId= hcr.VipNo WHERE sellTime >='" + text + "' and sellTime <='" + text2 + "'"; DataTable dataTable = (DataTable)DataBaseUtilities.DBOperation(Program.ConnectionString, sql, null, CommandOperationType.ExecuteReaderReturnDataTable); if (dataTable.Rows.Count > 0) { switchForm(new frmSearchSellResult_View(dataTable)); } else { AutoClosingMessageBox.Show("無近期銷售單"); } }