private void SetUpsimpleButton_Click(object sender, EventArgs e)
{
try
{
if (BargainYEScheckEdit.Checked == true)
{
bargain = 1;
}
if (BargainNONEcheckEdit.Checked == true)
{
bargain = 0;
}
if (InsuranceNOcheckEdit.Checked == true)
{
insurance = 0;
}
if (InsuranceYEScheckEdit.Checked == true)
{
insurance = 1;
}
if (ContractMoneycheckEdit.Checked == true)
{
contractmoney = 1;
}
else
{
contractmoney = 0;
}
if (ContractCostcheckEdit.Checked == true)
{
contractcost = 1;
}
else
{
contractcost = 0;
}
string content = $"'{DatedateEdit.DateTime.ToString("yyyy/MM/dd HH:mm:ss")}', '{ProjectNOtextEdit.Text}', '{OwnerNametextEdit.Text}', '{OwnerAddresstextEdit.Text}', '{OwnerNOtextEdit.Text}', " +
$"'{WorkStartdateEdit.DateTime.ToString("yyyy/MM/dd HH:mm:ss")}', '{WorkEnddateEdit.DateTime.ToString("yyyy/MM/dd HH:mm:ss")}', '{ContacttextEdit.Text}', '{ContactPhonetextEdit.Text}', '{ProjectLeadertextEdit.Text}', " +
$"'{ProjectWorkLeadertextEdit.Text}', '{BargainPersontextEdit.Text}', {bargain}, '{BargainRensontextEdit.Text}', '{BargaindateEdit.DateTime.ToString("yyyy/MM/dd HH:mm:ss")}', " +
$"'{BargainLocaltextEdit.Text}', '{BargainPricecomboBoxEdit.Text}', {Convert.ToInt32(BargainMoneytextEdit.Text)}, '{QuotationCodetextEdit.Text}', {Convert.ToInt32(QuotationPricetextEdit.Text)}, " +
$"{insurance}, '{InsuranceStartdateEdit.DateTime.ToString("yyyy/MM/dd HH:mm:ss")}', '{InsuranceEnddateEdit.DateTime.ToString("yyyy/MM/dd HH:mm:ss")}', {Convert.ToInt32(ContractMoneytextEdit.Text)}, {contractmoney}, " +
$"'{PlanCosttextEdit.Text}',{contractcost}, '{PlanGoaltextEdit.Text}', '{PONumbertextEdit.Text}'";
SQLMethod.Insert_dispatchdatatable(content);
MessageBox.Show("專案建立成功!");
}
catch (Exception ex)
{
Log.Error(ex, "專案建立失敗!");
MessageBox.Show("專案建立失敗!");
}
}