private void FrmFilePath_Load(object sender, EventArgs e) { string sql = "select * from Savepath"; DataTable dt = new DataTable(); dt = OleHeper.Query(sql).Tables[0]; jcpath.Text = dt.Rows[1][1].ToString(); expath.Text = dt.Rows[0][1].ToString(); bkpath.Text = dt.Rows[2][1].ToString(); this.jcpath.Select(this.jcpath.TextLength, 0); }
private void main_Load(object sender, EventArgs e) { Startjxbtn.BackColor = Color.Silver; string sql = "select * from Savepath where id=1"; _SavePath = OleHeper.Query(sql).Tables[0].Rows[0][1].ToString(); if (_SavePath.EndsWith(@"\") == false) { _SavePath = _SavePath + "\\"; } }
public static DataSet getBoard(string codeName) { string sql = "select * from boardinfo "; if (codeName.Trim().Length > 0) { sql = sql + " where code like '*" + codeName + "*' + or code like '*" + codeName + "*'"; } return(OleHeper.Query(sql)); }
public static int GetMaxID(string FieldName, string TableName) { string strsql = "select max(" + FieldName + ")+1 from " + TableName; object obj = OleHeper.GetSingle(strsql); if (obj == null) { return(1); } else { return(int.Parse(obj.ToString())); } }
public static int GetRecordCount(string _ID, string _tbName, string _strCondition, int _Dist) { string sql = getPageListCounts(_ID, _tbName, _strCondition, _Dist); object obj = OleHeper.GetSingle(sql); if (obj == null) { return(1); } else { return(int.Parse(obj.ToString())); } }
private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { FolderBrowserDialog dialog = new FolderBrowserDialog(); if (dialog.ShowDialog(this) == System.Windows.Forms.DialogResult.OK) { string _path = dialog.SelectedPath; string sql = "update Savepath set savefilepath='" + _path + "' where id=3"; if (OleHeper.ExecuteSql(sql) > 0) { MessageBox.Show("保存成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); _SavePath = _path; } } }
public static bool UpdateBoard(string code, string cname, string Fx, string hole, int id) { string sql = "update boardinfo set code={0},cname={1},boardFX={2},hole={3}"; sql = sql + " where id={4}"; int i = OleHeper.ExecuteSql(string.Format(sql, "'" + code + "'", "'" + cname + "'", "'" + Fx + "'", "'" + hole + "'", id)); if (i > 0) { return(true); } else { return(false); } }
public static bool DeleteBoard(int id) { string sql = "delete boardinfo "; sql = sql + " where id=@id"; List <OleDbParameter> parameters = new List <OleDbParameter>(); parameters.Add(new OleDbParameter("@id", id)); int i = OleHeper.ExecuteSql(sql, parameters.ToArray()); if (i > 0) { return(true); } else { return(false); } }
private void Startjxbtn_Click(object sender, EventArgs e) { string Orignpath1 = "select * from SavePath where id=2"; string Savepath1 = "select * from SavePath where id=1"; string bakpath1 = "select * from SavePath where id=3"; Orignpath = OleHeper.Query(Orignpath1).Tables[0].Rows[0][1].ToString(); Savepath = OleHeper.Query(Savepath1).Tables[0].Rows[0][1].ToString(); bakpath = OleHeper.Query(bakpath1).Tables[0].Rows[0][1].ToString(); if (Orignpath.EndsWith(@"\") == false) { Orignpath = Orignpath + "\\"; } if (Savepath.EndsWith(@"\") == false) { Savepath = Savepath + "\\"; } if (bakpath.EndsWith("\\") == false) { bakpath = bakpath + "\\"; } this.label3.Text = "监测路径:" + Orignpath; this.label4.Text = "输出路径:" + Savepath; Thread thread = new Thread(jx); thread.IsBackground = true; if (Startjxbtn.Text == "正在自动转化...") { Startjxbtn.Text = "开始监测"; Startjxbtn.BackColor = Color.Silver; jccheak = false; thread.Start(); } else { Startjxbtn.Text = "正在自动转化..."; Startjxbtn.BackColor = Color.Red; jccheak = true; thread.Start(); } }
//保存 private void button4_Click(object sender, EventArgs e) { if (System.IO.Directory.Exists(jcpath.Text) == false) { MessageBox.Show("监测路径不存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (System.IO.Directory.Exists(expath.Text) == false) { MessageBox.Show("XML导出路径不存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (System.IO.Directory.Exists(bkpath.Text) == false) { MessageBox.Show("Json备份路径不存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } string sqljc = "update Savepath set savefilepath='" + jcpath.Text + "' where id=2"; string sqlsa = "update Savepath set savefilepath='" + expath.Text + "' where id=1"; string sqlbk = "update Savepath set savefilepath='" + bkpath.Text + "' where id=3"; try { OleHeper.ExecuteSql(sqljc); OleHeper.ExecuteSql(sqlsa); OleHeper.ExecuteSql(sqlbk); main._SavePath = expath.Text; MessageBox.Show("保存成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); if (checkBox1.Checked == true) { this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public static bool Exists(string strSql, params OleDbParameter[] cmdParms) { object obj = OleHeper.GetSingle(strSql, cmdParms); int cmdresult; if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { cmdresult = 0; } else { cmdresult = int.Parse(obj.ToString()); } if (cmdresult == 0) { return(false); } else { return(true); } }
public static bool InsertBoard(string code, string cname, string Fx, string hole) { string sql = "insert into boardinfo(code,cname,boardFX,hole)"; sql = sql + "values (@code,@cname,@boardFX,@hole)"; List <OleDbParameter> parameters = new List <OleDbParameter>(); parameters.Add(new OleDbParameter("@code", OleDbType.VarChar, 50, code)); parameters.Add(new OleDbParameter("@cname", OleDbType.VarChar, 50, cname)); parameters.Add(new OleDbParameter("@boardFX", OleDbType.VarChar, 50, Fx)); parameters.Add(new OleDbParameter("@hole", OleDbType.VarChar, 50, hole)); int i = OleHeper.ExecuteSql(sql, parameters.ToArray()); if (i > 0) { return(true); } else { return(false); } }
//变量 private string GetParmeteSts(KJLobject kJ) { string str = ""; string sql = "select * from Paramss p inner join boardinfo o"; sql = sql + " on o.id=p.boardid where o.Code= '" + kJ.modelNumber + "'"; List <KJLobject> Klist = new List <KJLobject>(); DataTable dt = new DataTable(); dt = OleHeper.Query(sql).Tables[0]; string sqlsys = "select * from SysPram"; DataTable dtsys = new DataTable(); dtsys = OleHeper.Query(sqlsys).Tables[0]; string orderTy; orderTy = kJ.OrderType == 1 ? "衣柜" : "橱柜"; foreach (parameter parm in kJ.parameters) { foreach (DataRow drs in dtsys.Rows) { if (parm.parmName == drs["Kname"].ToString() && drs["OrderType"].ToString() == orderTy) { str = str + drs["Iname"] + ":=" + parm.parmValue + "|"; } } foreach (DataRow dr in dt.Rows) { string Kname = dr["Kname"].ToString(); if (parm.parmName == Kname) { str = str + dr["Iname"] + ":=" + parm.parmValue + "|"; } } } return(str); }
private void savebtn_Click(object sender, EventArgs e) { if (Knametxt.Text.Trim().Length != 0 && Inametxt.Text.Trim().Length != 0) { try { int count = 0; for (int i = 0; i < Listid.Count; i++) { string sql = "insert into Paramss(BoardId,Iname,Kname,Remark) values ("; sql = sql + Listid[i] + ",'" + Inametxt.Text.Trim() + "',"; sql = sql + "'" + Knametxt.Text.Trim() + "',"; sql = sql + "'" + remarktxt.Text.Trim() + "'" + ")"; count = count + OleHeper.ExecuteSql(sql); } if (count == Listid.Count) { MessageBox.Show("新增成功!", "提示!!!", MessageBoxButtons.OK, MessageBoxIcon.Information); if (checkBox1.Checked == true) { this.Close(); } } } catch (Exception ex) { throw ex; } } else { MessageBox.Show("变量名未填写完整", "提示!!!", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
//判断孔 //double fx = 0.2; private List <KJLobject> getHoleInfo(List <KJLobject> Kobj) { List <KJLobject> Hboardlist = new List <KJLobject>(); //水平板 List <KJLobject> Vboardlist = new List <KJLobject>(); //垂直板 List <KJLobject> Otherboardlist = new List <KJLobject>(); //其他 string sql = "select * from boardinfo"; DataTable dt = new DataTable(); dt = OleHeper.Query(sql).Tables[0]; foreach (KJLobject kj in Kobj) { bool flag = false; foreach (DataRow dr in dt.Rows) { if (kj.modelNumber == dr["Code"].ToString()) { flag = true; if (dr["BoardFX"].ToString() == "横向" && bool.Parse(dr["hole"].ToString()) == true) { Hboardlist.Add(kj); } else if (dr["BoardFX"].ToString() == "竖向" && bool.Parse(dr["hole"].ToString()) == true) { Vboardlist.Add(kj); } else { Otherboardlist.Add(kj); } } } if (flag == false) { Otherboardlist.Add(kj); } } List <KJLobject> Allkjl = new List <KJLobject>(); //先判断横向板件 addMsg(DateTime.Now.ToString() + ":开始判断横向板件孔位..."); for (int i = 0; i < Hboardlist.Count; i++) { string str = getSHoleInfo(Hboardlist[i], Vboardlist); Hboardlist[i].newCode = Hboardlist[i].newCode + str; Allkjl.Add(Hboardlist[i]); } addMsg(DateTime.Now.ToString() + ":判断横向板件孔位完成!"); //再判断竖向板件 addMsg(DateTime.Now.ToString() + ":开始判断竖向板件孔位..."); for (int i = 0; i < Vboardlist.Count; i++) { string str = ""; str = getCHoleInfo(Vboardlist[i], Hboardlist); if (Vboardlist[i].modelNumber.Contains("KSPL")) { Vboardlist[i].holeStart = ""; } else if (Vboardlist[i].modelNumber.Contains("KSPR")) { Vboardlist[i].holeStart = ""; } //如果竖板有孔,往后调整竖板优先级 if (str != "") { Vboardlist[i].LevelSeq += 2; } Vboardlist[i].newCode = Vboardlist[i].newCode + str; Allkjl.Add(Vboardlist[i]); } addMsg(DateTime.Now.ToString() + ":判断竖向板件孔位完成!"); Allkjl.AddRange(Otherboardlist); return(Allkjl); }
//配置对象 private List <KJLobject> getUserkbj(List <KJLobject> kJ) { addMsg(DateTime.Now.ToString() + ":开始获取数据库配置信息"); string sql = "select * from boardinfo"; List <KJLobject> Klist = new List <KJLobject>(); DataTable dt = new DataTable(); dt = OleHeper.Query(sql).Tables[0]; foreach (KJLobject k in kJ) { bool flag = false; //门板 if (IsDoor(k) == true) { List <KJLobject> lsObj = new List <KJLobject>(); List <KJLobject> LSXH = new List <KJLobject>(); lsObj = kJ.Where(l => l.parentid == k.parentid).ToList(); lsObj = lsObj.Where(l => l.modelTypeId == 2).ToList(); LSXH.AddRange(lsObj); lsObj = kJ.Where(l => l.id == k.parentid).ToList(); lsObj = lsObj.Where(l => l.modelTypeId == 2).ToList(); LSXH.AddRange(lsObj); lsObj = kJ.Where(l => l.parentid == k.id).ToList(); lsObj = lsObj.Where(l => l.modelTypeId == 2).ToList(); LSXH.AddRange(lsObj); for (int i = 0; i < LSXH.Count; i++) { parameter parameter = new parameter(); parameter.parmName = "LSXH"; parameter.parmValue = LSXH[i].modelNumber; k.parameters.Add(parameter); } } foreach (DataRow dr in dt.Rows) { try { if (k.modelNumber == dr["Code"].ToString()) { k.LevelSeq = int.Parse(dr["LevelSeq"].ToString()); k.newCode = k.modelNumber; string holeFx = dr["HoleFx"].ToString(); k.holeFx = holeFx == "" ? 0 : k.holeFx = double.Parse(holeFx); Klist.Add(k); flag = true; } } catch (Exception e) { ErrMsg(DateTime.Now.ToString() + ":获取配置信息失败!" + "错误信息为:" + e.ToString()); } } if (flag == false) { k.newCode = k.modelNumber; k.LevelSeq = 100; Klist.Add(k); if (k.modelTypeId != 2) { ErrMsg(k.modelNumber + ":在数据库找不到配置信息!"); } } } addMsg(DateTime.Now.ToString() + ":获取数据库配置信息完成!"); return(Klist); }