private void t_btn_Close_Copy_Click(object sender, RoutedEventArgs e)
{
try
{
CreateDatabase("server=.\\SQLEXPRESS; uid=sa; pwd=sa123456", "ProjectTracking");
ExecuteSqlFile("server=.\\SQLEXPRESS; uid=sa; pwd=sa123456", @"C:\Users\40326\Documents\Visual Studio 2017\XProject001\ProjectTracking.git\XProject001\XProjectWPF\DataBase\数据库脚本.sql");
XMessageBox.Enter("创建成功！", this);
}
catch (Exception ex)
{
XMessageBox.Exception(ex);
}
}
/// <summary>
/// 保存按钮事件
/// </summary>
/// <param name="sender">事件对象</param>
/// <param name="e">事件参数</param>
private void t_tsb_Save_Click(object sender, RoutedEventArgs e)
{
try
{
bool isSuccess = SaveMethod();
if (isSuccess)
{
XMessageBox.Enter("保存成功", this);
m_IsModify = false;
}
}
catch (Exception ex)
{
XMessageBox.Exception(ex);
}
}
/// <summary>
/// 生成项目单
/// </summary>
/// <param name="sender">事件对象</param>
/// <param name="e">事件参数</param>
private void t_tsb_CreateProject_Click(object sender, RoutedEventArgs e)
{
try
{
if (m_IsModify || t_txt_QuotationNo.Text == "新单")
{
XMessageBox.Enter("当前单据尚未保存，请保存后再操作！", this);
return;
}
m_IsModify = false;
this.Visibility = Visibility.Hidden;
PT_B_Project myModel = new PT_B_Project();
myModel.Project_Id = Guid.NewGuid().ToString("N");
myModel.Quotation_No = PTBQuotation.Quotation_No;
myModel.Quotation_Date = PTBQuotation.Quotation_Date;
myModel.Follow_Man = PTBQuotation.Follow_Man;
myModel.Product_Model = PTBQuotation.Product_Model;
myModel.Project_Name = PTBQuotation.Project_Name;
myModel.Price = PTBQuotation.Price;
myModel.Is_Tax = PTBQuotation.Is_Tax;
myModel.Project_Type = PTBQuotation.Quotation_Type;
myModel.Cycle_Time = PTBQuotation.Cycle_Time;
myModel.Company_Name = PTBQuotation.Company_Name;
myModel.Company_Address = PTBQuotation.Company_Address;
myModel.Contact_Man = PTBQuotation.Contact_Man;
myModel.Tel = PTBQuotation.Tel;
myModel.Email = PTBQuotation.Email;
myModel.Fax = PTBQuotation.Fax;
myModel.Remark = PTBQuotation.Remark;
myModel.Oper_Time = DateTime.Now;
myModel.Account_Receivable = PTBQuotation.Price;
myModel.Profits = PTBQuotation.Price;
FrmProject myForm = new FrmProject();
myForm.PTBProject = myModel;
myForm.ShowDialog();
this.Close();
}
catch (Exception ex)
{
XMessageBox.Exception(ex);
}
}