public static bool Get(string_v Logo_Hash_v, byte_array_v Logo_v, string_v Logo_Description_v, ref long_v Atom_Logo_ID_v) { string Err = null; if (Logo_Hash_v == null) { Atom_Logo_ID_v = null; return true; } if (Atom_Logo_ID_v == null) { Atom_Logo_ID_v = new long_v(); } List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string Image_Hash_Value = "null"; string Image_Hash_cond = "Image_Hash is null"; if (Logo_Hash_v != null) { if (Logo_Hash_v.v != null) { Image_Hash_Value = "@par_Image_Hash"; Image_Hash_cond = "Image_Hash = " + Image_Hash_Value; SQL_Parameter par_Image_Hash = new SQL_Parameter(Image_Hash_Value, SQL_Parameter.eSQL_Parameter.Nvarchar, false, Logo_Hash_v.v); lpar.Add(par_Image_Hash); } } string Image_Data_Value = "null"; if (Logo_v != null) { if (Logo_v.v != null) { Image_Data_Value = "@par_Image_Data"; SQL_Parameter par_Image_Data = new SQL_Parameter(Image_Data_Value, SQL_Parameter.eSQL_Parameter.Varbinary, false, Logo_v.v); lpar.Add(par_Image_Data); } } string Description_Value = "null"; string Description_cond = "Description is null"; if (Logo_Description_v != null) { if (Logo_Description_v.v != null) { Description_Value = "@par_Description"; Description_cond = "Description = " + Description_Value; SQL_Parameter par_Description = new SQL_Parameter(Description_Value, SQL_Parameter.eSQL_Parameter.Nvarchar, false, Logo_Description_v.v); lpar.Add(par_Description); } } string sql = " select ID, Image_Hash,Image_Data,Description from Atom_Logo where " + Image_Hash_cond + " and " + Description_cond; DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err)) { if (dt.Rows.Count > 0) { Atom_Logo_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { sql = " insert into Atom_Logo (Image_Hash,Image_Data,Description) values (" + Image_Hash_Value + "," + Image_Data_Value + "," + Description_Value + ")"; object oRet = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref Atom_Logo_ID_v.v_, ref oRet, ref Err, "Atom_Logo")) { return true; } else { LogFile.Error.Show("ERROR:f_Atom_Logo:sql=" + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:f_Atom_Logo:sql=" + sql + "\r\nErr=" + Err); return false; } }
private bool Get_Atom_Item_Image(long Atom_Item_ID, string_v Atom_Item_Image_Hash, byte_array_v Atom_Item_Image_Data, ref long Atom_Item_Image_ID) { string Err = null; if (Atom_Item_Image_Hash != null) { List<DBConnectionControl40.SQL_Parameter> lpar = new List<DBConnectionControl40.SQL_Parameter>(); string spar_Item_Image_Hash = "@par_Item_Image_Image_Hash"; DBConnectionControl40.SQL_Parameter par_Item_Image_Hash = new DBConnectionControl40.SQL_Parameter(spar_Item_Image_Hash, DBConnectionControl40.SQL_Parameter.eSQL_Parameter.Varchar, false, Atom_Item_Image_Hash.v); lpar.Add(par_Item_Image_Hash); string sql_select_Atom_Item_Item_Image_Hash_ID = @"select Atom_Item_Image.ID as Atom_Item_Image_ID from Atom_Item_Image inner join Atom_Item_ImageLib on Atom_Item_ImageLib.ID = Atom_Item_Image.Atom_Item_ImageLib_ID where (Atom_Item_ImageLib.Image_Hash = " + spar_Item_Image_Hash + ") and (Atom_Item_Image.Atom_Item_ID = " + Atom_Item_ID.ToString() + ")"; DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql_select_Atom_Item_Item_Image_Hash_ID, lpar, ref Err)) { if (dt.Rows.Count > 0) { Atom_Item_Image_ID = (long)dt.Rows[0]["Atom_Item_Image_ID"]; return true; } else { long Atom_Item_ImageLib_ID = -1; string sql_select_Atom_Item_ImageLib_ID = @"select ID as Atom_Item_ImageLib_ID from Atom_Item_ImageLib where Atom_Item_ImageLib.Image_Hash = " + spar_Item_Image_Hash; DataTable dt2 = new DataTable(); object objret = null; if (DBSync.DBSync.ReadDataTable(ref dt2, sql_select_Atom_Item_ImageLib_ID, lpar, ref Err)) { if (dt2.Rows.Count > 0) { Atom_Item_ImageLib_ID = (long)dt2.Rows[0]["Atom_Item_ImageLib_ID"]; } else { string spar_Item_Image_Data = "@par_Item_Image_Image_Data"; DBConnectionControl40.SQL_Parameter par_Item_Image_Data = new DBConnectionControl40.SQL_Parameter(spar_Item_Image_Data, DBConnectionControl40.SQL_Parameter.eSQL_Parameter.Varbinary, false, Atom_Item_Image_Data.v); lpar.Add(par_Item_Image_Data); string sql_Insert_Atom_Item_Item_Image_Hash = @"insert into Atom_Item_ImageLib (Image_Hash,Image_Data)values(" + spar_Item_Image_Hash + "," + spar_Item_Image_Data + ")"; if (!DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_Insert_Atom_Item_Item_Image_Hash, lpar, ref Atom_Item_ImageLib_ID, ref objret, ref Err, DBtcn.stbl_Atom_Item_ImageLib_TableName)) { LogFile.Error.Show("ERROR:Get_Atom_Item_Image:insert into Atom_Item_ImageLib failed!\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:Get_Atom_Item_Image:select ID as Atom_Item_ImageLib_ID from Atom_Item_ImageLib failed!\r\nErr=" + Err); return false; } string sql_Insert_Atom_Item_Image = @"insert into Atom_Item_Image (Atom_Item_ID,Atom_Item_ImageLib_ID)values(" + Atom_Item_ID.ToString() + "," + Atom_Item_ImageLib_ID.ToString() + ")"; if (!DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_Insert_Atom_Item_Image, null, ref Atom_Item_Image_ID, ref objret, ref Err, DBtcn.stbl_Atom_Item_Image_TableName)) { LogFile.Error.Show("ERROR:Get_Atom_Item_Image:insert into Atom_Item_ImageLib failed!\r\nErr=" + Err); return false; } return true; } } else { LogFile.Error.Show("ERROR:Get_Atom_Item_Image:select ID as Atom_Item_Image_ID from Atom_Item_Image failed!\r\nErr=" + Err); return false; } } else { return true; } }
public static bool Get(long Organisation_ID, string_v OrganisationTYPE_v, PostAddress_v Address_v, string_v PhoneNumber_v, string_v FaxNumber_v, string_v Email_v, string_v HomePage_v, string_v Logo_Hash_v, byte_array_v Image_Data_v, string_v Logo_Description_v, ref ID_v cAdressAtom_Org_iD_v, ref long_v OrganisationData_ID_v) { string Err = null; // long_v Atom_Organisation_ID_v = null; long_v OrganisationTYPE_ID_v = null; if (f_cOrgTYPE.Get(OrganisationTYPE_v, ref OrganisationTYPE_ID_v)) { if (f_cAddress_Org.Get(Address_v, ref cAdressAtom_Org_iD_v)) { ID_v cHomePage_Org_ID_v = null; string cHomePage_Org_ID_v_cond = "cHomePage_Org_ID is null"; string cHomePage_Org_ID_v_Value = "null"; if (fs.Get_ID("cHomePage_Org", "HomePage", HomePage_v, ref cHomePage_Org_ID_v, ref Err)) { if (cHomePage_Org_ID_v != null) { cHomePage_Org_ID_v_Value = cHomePage_Org_ID_v.v.ToString(); cHomePage_Org_ID_v_cond = "cHomePage_Org_ID = " + cHomePage_Org_ID_v_Value; } } ID_v cEmail_Org_ID_v = null; string cEmail_Org_ID_v_cond = "cEmail_Org_ID is null"; string cEmail_Org_ID_v_Value = "null"; if (fs.Get_ID("cEmail_Org", "Email", Email_v, ref cEmail_Org_ID_v, ref Err)) { if (cEmail_Org_ID_v != null) { cEmail_Org_ID_v_Value = cEmail_Org_ID_v.v.ToString(); cEmail_Org_ID_v_cond = "cEmail_Org_ID = " + cEmail_Org_ID_v_Value; } } ID_v cPhoneNumber_Org_ID_v = null; string cPhoneNumber_Org_ID_v_cond = "cPhoneNumber_Org_ID is null"; string cPhoneNumber_Org_ID_v_Value = "null"; if (fs.Get_ID("cPhoneNumber_Org", "PhoneNumber", PhoneNumber_v, ref cPhoneNumber_Org_ID_v, ref Err)) { if (cPhoneNumber_Org_ID_v != null) { cPhoneNumber_Org_ID_v_Value = cPhoneNumber_Org_ID_v.v.ToString(); cPhoneNumber_Org_ID_v_cond = "cPhoneNumber_Org_ID = " + cPhoneNumber_Org_ID_v_Value; } } ID_v cFaxNumber_Org_ID_v = null; string cFaxNumber_Org_ID_v_cond = "cFaxNumber_Org_ID is null"; string cFaxNumber_Org_ID_v_Value = "null"; if (fs.Get_ID("cFaxNumber_Org", "FaxNumber", FaxNumber_v, ref cFaxNumber_Org_ID_v, ref Err)) { if (cFaxNumber_Org_ID_v != null) { cFaxNumber_Org_ID_v_Value = cFaxNumber_Org_ID_v.v.ToString(); cFaxNumber_Org_ID_v_cond = "cFaxNumber_Org_ID = " + cFaxNumber_Org_ID_v_Value; } } long_v Logo_ID_v = null; string Logo_ID_cond = "Logo_ID is null"; string Logo_ID_Value = "null"; // = null; //if (Logo != null) //{ // Image_Data_v = new byte_array_v(); // Image_Data_v.v = DBtypesFunc.imageToByteArray(Logo, Logo.RawFormat); //} if (f_Logo.Get(Logo_Hash_v, Image_Data_v, Logo_Description_v, ref Logo_ID_v)) { if (Logo_ID_v != null) { Logo_ID_Value = Logo_ID_v.v.ToString(); Logo_ID_cond = "Logo_ID = " + Logo_ID_Value; } } List<SQL_Parameter> lpar = new List<SQL_Parameter>(); //if (BankName_v != null) //{ // BankName_Value = "@par_BankName"; // SQL_Parameter par_BankName = new SQL_Parameter(BankName_Value, SQL_Parameter.eSQL_Parameter.Nvarchar, false, BankName_v.v); // lpar.Add(par_BankName); // BankName_condition = " BankName = " + par_BankName.Name + " "; //} //else //{ // BankName_condition = " BankName is null "; // BankName_Value = "null"; //} //if (TRR_v != null) //{ // TRR_Value = "@par_TRR"; // SQL_Parameter par_TRR = new SQL_Parameter(TRR_Value, SQL_Parameter.eSQL_Parameter.Nvarchar, false, TRR_v.v); // lpar.Add(par_TRR); // TRR_condition = " TRR = " + par_TRR.Name + " "; //} //else //{ // TRR_condition = " TRR is null "; // TRR_Value = "null"; //} string cOrgTYPE_ID_condition = null; string cOrgTYPE_ID_value = null; if (OrganisationTYPE_ID_v != null) { cOrgTYPE_ID_condition = " cOrgTYPE_ID = " + cAdressAtom_Org_iD_v.v.ToString(); cOrgTYPE_ID_value = cAdressAtom_Org_iD_v.v.ToString(); } else { cOrgTYPE_ID_condition = " cOrgTYPE_ID is null "; cOrgTYPE_ID_value = "null"; } string cAddress_Org_ID_condition = null; if (cAdressAtom_Org_iD_v != null) { cAddress_Org_ID_condition = " cAddress_Org_ID = " + cAdressAtom_Org_iD_v.v.ToString(); } else { cAddress_Org_ID_condition = " cAddress_Org_ID is null "; } string sql_select = "select ID from OrganisationData where Organisation_ID =" + Organisation_ID.ToString() + @" and " + cOrgTYPE_ID_condition + @" and " + cAddress_Org_ID_condition + @" and " + cHomePage_Org_ID_v_cond + @" and " + cEmail_Org_ID_v_cond + @" and " + cPhoneNumber_Org_ID_v_cond + @" and " + cFaxNumber_Org_ID_v_cond + @" and " + Logo_ID_cond; DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql_select, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (OrganisationData_ID_v == null) { OrganisationData_ID_v = new long_v(); } OrganisationData_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { string sql_insert = @"insert into OrganisationData (Organisation_ID,cOrgTYPE_ID,cAddress_Org_ID,cHomePage_Org_ID,cEmail_Org_ID,cPhoneNumber_Org_ID,cFaxNumber_Org_ID,Logo_ID) values ( " + Organisation_ID.ToString() + @", " + cOrgTYPE_ID_value + @", " + cAdressAtom_Org_iD_v.v.ToString() + @", " + cHomePage_Org_ID_v_Value + @", " + cEmail_Org_ID_v_Value + @", " + cPhoneNumber_Org_ID_v_Value + @", " + cFaxNumber_Org_ID_v_Value + @", " + Logo_ID_Value + ")"; object oret = null; long OrganisationData_ID = -1; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, lpar, ref OrganisationData_ID, ref oret, ref Err, "OrganisationData")) { if (OrganisationData_ID_v == null) { OrganisationData_ID_v = new long_v(); } OrganisationData_ID_v.v = OrganisationData_ID; return true; } else { LogFile.Error.Show("ERROR:f_OrganisationData:Get:sql=" + sql_insert + "\r\nErr=" + Err); } } } else { LogFile.Error.Show("ERROR:f_OrganisationData:Get:sql=" + sql_select + "\r\nErr=" + Err); } } } return false; }
//string_v StreetName_v = tf.set_string(Address.StreetName); //string_v HouseNumber_v = tf.set_string(Address.HouseNumber); //string_v ZIP_v = tf.set_string(Address.ZIP); //string_v City_v = tf.set_string(Address.City); //string_v Country_v = tf.set_string(Address.Country); //string_v State_v = tf.set_string(Address.State); //string_v PhoneNumber_v = tf.set_string(PhoneNumber); //string_v FaxNumber_v = tf.set_string(FaxNumber); //string_v Email_v = tf.set_string(Email); //string_v HomePage_v = tf.set_string(HomePage); //string_v Logo_Hash_v = tf.set_string(Logo_Hash); //byte_array_v Logo_Image_Data_v = tf.set_byte_array(Logo); //string_v Logo_Description_v = tf.set_string(Logo_Description); public static bool Get( string_v Organisation_Name_v, string_v Tax_ID_v, string_v Registration_ID_v, string_v OrganisationTYPE_v, PostAddress_v Address_v, string_v PhoneNumber_v, string_v FaxNumber_v, string_v Email_v, string_v HomePage_v, string_v BankName_v, string_v TRR_v, string_v Logo_Hash_v, byte_array_v Logo_Image_Data_v, string_v Logo_Description_v, ref ID_v iD_v) { string Err = null; long_v Atom_Organisation_ID_v = null; long_v Atom_OrganisationData_ID_v = null; if (f_Atom_Organisation.Get( Organisation_Name_v, Tax_ID_v, Registration_ID_v, OrganisationTYPE_v, Address_v, PhoneNumber_v, FaxNumber_v, Email_v, HomePage_v, BankName_v, TRR_v, Logo_Hash_v, Logo_Image_Data_v, Logo_Description_v, ref Atom_Organisation_ID_v, ref Atom_OrganisationData_ID_v )) { DataTable dt = new DataTable(); string sql_select = "select ID from Atom_myOrganisation where Atom_OrganisationData_ID = " + Atom_OrganisationData_ID_v.v.ToString(); if (DBSync.DBSync.ReadDataTable(ref dt, sql_select, null, ref Err)) { if (dt.Rows.Count > 0) { if (iD_v == null) { iD_v = new ID_v(); } iD_v.v = (long)dt.Rows[0]["ID"]; return true; } else { long Atom_myOrganisation_id = -1; string sql_insert = " insert into Atom_myOrganisation (Atom_OrganisationData_ID) values (" + Atom_OrganisationData_ID_v.v.ToString() + ")"; object oret = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, null, ref Atom_myOrganisation_id, ref oret, ref Err, "Atom_myOrganisation")) { if (iD_v == null) { iD_v = new ID_v(); } iD_v.v = Atom_myOrganisation_id; return true; } else { LogFile.Error.Show("ERROR:Insert_Atom_myOrganisation:sql_insert:Err=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:myOrg:Insert_Atom_myOrganisation:sql_select=" + sql_select + "\r\nErr=" + Err); return false; } } else { return false; } }
public void Set(string DocInvoice, DataRow dria, ref List<object> DocInvoice_ShopC_Item_Data_list) { Stock_Data stock_data = null; int i = 0; int iCount = DocInvoice_ShopC_Item_Data_list.Count; Atom_Item_ID = tf.set_long(dria["Atom_Item_ID"]); if (Atom_Item_ID != null) { for (i = 0; i < iCount; i++) { if (((Atom_DocInvoice_ShopC_Item_Price_Stock_Data)DocInvoice_ShopC_Item_Data_list[i]).Atom_Item_ID.v == Atom_Item_ID.v) { stock_data = new Stock_Data(); stock_data.Set(dria); ((Atom_DocInvoice_ShopC_Item_Price_Stock_Data)DocInvoice_ShopC_Item_Data_list[i]).m_ShopShelf_Source.Stock_Data_List.Add(stock_data); return; } } m_ShopShelf_Source.Clear(); DocInvoice_ShopC_Item_ID = tf.set_long(dria[DocInvoice+"_ShopC_Item_ID"]); DocInvoice_ID = tf.set_long(dria[DocInvoice+"_ID"]); Atom_Price_Item_ID = tf.set_long(dria["Atom_Price_Item_ID"]); dQuantity_all = tf.set_decimal(dria["dQuantity"]); RetailPricePerUnit = tf.set_decimal(dria["RetailPricePerUnit"]); Discount = tf.set_decimal(dria["Discount"]); RetailPriceWithDiscount = tf.set_decimal(dria["RetailPriceWithDiscount"]); TaxPrice = tf.set_decimal(dria["TaxPrice"]); ExtraDiscount = tf.set_decimal(dria["ExtraDiscount"]); //dQuantity = tf.set_decimal(dria["dQuantity"]); Atom_Item_UniqueName = tf.set_string(dria["Atom_Item_UniqueName"]); Atom_Item_Name_Name = tf.set_string(dria["Atom_Item_Name_Name"]); Atom_Item_barcode_barcode = tf.set_string(dria["Atom_Item_barcode_barcode"]); Atom_Taxation_Name = tf.set_string(dria["Atom_Taxation_Name"]); Atom_Taxation_Rate = tf.set_decimal(dria["Atom_Taxation_Rate"]); Atom_Item_Description_Description = tf.set_string(dria["Atom_Item_Description_Description"]); Atom_Warranty_ID = tf.set_long(dria["Atom_Warranty_ID"]); Atom_Warranty_WarrantyDurationType = tf.set_short(dria["Atom_Warranty_WarrantyDurationType"]); Atom_Warranty_WarrantyDuration = tf.set_int(dria["Atom_Warranty_WarrantyDuration"]); Atom_Warranty_WarrantyConditions = tf.set_string(dria["Atom_Warranty_WarrantyConditions"]); Atom_Expiry_ID = tf.set_long(dria["Atom_Expiry_ID"]); Atom_Expiry_ExpectedShelfLifeInDays = tf.set_int(dria["Atom_Expiry_ExpectedShelfLifeInDays"]); Atom_Expiry_SaleBeforeExpiryDateInDays = tf.set_int(dria["Atom_Expiry_SaleBeforeExpiryDateInDays"]); Atom_Expiry_DiscardBeforeExpiryDateInDays = tf.set_int(dria["Atom_Expiry_DiscardBeforeExpiryDateInDays"]); Atom_Expiry_ExpiryDescription = tf.set_string(dria["Atom_Expiry_ExpiryDescription"]); Item_ID = tf.set_long(dria["Item_ID"]); Atom_Unit_Name = tf.set_string(dria["Atom_Unit_Name"]); Atom_Unit_Symbol = tf.set_string(dria["Atom_Unit_Symbol"]); Atom_Unit_DecimalPlaces = tf.set_int(dria["Atom_Unit_DecimalPlaces"]); Atom_Unit_Description = tf.set_string(dria["Atom_Unit_Description"]); Atom_Unit_StorageOption = tf.set_bool(dria["Atom_Unit_StorageOption"]); Atom_PriceList_Name = tf.set_string(dria["Atom_PriceList_Name"]); Atom_Currency_Name = tf.set_string(dria["Atom_Currency_Name"]); Atom_Currency_Abbreviation = tf.set_string(dria["Atom_Currency_Abbreviation"]); Atom_Currency_Symbol = tf.set_string(dria["Atom_Currency_Symbol"]); Atom_Currency_DecimalPlaces = tf.set_int(dria["Atom_Currency_DecimalPlaces"]); Atom_Item_Image_Hash = tf.set_string(dria["Atom_Item_Image_Hash"]); Atom_Item_Image_Data = tf.set_byte_array(dria["Atom_Item_Image_Data"]); if (dria["s1_name"] is string) { s1_name = (string)dria["s1_name"]; } if (dria["s2_name"] is string) { s2_name = (string)dria["s2_name"]; } if (dria["s3_name"] is string) { s3_name = (string)dria["s3_name"]; } stock_data = new Stock_Data(); stock_data.Set(dria); m_ShopShelf_Source.Stock_Data_List.Add(stock_data); DocInvoice_ShopC_Item_Data_list.Add(this); } else { LogFile.Error.Show("ERROR:DocInvoice_ShopC_Item_Data:Set(DataRow dria,..):Atom_Item_ID == null"); } }
public static bool Get(long myOrg_id) { DataTable dt_myOrganisation = new DataTable(); myOrg.ID_v = null; myOrg.Name_v = null; myOrg.Tax_ID_v = null; myOrg.Registration_ID_v = null; myOrg.OrganisationTYPE_v = null; myOrg.PhoneNumber_v = null; myOrg.FaxNumber_v = null; myOrg.HomePage_v = null; myOrg.Email_v = null; myOrg.Logo_Image_Data_v = null; myOrg.Logo_Hash_v = null; myOrg.Address_v.StreetName_v = null; myOrg.Address_v.HouseNumber_v = null; myOrg.Address_v.ZIP_v = null; myOrg.Address_v.City_v = null; myOrg.Address_v.Country_v = null; myOrg.Address_v.Country_ISO_3166_a2_v = null; myOrg.Address_v.Country_ISO_3166_a3_v = null; myOrg.Address_v.Country_ISO_3166_num_v = null; myOrg.Address_v.State_v = null; string sql = null; if (myOrg_id >= 0) { sql = @"Select ID, myOrganisation_$_orgd_$$ID, myOrganisation_$_orgd_$_org_$$ID, myOrganisation_$_orgd_$_org_$$Name, myOrganisation_$_orgd_$_org_$$Tax_ID, myOrganisation_$_orgd_$_org_$$Registration_ID, myOrganisation_$_orgd_$_orgt_$$OrganisationTYPE, myOrganisation_$_orgd_$_cadrorg_$_cstrnorg_$$StreetName, myOrganisation_$_orgd_$_cadrorg_$_chounorg_$$HouseNumber, myOrganisation_$_orgd_$_cadrorg_$_ccitorg_$$City, myOrganisation_$_orgd_$_cadrorg_$_cziporg_$$ZIP, myOrganisation_$_orgd_$_cadrorg_$_ccouorg_$$Country, myOrganisation_$_orgd_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a2, myOrganisation_$_orgd_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a3, myOrganisation_$_orgd_$_cadrorg_$_ccouorg_$$Country_ISO_3166_num, myOrganisation_$_orgd_$_cadrorg_$_cstorg_$$State, myOrganisation_$_orgd_$_cphnnorg_$$PhoneNumber, myOrganisation_$_orgd_$_cfaxnorg_$$FaxNumber, myOrganisation_$_orgd_$_cemailorg_$$Email, myOrganisation_$_orgd_$_chomepgorg_$$HomePage, myOrganisation_$_orgd_$_logo_$$Image_Hash, myOrganisation_$_orgd_$_logo_$$Image_Data, myOrganisation_$_orgd_$_logo_$$Description from myOrganisation_VIEW where ID = " + myOrg_id.ToString(); } else { sql = @"Select ID, myOrganisation_$_orgd_$$ID, myOrganisation_$_orgd_$_org_$$ID, myOrganisation_$_orgd_$_org_$$Name, myOrganisation_$_orgd_$_org_$$Tax_ID, myOrganisation_$_orgd_$_org_$$Registration_ID, myOrganisation_$_orgd_$_orgt_$$OrganisationTYPE, myOrganisation_$_orgd_$_cadrorg_$_cstrnorg_$$StreetName, myOrganisation_$_orgd_$_cadrorg_$_chounorg_$$HouseNumber, myOrganisation_$_orgd_$_cadrorg_$_ccitorg_$$City, myOrganisation_$_orgd_$_cadrorg_$_cziporg_$$ZIP, myOrganisation_$_orgd_$_cadrorg_$_ccouorg_$$Country, myOrganisation_$_orgd_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a2, myOrganisation_$_orgd_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a3, myOrganisation_$_orgd_$_cadrorg_$_ccouorg_$$Country_ISO_3166_num, myOrganisation_$_orgd_$_cadrorg_$_cstorg_$$State, myOrganisation_$_orgd_$_cphnnorg_$$PhoneNumber, myOrganisation_$_orgd_$_cfaxnorg_$$FaxNumber, myOrganisation_$_orgd_$_cemailorg_$$Email, myOrganisation_$_orgd_$_chomepgorg_$$HomePage, myOrganisation_$_orgd_$_logo_$$Image_Hash, myOrganisation_$_orgd_$_logo_$$Image_Data, myOrganisation_$_orgd_$_logo_$$Description from myOrganisation_VIEW"; } string Err = null; dt_myOrganisation.Clear(); if (DBSync.DBSync.ReadDataTable(ref dt_myOrganisation, sql, ref Err)) { if (dt_myOrganisation.Rows.Count > 0) { myOrg.ID_v = tf.set_long(dt_myOrganisation.Rows[0]["ID"]); myOrg.Name_v = tf.set_string(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_org_$$Name"]); myOrg.Tax_ID_v = tf.set_string(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_org_$$Tax_ID"]); myOrg.Registration_ID_v = tf.set_string(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_org_$$Registration_ID"]); myOrg.OrganisationTYPE_v = tf.set_string(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_orgt_$$OrganisationTYPE"]); myOrg.PhoneNumber_v = tf.set_string(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_cphnnorg_$$PhoneNumber"]); myOrg.FaxNumber_v = tf.set_string(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_cfaxnorg_$$FaxNumber"]); myOrg.HomePage_v = tf.set_string(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_chomepgorg_$$HomePage"]); myOrg.Email_v = tf.set_string(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_cemailorg_$$Email"]); myOrg.Logo_Image_Data_v = tf.set_byte_array(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_logo_$$Image_Data"]); myOrg.Logo_Hash_v = tf.set_string(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_logo_$$Image_Hash"]); if (myOrg.Logo_Image_Data_v != null) { ImageConverter ic = new ImageConverter(); myOrg.Logo = (Image)ic.ConvertFrom(myOrg.Logo_Image_Data_v.v); } myOrg.Address_v.StreetName_v = tf.set_dstring(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_cadrorg_$_cstrnorg_$$StreetName"]); myOrg.Address_v.HouseNumber_v = tf.set_dstring(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_cadrorg_$_chounorg_$$HouseNumber"]); myOrg.Address_v.ZIP_v = tf.set_dstring(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_cadrorg_$_cziporg_$$ZIP"]); myOrg.Address_v.City_v = tf.set_dstring(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_cadrorg_$_ccitorg_$$City"]); myOrg.Address_v.Country_v = tf.set_dstring(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_cadrorg_$_ccouorg_$$Country"]); myOrg.Address_v.Country_ISO_3166_a2_v = tf.set_dstring(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a2"]); myOrg.Address_v.Country_ISO_3166_a3_v = tf.set_dstring(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a3"]); myOrg.Address_v.Country_ISO_3166_num_v = tf.set_dshort(fs.MyConvertToShort(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_cadrorg_$_ccouorg_$$Country_ISO_3166_num"])); myOrg.Address_v.State_v = tf.set_dstring(dt_myOrganisation.Rows[0]["myOrganisation_$_orgd_$_cadrorg_$_cstorg_$$State"]); if (myOrg.ID_v != null) { myOrg_Office_List.Get(myOrg.ID_v.v, ref myOrg.myOrg_Office_list); myOrg_Person_List.Get(myOrg.ID_v.v, ref myOrg.myOrg_Person_list); } } return true; } else { LogFile.Error.Show("ERROR:MyOrg:Get:sql=" + sql+"\r\nErr="+Err); return false; } }
public static bool Get(string_v Organisation_Name_v, string_v Tax_ID_v, string_v Registration_ID_v, string_v OrganisationTYPE_v, PostAddress_v Address_v, string_v PhoneNumber_v, string_v FaxNumber_v, string_v Email_v, string_v HomePage_v, string_v BankName_v, string_v TRR_v, string_v Image_Hash_v, byte_array_v Image_Data_v, string_v Image_Description_v, ref long_v Atom_Organisation_ID_v, ref long_v Atom_OrganisationData_ID_v) { string Err = null; string Name_condition = null; string Tax_ID_condition = null; string Registration_ID_condition = null; string sName_value = null; string sTaxID_value = null; string sRegistration_ID_value = null; List<SQL_Parameter> lpar = new List<SQL_Parameter>(); if (Organisation_Name_v != null) { SQL_Parameter par_Name = new SQL_Parameter("@par_Name", SQL_Parameter.eSQL_Parameter.Nvarchar, false, Organisation_Name_v.v); lpar.Add(par_Name); Name_condition = " Name = " + par_Name.Name + " "; sName_value = "@par_Name"; } else { Name_condition = " Name is null "; sName_value = "null"; } if (Tax_ID_v != null) { SQL_Parameter par_Tax_ID = new SQL_Parameter("@par_Tax_ID", SQL_Parameter.eSQL_Parameter.Nvarchar, false, Tax_ID_v.v); lpar.Add(par_Tax_ID); Tax_ID_condition = " Tax_ID = " + par_Tax_ID.Name + " "; sTaxID_value = "@par_Tax_ID"; } else { Tax_ID_condition = " Tax_ID is null "; sTaxID_value = "null"; } if (Registration_ID_v != null) { SQL_Parameter par_Registration_ID = new SQL_Parameter("@par_Registration_ID", SQL_Parameter.eSQL_Parameter.Nvarchar, false, Registration_ID_v.v); lpar.Add(par_Registration_ID); Registration_ID_condition = " Registration_id = " + par_Registration_ID.Name + " "; sRegistration_ID_value = "@par_Registration_ID"; } else { Registration_ID_condition = " Registration_ID is null "; sRegistration_ID_value = "null"; } string sql_select = "select ID from Atom_Organisation where " + Name_condition + @" and " + Tax_ID_condition + @" and " + Registration_ID_condition; DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql_select, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (Atom_Organisation_ID_v == null) { Atom_Organisation_ID_v = new long_v(); } Atom_Organisation_ID_v.v = (long)dt.Rows[0]["ID"]; return f_Atom_OrganisationData.Get(Atom_Organisation_ID_v.v, OrganisationTYPE_v, Address_v, PhoneNumber_v, FaxNumber_v, Email_v, HomePage_v, Image_Hash_v, Image_Data_v, Image_Description_v, BankName_v, TRR_v, ref Atom_OrganisationData_ID_v); } else { string sql_insert = " insert into Atom_Organisation (Name,Tax_ID,Registration_ID) values (" + sName_value + "," + sTaxID_value + "," + sRegistration_ID_value + ")"; object oret = null; long Atom_Organisation_ID = -1; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, lpar, ref Atom_Organisation_ID, ref oret, ref Err, "Atom_Organisation")) { if (Atom_Organisation_ID_v == null) { Atom_Organisation_ID_v = new long_v(); } Atom_Organisation_ID_v.v = Atom_Organisation_ID; return f_Atom_OrganisationData.Get(Atom_Organisation_ID_v.v, OrganisationTYPE_v, Address_v, PhoneNumber_v, FaxNumber_v, Email_v, HomePage_v, Image_Hash_v, Image_Data_v, Image_Description_v, BankName_v, TRR_v, ref Atom_OrganisationData_ID_v); } else { LogFile.Error.Show("ERROR:f_Atom_Organisation:Get_Atom_Organisation:sql=" + sql_insert + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:f_Atom_Organisation:Get_Atom_Organisation:sql=" + sql_select + "\r\nErr=" + Err); return false; } }
public void Set(object xusrc_Item, Item_Data xItem_Data,long xDocInvoice_ID, decimal xFactoryQuantity, decimal xStockQuantity, bool b_from_factory) { m_ShopShelf_Source.Clear(); DocInvoice_ShopC_Item_ID = null; DocInvoice_ID = new long_v(); DocInvoice_ID.v = xDocInvoice_ID; Atom_Price_Item_ID = null; // tf.set_long(dria["Atom_Price_Item_ID"]); RetailPricePerUnit = (decimal_v)tf.Copy(xItem_Data.RetailPricePerUnit); //tf.set_decimal(dr[cpis.icol_RetailPricePerUnit]); Discount = (decimal_v)tf.Copy(xItem_Data.Price_Item_Discount); // tf.set_decimal(dr[cpis.icol_Discount]); decimal retail_price_with_discount = 0; RetailPriceWithDiscount = tf.set_decimal(retail_price_with_discount); //$$TODO decimal tax_price = 0; TaxPrice = tf.set_decimal(tax_price); ExtraDiscount = tf.set_decimal(xItem_Data.ExtraDiscount); Atom_Item_UniqueName = (string_v)tf.Copy(xItem_Data.Item_UniqueName);// tf.set_string(dr[cpis.icol_Item_UniqueName]); Atom_Item_Name_Name = (string_v)tf.Copy(xItem_Data.Item_Name);//tf.set_string(dr[cpis.icol_Item_Name]); Atom_Item_barcode_barcode = (string_v)tf.Copy(xItem_Data.Item_barcode);//tf.set_string(dr[cpis.icol_Item_barcode]); Atom_Taxation_Name = (string_v)tf.Copy(xItem_Data.Taxation_Name);//tf.set_string(dr[cpis.icol_Taxation_Name]); Atom_Taxation_Rate = (decimal_v)tf.Copy(xItem_Data.Taxation_Rate);//tf.set_decimal(dr[cpis.icol_Taxation_Rate]); Atom_Item_Description_Description = (string_v)tf.Copy(xItem_Data.Item_Description);//tf.set_string(dr[cpis.icol_Item_Description]); Atom_Warranty_ID = null; //tf.set_long(dria["Atom_Warranty_ID"]); Atom_Warranty_WarrantyDurationType = (short_v)tf.Copy(xItem_Data.Warranty_WarrantyDurationType);//tf.set_short(dr[cpis.icol_Warranty_WarrantyDurationType]); Atom_Warranty_WarrantyDuration = (int_v)tf.Copy(xItem_Data.Warranty_WarrantyDuration);//tf.set_int(dr[cpis.icol_Warranty_WarrantyDuration]); Atom_Warranty_WarrantyConditions = (string_v)tf.Copy(xItem_Data.Warranty_WarrantyConditions);//tf.set_string(dr[cpis.icol_Warranty_WarrantyConditions]); Atom_Expiry_ID = null; //tf.set_long(dr["Atom_Expiry_ID"]); Atom_Expiry_ExpectedShelfLifeInDays = (int_v)tf.Copy(xItem_Data.Expiry_ExpectedShelfLifeInDays);//tf.set_int(dr[cpis.icol_Expiry_ExpectedShelfLifeInDays]); Atom_Expiry_SaleBeforeExpiryDateInDays = (int_v)tf.Copy(xItem_Data.Expiry_SaleBeforeExpiryDateInDays);//tf.set_int(dr[cpis.icol_Expiry_SaleBeforeExpiryDateInDays]); Atom_Expiry_DiscardBeforeExpiryDateInDays = (int_v)tf.Copy(xItem_Data.Expiry_DiscardBeforeExpiryDateInDays);//tf.set_int(dr[cpis.icol_Expiry_DiscardBeforeExpiryDateInDays]); Atom_Expiry_ExpiryDescription = (string_v)tf.Copy(xItem_Data.Expiry_Description);//tf.set_string(dr[cpis.icol_Expiry_ExpiryDescription]); Item_ID = (long_v)tf.Copy(xItem_Data.Item_ID);//tf.set_long(dr["Item_ID"]); Atom_Unit_Name = (string_v)tf.Copy(xItem_Data.Unit_Name);//tf.set_string(dr[cpis.icol_Unit_Name]); Atom_Unit_Symbol = (string_v)tf.Copy(xItem_Data.Unit_Symbol);//tf.set_string(dr[cpis.icol_Unit_Symbol]); Atom_Unit_DecimalPlaces = (int_v)tf.Copy(xItem_Data.Unit_DecimalPlaces);//tf.set_int(dr[cpis.icol_Unit_DecimalPlaces]); Atom_Unit_Description = (string_v)tf.Copy(xItem_Data.Unit_Description);//tf.set_string(dr[cpis.icol_Unit_Description]); Atom_Unit_StorageOption = (bool_v)tf.Copy(xItem_Data.Unit_StorageOption);//tf.set_bool(dr[cpis.icol_Unit_StorageOption]); Atom_PriceList_Name = (string_v)tf.Copy(xItem_Data.PriceList_Name);//tf.set_string(dr[cpis.icol_PriceList_Name]); Atom_Currency_Name = (string_v)tf.Copy(xItem_Data.Currency_Name);// tf.set_string(dr[cpis.icol_Currency_Name]); Atom_Currency_Abbreviation = (string_v)tf.Copy(xItem_Data.Currency_Abbreviation);//tf.set_string(dr[cpis.icol_Currency_Abbreviation]); Atom_Currency_Symbol = (string_v)tf.Copy(xItem_Data.Currency_Symbol);//tf.set_string(dr[cpis.icol_Currency_Symbol]); Atom_Currency_DecimalPlaces = (int_v)tf.Copy(xItem_Data.Currency_DecimalPlaces);//tf.set_int(dr[cpis.icol_Currency_DecimalPlaces]); Atom_Item_Image_Hash = (string_v)tf.Copy(xItem_Data.Item_Image_Image_Hash);//tf.set_string(dr[cpis.icol_Currency_Symbol]); Atom_Item_Image_Data = (byte_array_v)tf.Copy(xItem_Data.Item_Image_Image_Data);//Itemtf.set_byte_array(dr[cpis.icol_Item_Image_Image_Data]); s1_name = xItem_Data.s1_name; s2_name = xItem_Data.s2_name; s3_name = xItem_Data.s3_name; m_ShopShelf_Source.Add_Stock_Data(xItem_Data, xFactoryQuantity, xStockQuantity, b_from_factory); }
public static byte_array_v set_byte_array(object p) { byte_array_v x = null; if (p == null) return null; if (p is byte[]) { x = new byte_array_v((byte[])p); } return x; }
public void set(object o) { this.type_v = null; if (o == null) return; if (o is byte[]) { this.type_v = new byte_array_v((byte[])o); } else if (o is System.DBNull) { return; } else { LogFile.Error.Show("ERROR:DB_Types:set:WRONG TYPE:" + o.GetType().ToString() + " should be " + this.GetType().ToString()); } }
public static bool Get_Atom_PersonImage_ID(string_v Image_Hash_v, byte_array_v Image_Data_v, ref long_v Atom_PersonImage_ID_v) { if (Image_Hash_v == null) { Atom_PersonImage_ID_v = null; return true; } List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string Image_Hash_cond = null; string Image_Hash_value = null; if (!AddPar("Image_Hash", ref lpar, Image_Hash_v, ref Image_Hash_cond, ref Image_Hash_value)) { return false; } string sql = "select ID from Atom_PersonImage where " + Image_Hash_cond; DataTable dt = new DataTable(); string Err = null; if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (Atom_PersonImage_ID_v == null) { Atom_PersonImage_ID_v = new long_v(); } Atom_PersonImage_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { string Image_Data_cond = null; string Image_Data_value = null; if (!AddPar("Image_Data", ref lpar, Image_Data_v, ref Image_Data_cond, ref Image_Data_value)) { return false; } sql = "insert into Atom_PersonImage (Image_Hash, Image_Data)values(" + Image_Hash_value + "," + Image_Data_value + ")"; long id = -1; object ores = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref id, ref ores, ref Err, "Atom_PersonImage")) { if (Atom_PersonImage_ID_v == null) { Atom_PersonImage_ID_v = new long_v(); } Atom_PersonImage_ID_v.v = id; return true; } else { LogFile.Error.Show("ERROR:f_Atom_Customer_Person:Get_Atom_PersonImage_ID:\r\nsql=" + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:f_Atom_Customer_Person:Get_Atom_PersonImage_ID:\r\nsql=" + sql + "\r\nErr=" + Err); return false; } }
public byte_array_v Clone() { byte_array_v o_v = new byte_array_v(); o_v.v = (byte[])this.v.Clone(); return o_v; }
public static byte_array_v Copy(byte_array_v o_v) { if (o_v != null) { return o_v.Clone(); } else { return null; } }
public void Set_Price_Item_Stock(DataRow xdr) { Price_Item_ID = tf.set_long(xdr["Price_Item_ID"]); Price_Item_Discount = tf.set_decimal(xdr["Price_Item_Discount"]); PriceList_ID = tf.set_long(xdr["PriceList_ID"]); PriceList_Name = tf.set_string(xdr["PriceList_Name"]); Currency_Name = tf.set_string(xdr["Currency_Name"]); ; Currency_Abbreviation = tf.set_string(xdr["Currency_Abbreviation"]); Currency_Symbol = tf.set_string(xdr["Currency_Symbol"]); Currency_DecimalPlaces = tf.set_int(xdr["Currency_DecimalPlaces"]); Stock_ID = tf.set_long(xdr["Stock_ID"]); Stock_ExpiryDate = tf.set_DateTime(xdr["Stock_ExpiryDate"]); Stock_dQuantity = tf.set_decimal(xdr["Stock_dQuantity"]); RetailPricePerUnit = tf.set_decimal(xdr["RetailPricePerUnit"]); Stock_ImportTime = tf.set_DateTime(xdr["Stock_ImportTime"]); Item_ID = tf.set_long(xdr["Item_ID"]); Item_UniqueName = tf.set_string(xdr["Item_UniqueName"]); Item_Name = tf.set_string(xdr["Item_Name"]); Item_barcode = tf.set_string(xdr["Item_barcode"]); Item_Image_ID = tf.set_long(xdr["Item_Image_ID"]); Item_Image_Image_Data = tf.set_byte_array(xdr["Item_Image_Image_Data"]); Item_Image_Image_Hash = tf.set_string(xdr["Item_Image_Image_Hash"]); Item_Description = tf.set_string(xdr["Item_Description"]); Unit_Name = tf.set_string(xdr["Unit_Name"]); Unit_Symbol = tf.set_string(xdr["Unit_Symbol"]); Unit_DecimalPlaces = tf.set_int(xdr["Unit_DecimalPlaces"]); Unit_StorageOption = tf.set_bool(xdr["Unit_StorageOption"]); Unit_Description = tf.set_string(xdr["Unit_Description"]); Expiry_ID = tf.set_long(xdr["Expiry_ID"]); Unit_Name = tf.set_string(xdr["Unit_Name"]); Expiry_ExpectedShelfLifeInDays = tf.set_int(xdr["Expiry_ExpectedShelfLifeInDays"]); Expiry_SaleBeforeExpiryDateInDays = tf.set_int(xdr["Expiry_SaleBeforeExpiryDateInDays"]); Expiry_DiscardBeforeExpiryDateInDays = tf.set_int(xdr["Expiry_DiscardBeforeExpiryDateInDays"]); Expiry_Description = tf.set_string(xdr["Expiry_ExpiryDescription"]); Item_Expiry_ID = tf.set_long(xdr["Expiry_ID"]); Item_ToOffer = tf.set_bool(xdr["Item_ToOffer"]); Item_Warranty_ID = tf.set_long(xdr["Warranty_ID"]); Warranty_ID = tf.set_long(xdr["Warranty_ID"]); Warranty_WarrantyConditions = tf.set_string(xdr["Warranty_WarrantyConditions"]); Warranty_WarrantyDuration = tf.set_int(xdr["Warranty_WarrantyDuration"]); Warranty_WarrantyDurationType = tf.set_short(fs.MyConvertToShort(xdr["Warranty_WarrantyDurationType"])); Taxation_ID = tf.set_long(xdr["Taxation_ID"]); Taxation_Name = tf.set_string(xdr["Taxation_Name"]); Taxation_Rate = tf.set_decimal(xdr["Taxation_Rate"]); PurchasePricePerUnit = tf.set_decimal(xdr["PurchasePricePerUnit"]); PurchaseOrganisation_Name = tf.set_string(xdr["PurchaseOrganisation_Name"]); PurchaseOrganisation_Address.StreetName_v = tf.set_dstring(xdr["StreetName"]); PurchaseOrganisation_Address.HouseNumber_v = tf.set_dstring(xdr["HouseNumber"]); PurchaseOrganisation_Address.City_v = tf.set_dstring(xdr["City"]); PurchaseOrganisation_Address.ZIP_v = tf.set_dstring(xdr["ZIP"]); PurchaseOrganisation_Address.Country_v = tf.set_dstring(xdr["Country"]); if (xdr["s1_name"] is string) { s1_name = (string)xdr["s1_name"]; } if (xdr["s2_name"] is string) { s2_name = (string)xdr["s2_name"]; } if (xdr["s3_name"] is string) { s3_name = (string)xdr["s3_name"]; } }
public static bool Get(bool_v Gender_v, string_v FirstName_v, string_v LastName_v, DateTime_v DateOfBirth_v, string_v Tax_ID_v, string_v Registration_ID_v, string_v GsmNumber_v, string_v PhoneNumber_v, string_v Email_v, string_v StreetName_v, string_v HouseNumber_v, string_v City_v, string_v ZIP_v, string_v Country_v, string_v Country_ISO_3166_a2, string_v Country_ISO_3166_a3, short_v Country_ISO_3166_num, string_v State_v, string_v CardNumber_v, string_v CardType_v, string_v Image_Hash_v, byte_array_v Image_Data_v, ref long_v Atom_Person_ID_v) { List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string Gender_cond = null; string Gender_value = null; if (!fs.AddPar("Gender", ref lpar, Gender_v, ref Gender_cond, ref Gender_value)) { return false; } long_v Atom_cFirstName_ID_v = null; if (!fs.Get_string_table_ID("Atom_cFirstName", "FirstName", FirstName_v, ref Atom_cFirstName_ID_v)) { return false; } string Atom_cFirstName_ID_cond = null; string Atom_cFirstName_ID_value = null; if (!fs.AddPar("Atom_cFirstName_ID", ref lpar, Atom_cFirstName_ID_v, ref Atom_cFirstName_ID_cond, ref Atom_cFirstName_ID_value)) { return false; } long_v Atom_cLastName_ID_v = null; if (!fs.Get_string_table_ID("Atom_cLastName", "LastName", LastName_v, ref Atom_cLastName_ID_v)) { return false; } string Atom_cLastName_ID_cond = null; string Atom_cLastName_ID_value = null; if (!fs.AddPar("Atom_cLastName_ID", ref lpar, Atom_cLastName_ID_v, ref Atom_cLastName_ID_cond, ref Atom_cLastName_ID_value)) { return false; } string DateOfBirth_cond = null; string DateOfBirth_value = null; if (!fs.AddPar("DateOfBirth", ref lpar, DateOfBirth_v, ref DateOfBirth_cond, ref DateOfBirth_value)) { return false; } string Tax_ID_cond = null; string Tax_ID_value = null; if (!fs.AddPar("Tax_ID", ref lpar, Tax_ID_v, ref Tax_ID_cond, ref Tax_ID_value)) { return false; } string Registration_ID_cond = null; string Registration_ID_value = null; if (!fs.AddPar("Registration_ID", ref lpar, Registration_ID_v, ref Registration_ID_cond, ref Registration_ID_value)) { return false; } long_v Atom_cGsmNumber_Person_ID_v = null; if (!fs.Get_string_table_ID("Atom_cGsmNumber_Person", "GsmNumber", GsmNumber_v, ref Atom_cGsmNumber_Person_ID_v)) { return false; } string Atom_cGsmNumber_Person_ID_cond = null; string Atom_cGsmNumber_Person_ID_value = null; if (!fs.AddPar("Atom_cGsmNumber_Person_ID", ref lpar, Atom_cGsmNumber_Person_ID_v, ref Atom_cGsmNumber_Person_ID_cond, ref Atom_cGsmNumber_Person_ID_value)) { return false; } long_v Atom_cPhoneNumber_Person_ID_v = null; if (!fs.Get_string_table_ID("Atom_cPhoneNumber_Person", "PhoneNumber", PhoneNumber_v, ref Atom_cPhoneNumber_Person_ID_v)) { return false; } string Atom_cPhoneNumber_Person_ID_cond = null; string Atom_cPhoneNumber_Person_ID_value = null; if (!fs.AddPar("Atom_cPhoneNumber_Person_ID", ref lpar, Atom_cPhoneNumber_Person_ID_v, ref Atom_cPhoneNumber_Person_ID_cond, ref Atom_cPhoneNumber_Person_ID_value)) { return false; } long_v Atom_cEmail_Person_ID_v = null; if (!fs.Get_string_table_ID("Atom_cEmail_Person", "Email", Email_v, ref Atom_cEmail_Person_ID_v)) { return false; } string Atom_cEmail_Person_cond = null; string Atom_cEmail_Person_value = null; if (!fs.AddPar("Atom_cEmail_Person_ID", ref lpar, Atom_cEmail_Person_ID_v, ref Atom_cEmail_Person_cond, ref Atom_cEmail_Person_value)) { return false; } long_v Atom_cAddress_Person_ID_v = null; if (!fs.Get_Atom_cAddress_Person_ID(StreetName_v, HouseNumber_v, ZIP_v, City_v, Country_v, State_v, ref Atom_cAddress_Person_ID_v )) { return false; } string Atom_cAddress_Person_ID_cond = null; string Atom_cAddress_Person_ID_value = null; if (!fs.AddPar("Atom_cAddress_Person_ID", ref lpar, Atom_cAddress_Person_ID_v, ref Atom_cAddress_Person_ID_cond, ref Atom_cAddress_Person_ID_value)) { return false; } string CardNumber_cond = null; string CardNumber_value = null; if (!fs.AddPar("CardNumber", ref lpar, CardNumber_v, ref CardNumber_cond, ref CardNumber_value)) { return false; } long_v Atom_cCardType_Person_ID_v = null; if (!fs.Get_string_table_ID("Atom_cCardType_Person", "CardType", CardType_v, ref Atom_cCardType_Person_ID_v)) { return false; } string Atom_cCardType_Person_ID_cond = null; string Atom_cCardType_Person_ID_value = null; if (!fs.AddPar("Atom_cCardType_Person_ID", ref lpar, Atom_cCardType_Person_ID_v, ref Atom_cCardType_Person_ID_cond, ref Atom_cCardType_Person_ID_value)) { return false; } long_v Atom_PersonImage_ID_v = null; if (!fs.Get_Atom_PersonImage_ID(Image_Hash_v, Image_Data_v, ref Atom_PersonImage_ID_v)) { return false; } string Atom_PersonImage_ID_cond = null; string Atom_PersonImage_ID_value = null; if (!fs.AddPar("Atom_PersonImage_ID", ref lpar, Atom_PersonImage_ID_v, ref Atom_PersonImage_ID_cond, ref Atom_PersonImage_ID_value)) { return false; } string sql = "select ID from Atom_Person where " + Gender_cond + " and " + Atom_cFirstName_ID_cond + " and " + Atom_cLastName_ID_cond + " and " + DateOfBirth_cond + " and " + Tax_ID_cond + " and " + Registration_ID_cond + " and " + Atom_cGsmNumber_Person_ID_cond + " and " + Atom_cPhoneNumber_Person_ID_cond + " and " + Atom_cEmail_Person_cond + " and " + Atom_cAddress_Person_ID_cond + " and " + Registration_ID_cond + " and " + CardNumber_cond + " and " + Atom_cCardType_Person_ID_cond + " and " + Atom_PersonImage_ID_cond + " order by ID desc"; DataTable dt = new DataTable(); string Err = null; if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (Atom_Person_ID_v == null) { Atom_Person_ID_v = new long_v(); } Atom_Person_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { sql = @"insert into Atom_Person (Gender, Atom_cFirstName_ID, Atom_cLastName_ID, DateOfBirth, Tax_ID, Registration_ID, Atom_cGsmNumber_Person_ID, Atom_cPhoneNumber_Person_ID, Atom_cEmail_Person_ID, Atom_cAddress_Person_ID, CardNumber, Atom_cCardType_Person_ID, Atom_PersonImage_ID )values(" + Gender_value + "," + Atom_cFirstName_ID_value + "," + Atom_cLastName_ID_value + "," + DateOfBirth_value + "," + Tax_ID_value + "," + Registration_ID_value + "," + Atom_cGsmNumber_Person_ID_value + "," + Atom_cPhoneNumber_Person_ID_value + "," + Atom_cEmail_Person_value + "," + Atom_cAddress_Person_ID_value + "," + CardNumber_value + "," + Atom_cCardType_Person_ID_value + "," + Atom_PersonImage_ID_value + ")"; long id = -1; object ores = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref id, ref ores, ref Err, "Atom_Person")) { if (Atom_Person_ID_v == null) { Atom_Person_ID_v = new long_v(); } Atom_Person_ID_v.v = id; return true; } else { LogFile.Error.Show("ERROR:f_Atom_Customer_Person:Get_Atom_Person_ID:\r\nsql=" + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:f_Atom_Customer_Person:Get_Atom_Person_ID:\r\nsql=" + sql + "\r\nErr=" + Err); return false; } }