private void initConfig() { itmC = new ItemsCat(); itmC.item_cat_id = "item_cat_id"; itmC.item_cat_code = "item_cat_code"; itmC.item_cat_name_e = "item_cat_name_e"; itmC.item_cat_name_t = "item_cat_name_t"; //tmn.status_app = "status_app"; itmC.sort1 = "sort1"; itmC.active = "active"; itmC.date_create = "date_create"; itmC.date_modi = "date_modi"; itmC.date_cancel = "date_cancel"; itmC.user_create = "user_create"; itmC.user_modi = "user_modi"; itmC.user_cancel = "user_cancel"; //tmn.status_app = "status_app"; itmC.remark = "remark"; itmC.table = "b_items_cat"; itmC.pkField = "expenses_cat_id"; lexpnC = new List <ItemsCat>(); }
private void initConfig() { expnC = new ItemsCat(); fEdit = new Font(xC.iniC.grdViewFontName, xC.grdViewFontSize, FontStyle.Regular); fEditB = new Font(xC.iniC.grdViewFontName, xC.grdViewFontSize, FontStyle.Bold); C1ThemeController.ApplicationTheme = xC.iniC.themeApplication; theme1.Theme = C1ThemeController.ApplicationTheme; theme1.SetTheme(sB, "BeigeOne"); foreach (Control c in panel3.Controls) { theme1.SetTheme(c, "Office2013Red"); } bg = txtCode.BackColor; fc = txtCode.ForeColor; ff = txtCode.Font; txtPasswordVoid.KeyUp += TxtPasswordVoid_KeyUp; btnNew.Click += BtnNew_Click; btnEdit.Click += BtnEdit_Click; btnSave.Click += BtnSave_Click; initGrfDept(); setGrfDeptH(); setControlEnable(false); setFocusColor(); sB1.Text = ""; btnVoid.Hide(); txtPasswordVoid.Hide(); stt = new C1SuperTooltip(); sep = new C1SuperErrorProvider(); //stt.BackgroundGradient = C1.Win.C1SuperTooltip.BackgroundGradient.Gold; }
public String update(ItemsCat p, String userId) { String re = ""; String sql = ""; int chk = 0; chkNull(p); sql = "Update " + itmC.table + " Set " + " " + itmC.item_cat_code + " = '" + p.item_cat_code + "'" + "," + itmC.item_cat_name_e + " = '" + p.item_cat_name_e.Replace("'", "''") + "'" + "," + itmC.item_cat_name_t + " = '" + p.item_cat_name_t.Replace("'", "''") + "'" + "," + itmC.remark + " = '" + p.remark.Replace("'", "''") + "'" + "," + itmC.date_modi + " = now()" + "," + itmC.user_modi + " = '" + userId + "' " + "," + itmC.sort1 + " = '" + p.sort1 + "' " + //"," + tmn.status_app + " = '" + p.status_app + "' " + "Where " + itmC.pkField + "='" + p.item_cat_id + "'" ; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
public String insert(ItemsCat p, String userId) { String re = ""; String sql = ""; p.active = "1"; //p.ssdata_id = ""; int chk = 0; chkNull(p); //p.prefix_id = int.TryParse(p.prefix_id, out chk) ? chk.ToString() : "0"; //p.dept_id = int.TryParse(p.dept_id, out chk) ? chk.ToString() : "0"; sql = "Insert Into " + itmC.table + "(" + itmC.item_cat_code + "," + itmC.item_cat_name_e + "," + itmC.item_cat_name_t + "," + itmC.date_create + "," + itmC.date_modi + "," + itmC.date_cancel + "," + itmC.user_create + "," + itmC.user_modi + "," + itmC.user_cancel + "," + itmC.active + "," + itmC.remark + ", " + itmC.sort1 + " " + ") " + "Values ('" + p.item_cat_code + "','" + p.item_cat_name_e.Replace("'", "''") + "','" + p.item_cat_name_t.Replace("'", "''") + "'," + "'" + p.date_create + "','" + p.date_modi + "','" + p.date_cancel + "'," + "'" + userId + "','" + p.user_modi + "','" + p.user_cancel + "'," + "'" + p.active + "','" + p.remark.Replace("'", "''") + "','" + p.sort1 + "' " + ")"; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
private void setControl(String deptId) { expnC = xC.iniDB.itmcDB.selectByPk1(deptId); txtID.Value = expnC.item_cat_id; txtCode.Value = expnC.item_cat_code; txtNameT.Value = expnC.item_cat_name_t; txtRemark.Value = expnC.remark; }
public ItemsCat selectByPk1(String copId) { ItemsCat cop1 = new ItemsCat(); DataTable dt = new DataTable(); String sql = "select expC.* " + "From " + itmC.table + " expC " + //"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " + "Where expC." + itmC.pkField + " ='" + copId + "' "; dt = conn.selectData(conn.conn, sql); cop1 = setExpenseCat(dt); return(cop1); }
public String insertExpenseCat(ItemsCat p, String userId) { String re = ""; if (p.item_cat_id.Equals("")) { re = insert(p, userId); } else { re = update(p, userId); } return(re); }
private void chkNull(ItemsCat p) { int chk = 0; Decimal chk1 = 0; p.date_modi = p.date_modi == null ? "" : p.date_modi; p.date_cancel = p.date_cancel == null ? "" : p.date_cancel; p.user_create = p.user_create == null ? "" : p.user_create; p.user_modi = p.user_modi == null ? "" : p.user_modi; p.user_cancel = p.user_cancel == null ? "" : p.user_cancel; p.item_cat_code = p.item_cat_code == null ? "" : p.item_cat_code; p.item_cat_name_e = p.item_cat_name_e == null ? "" : p.item_cat_name_e; p.item_cat_name_t = p.item_cat_name_t == null ? "" : p.item_cat_name_t; p.remark = p.remark == null ? "" : p.remark; p.sort1 = p.sort1 == null ? "" : p.sort1; }
public void getlexpnC() { //lDept = new List<Department>(); DataTable dt = new DataTable(); dt = selectAll(); foreach (DataRow row in dt.Rows) { ItemsCat curr1 = new ItemsCat(); curr1.item_cat_id = row[itmC.item_cat_id].ToString(); curr1.item_cat_code = row[itmC.item_cat_code].ToString(); curr1.item_cat_name_e = row[itmC.item_cat_name_e].ToString(); curr1.item_cat_name_t = row[itmC.item_cat_name_t].ToString(); lexpnC.Add(curr1); } }
public ItemsCat setExpenseCat(DataTable dt) { ItemsCat curr1 = new ItemsCat(); if (dt.Rows.Count > 0) { curr1.item_cat_id = dt.Rows[0][itmC.item_cat_id].ToString(); curr1.item_cat_code = dt.Rows[0][itmC.item_cat_code].ToString(); curr1.item_cat_name_e = dt.Rows[0][itmC.item_cat_name_e].ToString(); curr1.item_cat_name_t = dt.Rows[0][itmC.item_cat_name_t].ToString(); curr1.active = dt.Rows[0][itmC.active].ToString(); curr1.date_cancel = dt.Rows[0][itmC.date_cancel].ToString(); curr1.date_create = dt.Rows[0][itmC.date_create].ToString(); curr1.date_modi = dt.Rows[0][itmC.date_modi].ToString(); curr1.user_cancel = dt.Rows[0][itmC.user_cancel].ToString(); curr1.user_create = dt.Rows[0][itmC.user_create].ToString(); curr1.user_modi = dt.Rows[0][itmC.user_modi].ToString(); //pti1.status_app = dt.Rows[0][tmn.status_app].ToString(); curr1.remark = dt.Rows[0][itmC.remark].ToString(); curr1.sort1 = dt.Rows[0][itmC.sort1].ToString(); } return(curr1); }
public Config() { //read config file try { XmlDocument xDoc = new XmlDocument(); xDoc.Load("Config/config.xml"); if (xDoc != null) { /* * string sim = xDoc.SelectSingleNode("Configuration/General/Simulator").InnerXml.ToString(); * bSimulator = (sim == "true") ? true : false; * string poll = xDoc.SelectSingleNode("Configuration/General/LogPoll").InnerXml.ToString(); * bLogPoll = (poll == "true") ? true : false; * //WGT data * IP = xDoc.SelectSingleNode("Configuration/General/WGT/IP").InnerXml.ToString(); * port = Int32.Parse(xDoc.SelectSingleNode("Configuration/General/WGT/Port").InnerXml.ToString()); * Addr = Convert.ToInt32(xDoc.SelectSingleNode("Configuration/General/WGT/Addr").InnerXml.ToString(), 16); * PPV1 = Double.Parse(xDoc.SelectSingleNode("Configuration/General/PPV1").InnerXml.ToString()); * PPV2 = Double.Parse(xDoc.SelectSingleNode("Configuration/General/PPV2").InnerXml.ToString()); * flowrate = Double.Parse(xDoc.SelectSingleNode("Configuration/General/FlowRate").InnerXml.ToString()); * PumpAuthDelay = Int32.Parse(xDoc.SelectSingleNode("Configuration/General/PumpAuthDelay").InnerXml.ToString()); * HOAuthDelay = Int32.Parse(xDoc.SelectSingleNode("Configuration/General/HOAuthDelay").InnerXml.ToString()); * Product1 = xDoc.SelectSingleNode("Configuration/General/Prod1").InnerXml.ToString(); * Product2 = xDoc.SelectSingleNode("Configuration/General/Prod2").InnerXml.ToString(); * Units = xDoc.SelectSingleNode("Configuration/General/Units").InnerXml.ToString(); * * LimitText = xDoc.SelectSingleNode("Configuration/General/LimitText").InnerXml.ToString(); * PlateText = xDoc.SelectSingleNode("Configuration/General/PlateText").InnerXml.ToString(); * LimitPerVolText = xDoc.SelectSingleNode("Configuration/General/LimitPerVolText").InnerXml.ToString(); * LimitPerMoneyText = xDoc.SelectSingleNode("Configuration/General/LimitPerMoneyText").InnerXml.ToString(); */ // Get items cat //XmlNode node = xDoc.SelectSingleNode("Configuration/Devices").FirstChild.ChildNodes; //xDoc.SelectSingleNode("Configuration/ItemsCat").ChildNodes.Item(0).SelectSingleNode("Items").SelectSingleNode("Item") XmlNodeList node = xDoc.SelectNodes("Configuration/ItemsCat/Cat"); foreach (XmlNode node3 in node) { ItemsCat ic = new ItemsCat(); ic.items = new List <Item>(); ic.Name = node3.SelectSingleNode("Name").InnerText; XmlNodeList cat = node3.SelectNodes("Items/Item"); foreach (XmlNode am in cat) { Item item = new Item(); item.Code = int.Parse(am.SelectSingleNode("Code").InnerText); item.Name = am.SelectSingleNode("Name").InnerText; item.price = double.Parse(am.SelectSingleNode("Price").InnerText); ic.items.Add(item); } itemscat.Add(ic); } } } catch (Exception ex) { MessageBox.Show("Error reading configuration file. " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Application.Exit(); } }