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