//取得建入資料
protected DataTable GetDataBox1()
{
string ErrorString = "";
string SQLString = "Name,EIN,Type,SupportItem,Owner,OwnerMobile,Capital,StaffAmount,Location,Tel1,Tel2,Fax1,Fax2,Email,ContectAddress,RegisteredAddress,Notes";
DataTable DataTableBox = new DataTable();
foreach (string DataName in SQLString.Split(','))
{
DataTableBox.Columns.Add(DataName, typeof(string));
}
//後台功能，必需要有的欄位名稱
DataRow DataTableDr = DataTableBox.NewRow();
string FirmName = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_FirmName.Text));
string SupportItem = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_SupportItem.Text));
string EIN = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_EIN.Text));
string Owner = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Owner.Text));
string OwnerMobile = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_OwnerMobile.Text));
bool Capital = SystemSet.Float(TBE_Capital.Text);
bool Staff = SystemSet.IsNumber(TBE_Staff.Text);
string Tel1 = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Tel1.Text));
string Tel2 = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Tel2.Text));
string Fax1 = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Fax1.Text));
string Fax2 = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Fax2.Text));
string Email = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Email.Text));
string Caddress = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_CAddress.Text));
string Notes = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Notes.Text));
string RAddress = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_RAddress.Text));
ErrorString += (DDL_Select7.SelectedValue) == "0" ? "請輸入廠商類型!!\\n" : "";
ErrorString += (DDL_Select8.SelectedValue) == "0" ? "請輸入所在縣市!!\\n" : "";
ErrorString += (Capital) != true ? "請輸入數字!!\\n" : "";
ErrorString += (Staff) != true ? "請輸入數字!!\\n" : "";
#region 內容設定
if (ErrorString == "")
{
DataTableDr["Name"] = FirmName;
DataTableDr["SupportItem"] = SupportItem;
DataTableDr["EIN"] = EIN;
DataTableDr["Type"] = DDL_Select5.SelectedValue;
DataTableDr["Owner"] = Owner;
DataTableDr["OwnerMobile"] = OwnerMobile;
DataTableDr["Capital"] = TBE_Capital.Text != "" ? decimal.Parse(TBE_Capital.Text) : 0;
DataTableDr["StaffAmount"] = TBE_Staff.Text != "" ? decimal.Parse(TBE_Staff.Text) : 0;
DataTableDr["Location"] = DDL_Select6.SelectedValue;
DataTableDr["Tel1"] = Tel1;
DataTableDr["Tel2"] = Tel2;
DataTableDr["Fax1"] = Fax1;
DataTableDr["Fax2"] = Fax2;
DataTableDr["Email"] = Email;
DataTableDr["ContectAddress"] = Caddress;
DataTableDr["RegisteredAddress"] = RAddress;
DataTableDr["Notes"] = Notes;
DataTableDr["Type"] = DDL_Select7.SelectedValue;
DataTableDr["Location"] = DDL_Select8.SelectedValue;
DataTableBox.Rows.Add(DataTableDr);
#endregion
}
else
{
ScriptManager.RegisterStartupScript((System.Web.UI.Page)HttpContext.Current.Handler, this.GetType(), "ShowMessage", "alert('" + ErrorString + "');", true);
}
return(DataTableBox);
}