private void Bt_Remove_Click(object sender, EventArgs e)
{
db.closeConnection();
db.DeleteEmp_Rate(Tb_Name.Text, RateID.ToString());
Tb_Role.ResetText();
Tb_Name.ResetText();
Tb_Starttime.ResetText();
Tb_EndTime.ResetText();
Tb_RPH.ResetText();
Tb_Date.ResetText();
}
public ContactsModify(ResourceManager _rm, Models.Contacts _Con, string[] _ResourceNames, Pages.Contacts _conpage)
{
InitializeComponent();
rm = _rm;
Con = _Con;
ResourceNames = _ResourceNames;
Tb_Name.Clear();
Tb_Name.Text = Con.Con_Name.Trim();
Tb_Phone.Clear();
Tb_Phone.Text = Con.Con_Phone.Trim();
Tb_Email.Clear();
Tb_Email.Text = Con.Con_Email.Trim();
conpage = _conpage;
LoadFormats();
}
private void Tb_Name_TextChanged(object sender, EventArgs e)
{
var regx = new Regex("[^a-zA-Z0-9 ]");
if (regx.IsMatch(Tb_Name.Text))
{
Tb_Name.Text = name;
}
else
{
name = Tb_Name.Text;
TB_HeroName.Text = Tb_Name.Text;
}
Tb_Name.Focus();
Tb_Name.SelectionStart = Tb_Name.Text.Length;
}
private void Bt_Update_Click(object sender, EventArgs e)
{
db.closeConnection();
//
SqlCommand cmd = db.UpdateEmp_rate(Tb_Role.Text, Tb_Name.Text, Tb_Starttime.Text, Tb_EndTime.Text, Convert.ToDouble(Tb_RPH.Text), Tb_Date.Text, RateID.ToString());
cmd.Parameters.AddWithValue("@Role", role);
cmd.Parameters.AddWithValue("@Name", name);
cmd.Parameters.AddWithValue("@StartTime", starttime);
cmd.Parameters.AddWithValue("@EndTime", endtime);
cmd.Parameters.AddWithValue("@RPH", RPH);
cmd.Parameters.AddWithValue("@Date", Date);
cmd.ExecuteNonQuery();
Tb_Role.ResetText();
Tb_Name.ResetText();
Tb_Starttime.ResetText();
Tb_EndTime.ResetText();
Tb_RPH.ResetText();
Tb_Date.ResetText();
}
private void Bt_Update_Click(object sender, EventArgs e)
{
db.closeConnection();
SqlCommand cmd = db.UpdateTrip(Tb_Name.Text, Tb_Streetname.Text, Tb_City.Text, Tb_PostCode.Text, Tb_Province.Text, Tb_Phone.Text, Tb_Name2.Text, Tb_StreetAddress2.Text, Tb_City2.Text, Tb_Postcode2.Text, Tb_Province2.Text, Tb_Phone2.Text, Tb_Description.Text, Tb_Statue.Text, TripID.ToString());
cmd.Parameters.AddWithValue("@S_Name", Tb_Name.Text);
cmd.Parameters.AddWithValue("@S_StreetAddress", Tb_Streetname.Text);
cmd.Parameters.AddWithValue("@S_City", Tb_City.Text);
cmd.Parameters.AddWithValue("@S_Postcode", Tb_PostCode.Text);
cmd.Parameters.AddWithValue("@S_Province", Tb_Province.Text);
cmd.Parameters.AddWithValue("@S_Phone", Tb_Phone.Text);
cmd.Parameters.AddWithValue("@R_Name", Tb_Name2.Text);
cmd.Parameters.AddWithValue("@R_StreetAddress", Tb_StreetAddress2.Text);
cmd.Parameters.AddWithValue("@R_City", Tb_City2.Text);
cmd.Parameters.AddWithValue("@R_Postcode", Tb_Postcode2.Text);
cmd.Parameters.AddWithValue("@R_Province", Tb_Province2.Text);
cmd.Parameters.AddWithValue("@R_Phone", Tb_Phone2.Text);
cmd.Parameters.AddWithValue("@R_Description", Tb_Description.Text);
cmd.Parameters.AddWithValue("@Status", Tb_Statue.Text);
cmd.ExecuteNonQuery();
Tb_Name.ResetText();
Tb_Streetname.ResetText();
Tb_City.ResetText();
Tb_PostCode.ResetText();
Tb_Province.ResetText();
Tb_Phone.ResetText();
Tb_Name2.ResetText();
Tb_StreetAddress2.ResetText();
Tb_City2.ResetText();
Tb_Postcode2.ResetText();
Tb_Province2.ResetText();
Tb_Phone2.ResetText();
Tb_Description.ResetText();
Tb_Statue.ResetText();
}
private void Btn_Add_Click(object sender, RoutedEventArgs e)
{
string str = Tb_Name.Text.Trim(' ');
if (string.IsNullOrWhiteSpace(str))
{
System.Windows.MessageBox.Show("请输入文本！");
return;
}
//Lb_Names.ItemsSource = null;
listNames.Add(str);
Lb_Names.Items.Refresh();
set.AddItem(str);
Tb_Name.Text = "";
Tb_Name.Focus();
FileStream fs = new FileStream(set.GetCurrentFileName(), FileMode.Append);
StreamWriter sw = new StreamWriter(fs, Encoding.GetEncoding("gb2312"));
sw.Write(str + "\r\n");
sw.Close();
fs.Close();
}
