private void button1_Click(object sender, EventArgs e) { try { if (piv.HasLoad) { if (piv.dbHelp.SetPIVAsDB(string.Format("UPDATE [dbo].[PrintFormSet] SET [ChooseMode] ='{0}',[PreviewMode] ='{1}' ,[WardIdle] ='{2}' ,[WardOpen] ='{3}',[DrugList] = '{4}',[PrintNumber]='{5}',[PrintOrderCount]='{6}',[PrintDrugCount]='{7}',[Positions]='{8}',[Species]='{9}',[UP2]='{10}',NextDay='{11}',[NotPrint]='{12}',[NotPrintSelected]='{13}',[Printed]='{14}',[PrintSelected]='{15}',[PrintOverCheck]='{16}',[HasCheck]='{17}',[HasCheckSelected]='{18}',[CheckDrugLimit]='{19}' WHERE [DEmployeeID] = '{20}'", "0", comboBox2.SelectedIndex, checkBox1.Checked, checkBox2.Checked, checkBox3.Checked, comboBox3.SelectedIndex + 1, checkBox6.Checked, comboBox5.SelectedIndex, checkBox4.Checked, checkBox8.Checked, checkBox7.Checked, comboBox7.SelectedItem.ToString() + ":" + comboBox8.SelectedItem.ToString(), button3.BackColor.ToArgb(), button6.BackColor.ToArgb(), button5.BackColor.ToArgb(), button7.BackColor.ToArgb(), (checkBox9.Checked ? "1" : "0"), button8.BackColor.ToArgb(), button9.BackColor.ToArgb(), checkBox10.Checked, piv.userID)) > 0) { UserControlPrint.PreviewMode = comboBox2.SelectedIndex; UserControlPrint.PrintNumber = comboBox3.SelectedIndex + 1; UserControlPrint.WardIdle = checkBox1.Checked; UserControlPrint.WardOpen = checkBox2.Checked; UserControlPrint.DrugList = checkBox3.Checked; UserControlPrint.Positions = checkBox4.Checked; UserControlPrint.PrintDrugCount = comboBox5.SelectedIndex; UserControlPrint.PrintOrderCount = checkBox6.Checked; UserControlPrint.UP2 = checkBox7.Checked; UserControlPrint.Species = checkBox8.Checked; UserControlPrint.PrintOverCheck = checkBox9.Checked; UserControlPrint.CheckDrugLimit = checkBox10.Checked; UserControlPrint.NotPrint = button3.BackColor; UserControlPrint.NotPrintSelected = button6.BackColor; UserControlPrint.Printed = button5.BackColor; UserControlPrint.PrintSelected = button7.BackColor; UserControlPrint.HasCheck = button8.BackColor; UserControlPrint.HasCheckSelected = button9.BackColor; piv.LabelNoPrint = comboBox1.SelectedIndex == 0 ? string.Empty : comboBox1.SelectedItem.ToString(); piv.dbHelp.IniWriteValuePivas("Printer", "LabelPrinter", piv.LabelNoPrint); piv.CountPrint = comboBox4.SelectedIndex == 0 ? string.Empty : comboBox4.SelectedItem.ToString(); piv.dbHelp.IniWriteValuePivas("Printer", "CountPrint", piv.CountPrint); piv.NextDay = comboBox7.SelectedItem.ToString() + ":" + comboBox8.SelectedItem.ToString(); if (int.Parse(piv.dbHelp.GetPIVAsDB(string.Format("select DATEDIFF(MI,'{0}',CONVERT(varchar,GETDATE(),108))", piv.NextDay)).Tables[0].Rows[0][0].ToString()) >= 0) { piv.dateTimePicker1.Value = Convert.ToDateTime(DateTime.Now.Date.AddDays(1).ToString("yyyy-MM-dd")); } else { piv.dateTimePicker1.Value = Convert.ToDateTime(DateTime.Now.Date.ToString("yyyy-MM-dd")); } piv.comboxch(); piv.PivasIVRP_Load(sender, e); } else { MessageBox.Show("设置失败"); } } else { System.Text.StringBuilder sb = new System.Text.StringBuilder(4096); sb.Append("INSERT INTO [PrintFormSet] "); sb.Append("([DEmployeeID],[ChooseMode],[PreviewMode],[WardIdle],[WardOpen],[DrugList],[PrintNumber],[PrintOrderCount],[PrintDrugCount],[Positions],[Species],[UP2],[NextDay],[NotPrint],[NotPrintSelected],[Printed],[PrintSelected],[PrintOverCheck],[HasCheck],[HasCheckSelected],[CheckDrugLimit])"); sb.Append(" VALUES "); sb.AppendFormat("('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}')", piv.userID, "0", comboBox2.SelectedIndex, checkBox1.Checked, checkBox2.Checked, checkBox3.Checked, comboBox3.SelectedIndex + 1, checkBox6.Checked, comboBox5.SelectedIndex, checkBox4.Checked, checkBox8.Checked, checkBox7.Checked, comboBox7.SelectedItem.ToString() + ":" + comboBox8.SelectedItem.ToString(), button3.BackColor.ToArgb(), button6.BackColor.ToArgb(), button5.BackColor.ToArgb(), button7.BackColor.ToArgb(), (checkBox9.Checked ? "1" : "0"), button8.BackColor.ToArgb(), button9.BackColor.ToArgb(), checkBox10.Checked); if (piv.dbHelp.SetPIVAsDB(sb.ToString()) == 0) { MessageBox.Show("添加配置失败"); } else { UserControlPrint.PreviewMode = comboBox2.SelectedIndex; UserControlPrint.PrintNumber = comboBox3.SelectedIndex + 1; UserControlPrint.WardIdle = checkBox1.Checked; UserControlPrint.WardOpen = checkBox2.Checked; UserControlPrint.DrugList = checkBox3.Checked; UserControlPrint.Positions = checkBox4.Checked; UserControlPrint.PrintDrugCount = comboBox5.SelectedIndex; UserControlPrint.PrintOrderCount = checkBox6.Checked; UserControlPrint.UP2 = checkBox7.Checked; UserControlPrint.Species = checkBox8.Checked; UserControlPrint.PrintOverCheck = checkBox9.Checked; UserControlPrint.CheckDrugLimit = checkBox10.Checked; UserControlPrint.NotPrint = button3.BackColor; UserControlPrint.NotPrintSelected = button6.BackColor; UserControlPrint.Printed = button5.BackColor; UserControlPrint.PrintSelected = button7.BackColor; UserControlPrint.HasCheck = button8.BackColor; UserControlPrint.HasCheckSelected = button9.BackColor; piv.NextDay = comboBox7.SelectedItem.ToString().Trim() + ":" + comboBox8.SelectedItem.ToString().Trim(); piv.HasLoad = true; if (int.Parse(piv.dbHelp.GetPIVAsDB(string.Format("select DATEDIFF(MI,'{0}',CONVERT(varchar,GETDATE(),108))", piv.NextDay)).Tables[0].Rows[0][0].ToString()) >= 0) { piv.dateTimePicker1.Value = Convert.ToDateTime(DateTime.Now.Date.AddDays(1).ToString("yyyy-MM-dd")); } else { piv.dateTimePicker1.Value = Convert.ToDateTime(DateTime.Now.Date.ToString("yyyy-MM-dd")); } piv.comboxch(); piv.PivasIVRP_Load(sender, e); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { this.Dispose(true); } }