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