private void Start_Time_KeyPress_1(object sender, KeyPressEventArgs e) { try { if (e.KeyChar == 13) { if (label1.Text == "1") { updatedb update = new updatedb(); update.Start_Time(label1.Text, Start_Time.Text.ToString(), false); } else { PreviousTime = DateTime.Parse(sel.getHeadRule(label1.Text.ToString()).Tables[0].Rows[0][3].ToString()); if (DateTime.Compare(Start_Time.Value, PreviousTime) > 0) { updatedb update = new updatedb(); update.Start_Time(label1.Text, Start_Time.Text.ToString(), false); panel1.BackColor = Color.Transparent; } else { panel1.BackColor = Color.Yellow; } } } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 复制数据到detail表 /// </summary> public void UseAll() { update = new updatedb(); DataSet ds = sel.getWard(); if (ds != null && ds.Tables[0].Rows.Count > 0) { if (Check_OnlyInse.Checked) { //插入增量数据 for (int i = 0; i < ds.Tables[0].Rows.Count - 1; i++) { //DataSet ds=.(Comb_Ward.DataSource); update.insert(ds.Tables[0].Rows[i]["WardCode"].ToString(), 1); } } else { //删除detail所有数据,并复制到detail表里 update.deleteFreqRuleDetail(); for (int i = 0; i < Comb_Ward.Items.Count - 1; i++) { update.insert(ds.Tables[0].Rows[i]["WardCode"].ToString(), 0); } } } }
private void But_Default_Click(object sender, EventArgs e) { update = new updatedb(); But_Default.Text = "正在应用中..."; But_Default.Enabled = false; update.insert(Comb_Ward.SelectedValue.ToString()); //UseAll(); But_Default.Enabled = true; But_Default.Text = "设置为默认"; }
private void label2_Click(object sender, EventArgs e) { update = new updatedb(); if (label2.Tag.ToString() == "1") { label2.Image = Properties.Resources.; label2.Tag = "0"; update.IsValid(label1.Text, false); } else { label2.Image = Properties.Resources.勾; label2.Tag = "1"; update.IsValid(label1.Text, true); } }
private void End_Time_KeyPress(object sender, KeyPressEventArgs e) { updatedb update = new updatedb(); dt = sel.getTimeRule().Tables[0]; int last = dt.Rows.Count - 1; if (e.KeyChar == 13) { if (label1.Text.ToString() == dt.Rows[last][0].ToString() && label1.Text.ToString() != "1") { DateTime First_time = DateTime.Parse(dt.Rows[0][2].ToString()); if (DateTime.Compare(End_Time.Value, First_time) >= 0) { panel2.BackColor = Color.Yellow; } else { panel2.BackColor = Color.Transparent; if (DateTime.Compare(End_Time.Value, Start_Time.Value) > 0) { update.End_Time(label1.Text.ToString(), End_Time.Text.ToString(), false); } else { update.End_Time(label1.Text.ToString(), End_Time.Text.ToString(), true); } } } else { if (DateTime.Compare(End_Time.Value, Start_Time.Value) > 0) { update.End_Time(label1.Text.ToString(), End_Time.Text.ToString(), false); } else { update.End_Time(label1.Text.ToString(), End_Time.Text.ToString(), true); } } } }
public void rowFReqRule(string code, string name) { dt = new DataTable(); panel_Rule.Controls.Clear(); DataSet ds = new DataSet(); if (Comb_Ward.Text.Equals("默认_一般规则")) { ds = sel.getFreqRule(code); } else { ds = sel.getFreqRule(Comb_Ward.SelectedValue.ToString(), code); } if (ds != null && ds.Tables[0].Rows.Count > 0) { row(code); } else { if (sel.getDFreq2(code).Tables[0].Rows[0][1].ToString() != "") { int daytime = Convert.ToInt32(sel.getDFreq2(code).Tables[0].Rows[0][1]); for (int i = 1; i < daytime + 1; i++) { string subcode = code + i; string subname = name + i; update = new updatedb(); update.insert(code, subcode, subname, Comb_Ward.SelectedValue.ToString().ToString()); } row(code); } } }