private void button1_Click(object sender, EventArgs e)
{
if (ShowItem == 0)
{
piv.BatS = string.Empty;
foreach (string clb in checkedListBox1.CheckedItems)
{
piv.BatS = piv.BatS + "'" + clb + "',";
}
piv.BatS = piv.BatS.TrimEnd(',');
if (!string.IsNullOrEmpty(piv.BatS))
{
piv.label2.Text = piv.BatS.Replace("'", string.Empty);
string OrderBY = string.Empty;
using (DataSet ds = piv.dbHelp.GetPIVAsDB(string.Format("SELECT max([OrderBY]) FROM [dbo].[BatchToOrder] where [Batch] = '{0}'", piv.label2.Text.Contains(",") ? piv.label2.Text.Split(',')[0] : piv.label2.Text)))
{
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
OrderBY = ds.Tables[0].Rows[0][0].ToString();
}
}
piv.comboBox6.SelectedIndex = string.IsNullOrEmpty(OrderBY) ? 0 : piv.comboBox6.Items.IndexOf(OrderBY);
}
piv.comboBox2.Visible = string.IsNullOrEmpty(piv.BatS);
piv.label2.Visible = !piv.comboBox2.Visible;
piv.PivasIVRP_Load(sender, e);
this.Dispose(true);
}
else if (ShowItem == 1)
{
piv.UsageCodeS = string.Empty;
if (checkedListBox1.CheckedItems.Count != checkedListBox1.Items.Count)
{
foreach (string clb in checkedListBox1.CheckedItems)
{
piv.UsageCodeS = piv.UsageCodeS + "'" + clb + "',";
}
piv.UsageCodeS = piv.UsageCodeS.TrimEnd(',');
}
piv.PivasIVRP_Load(sender, e);
this.Dispose(true);
}
}
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);
}
}
