private void frmCreatedatabase_Load(object sender, EventArgs e)
{
//dataConfig.loadConfig();
string path = dataConfig.code_printer_template_path;
string tmp_name = "";
if (path != "")
{
tmp_name = Path.GetFileNameWithoutExtension(path);
path = Path.GetDirectoryName(path);
}
string db_file_name = path + "\\" + tmp_name + ".db3";
dataConfig.to_print_data_path = db_file_name;
dataConfig.savePrintDataPath();
conn.ConnectionString = "Data Source = " + db_file_name;
textBoxDatabase.Text = tmp_name + ".db3";
if (File.Exists(db_file_name) && _isSet)
{
sn_property sn = new sn_property(db_file_name);
textBoxStartSN.Text = sn.sn_start;
textBox1.Text = sn.sn_min;
textBox2.Text = sn.sn_max;
checkBox2.Checked = sn.scan_check;
checkBox1.Checked = sn.sn_check_repeat;
richTextBox1.Text = sn.sn_print_magic_code;
}
if (!_isSet || !File.Exists(db_file_name))
{
//加入自动载入打印脚本数据
string prn_file = dataConfig.code_printer_template_path;
FileStream fs = new FileStream(prn_file, FileMode.Open);
StreamReader rd = new StreamReader(fs);
string content = rd.ReadToEnd();
richTextBox1.Text = content;
fs.Close();
}
}
//
/// <summary>
/// 创建数据库文件,这里需要做一个变动，需要让客户实时看到创建的数据库是否成功(即让主界面显示出来)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
//dataConfig.loadConfig();
frmLogin login = new frmLogin();
if (login.ShowDialog() == DialogResult.OK)
{
string path = dataConfig.code_printer_template_path;
string tmp_name = "";
if (path != "")
{
tmp_name = Path.GetFileNameWithoutExtension(path);
path = Path.GetDirectoryName(path);
}
string db_file_name = path + "\\" + tmp_name + ".db3";
//!4.5
/*
* if (File.Exists(db_file_name))
* return;
* */
string txtStartSN = textBoxStartSN.Text.Trim();
string txtMin = textBox1.Text.Trim();
string txtMax = textBox2.Text.Trim();
if (txtStartSN == "" || txtMin == "" || txtMax == "")
{
if (dataConfig.lang == "zh")
{
MessageBox.Show("请输入一个有效的数字!");
}
else
{
MessageBox.Show("please input validate number!");
}
return;
}
Regex r = new Regex(@"^[0-9]*$");
bool m0 = r.IsMatch(txtStartSN);
bool m1 = r.IsMatch(txtMin);
bool m2 = r.IsMatch(txtMax);
if (!m0 || !m1 || !m2)
{
MessageBox.Show("请输入1位以上数字!");
return;
}
int start = Convert.ToInt32(txtStartSN);
int min = Convert.ToInt32(txtMin);
int max = Convert.ToInt32(txtMax);
if (start < min)
{
if (dataConfig.lang == "zh")
{
MessageBox.Show("起始值必须大于等于最小值!");
}
else
{
MessageBox.Show("start value must large min value!");
}
return;
}
if (min > max)
{
if (dataConfig.lang == "zh")
{
MessageBox.Show("最小值必须小于等于最大值!");
}
else
{
MessageBox.Show("min value must small than max value!");
}
return;
}
if (start > max)
{
if (dataConfig.lang == "zh")
{
MessageBox.Show("起始值必须小于等于最大值!");
}
else
{
MessageBox.Show("start value must less than max value!");
}
return;
}
conn.Open();
//创建数据库
SQLiteCommand cmd = new SQLiteCommand(conn);
cmd.CommandText = create_database;
cmd.ExecuteNonQuery();
//MessageBox.Show("创建成功!");
cmd.CommandText = "SELECT count(*) as n FROM [sn_property]";
SQLiteDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
int n = Convert.ToInt32(rd["n"]);
rd.Close();
if (n <= 0)
{
string insert = "INSERT INTO [sn_property] ([start_sn], [sn_max],[sn_min], [sn_print_magic_code], [sn_check_repeat], [scan_check]) values (\'1\', \'9999\', \'0\', \'\', \'1\',\'1\');";
cmd.CommandText = insert;
cmd.ExecuteNonQuery();
}
}
conn.Close();
this.DialogResult = DialogResult.OK;
/*
* string sql = "insert into [sn_property] (start_sn) values (\'" + txtStartSN + "\'" + ");";
* cmd.CommandText = sql;
* cmd.ExecuteNonQuery();
* */
sn_property sn_pro = new sn_property(db_file_name);
sn_pro.sn_print_magic_code = richTextBox1.Text;
sn_pro.sn_check_repeat = checkBox1.Checked;
sn_pro.sn_max = txtMax;
sn_pro.sn_min = txtMin;
sn_pro.sn_start = txtStartSN;
sn_pro.scan_check = checkBox2.Checked;
sn_pro.update();
this.Close();
if (dataConfig.lang == "zh")
{
MessageBox.Show("保存成功!");
}
else
{
MessageBox.Show("save successful!");
}
}
}
