public static bool_v Copy(bool_v o_v) { if (o_v != null) { return o_v.Clone(); } else { return null; } }
public static bool Get( string_v TRR_v, bool_v Active_v, string_v BankAccount_Description_v, long_v Bank_ID_v, ref long_v BankAccount_ID_v) { string Err = null; List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string TRR_v_cond = "TRR is null"; string TRR_v_Value = "null"; if (TRR_v != null) { TRR_v_Value = "@par_TRR"; SQL_Parameter par_Organisation_BankAccount_Description = new SQL_Parameter(TRR_v_Value, SQL_Parameter.eSQL_Parameter.Nvarchar, false, TRR_v.v); lpar.Add(par_Organisation_BankAccount_Description); TRR_v_cond = " TRR = " + TRR_v_Value; } string BankAccount_Description_v_cond = "Description is null"; string BankAccount_Description_v_Value = "null"; if (BankAccount_Description_v != null) { BankAccount_Description_v_Value = "@par_BankAccount_Description"; SQL_Parameter par_Organisation_BankAccount_BankAccount_Description = new SQL_Parameter(BankAccount_Description_v_Value, SQL_Parameter.eSQL_Parameter.Nvarchar, false, BankAccount_Description_v.v); lpar.Add(par_Organisation_BankAccount_BankAccount_Description); BankAccount_Description_v_cond = " Description = " + BankAccount_Description_v_Value; } string Active_v_cond = "Active is null"; string Active_v_Value = "null"; if (Active_v != null) { string sbinVal = "0"; if (Active_v.v) { sbinVal = "1"; } Active_v_Value = sbinVal; Active_v_cond = "Active = " + Active_v_Value; } string Bank_ID_v_cond = "Bank_ID is null"; string Bank_ID_v_Value = "null"; if (Bank_ID_v != null) { Bank_ID_v_Value = Bank_ID_v.v.ToString(); Bank_ID_v_cond = "Bank_ID = " + Bank_ID_v.v.ToString(); } string sql_select = "select ID from BankAccount where " + Bank_ID_v_cond + @" and " + TRR_v_cond + @" and " + BankAccount_Description_v_cond + @" and " + Active_v_cond; DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql_select, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (BankAccount_ID_v == null) { BankAccount_ID_v = new long_v(); } BankAccount_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { string sql_insert = @"insert into BankAccount (TRR,Active,Description,Bank_ID) values ( " + TRR_v_Value + @", " + Active_v_Value + @", " + BankAccount_Description_v_Value + @", " + Bank_ID_v_Value + ")"; object oret = null; long BankAccount_ID = -1; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, lpar, ref BankAccount_ID, ref oret, ref Err, "BankAccount")) { if (BankAccount_ID_v == null) { BankAccount_ID_v = new long_v(); } BankAccount_ID_v.v = BankAccount_ID; return true; } else { LogFile.Error.Show("ERROR:f_BankAccount:Get:sql=" + sql_insert + "\r\nErr=" + Err); } } } else { LogFile.Error.Show("ERROR:f_BankAccount:Get:sql=" + sql_select + "\r\nErr=" + Err); } 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 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 void set(object o) { this.type_v = null; if (o == null) return; if (o is bool) { this.type_v = new bool_v((bool)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_v set_bool(object p) { bool_v x = null; if (p == null) return null; if (p is bool) { x = new bool_v((bool)p); } else if (!(p is System.DBNull)) { tf.ShowTypeError(p.GetType().ToString(), x.GetType().ToString()); } return x; }
public static bool Get(bool_v Person_Gender_v, string_v FirstName_v, string_v LastName_v, DateTime_v DateOfBirth_v, string_v Tax_ID_v, string_v Registration_ID_v, ref long_v Person_ID_v) { string Err = null; string Gender_condition = null; string sGender_value = null; string cFirstName_ID_condition = null; string cLastName_ID_condition = null; string Tax_ID_condition = null; string Registration_ID_condition = null; string DateOfBirth_condition = null; string scFirstName_ID_value = null; string scLastName_ID_value = null; string sTaxID_value = null; string sRegistration_ID_value = null; string sDateOfBirth_value = null; List<SQL_Parameter> lpar = new List<SQL_Parameter>(); long cFirstName_ID = -1; if (f_cFirstName.Get(FirstName_v, ref cFirstName_ID)) { long cLastName_ID = -1; if (f_cLastName.Get(LastName_v, ref cLastName_ID)) { if (Person_Gender_v != null) { string spar_Gender = "@par_Gender"; SQL_Parameter par_Gender = new SQL_Parameter(spar_Gender, SQL_Parameter.eSQL_Parameter.Bit, false, Person_Gender_v.v); lpar.Add(par_Gender); Gender_condition = " Gender = " + spar_Gender + " "; sGender_value = spar_Gender; } else { Gender_condition = " Gender is null "; sGender_value = "null"; } if (cFirstName_ID >= 0) { string spar_cFirstName_ID = "@par_cFirstName_ID"; SQL_Parameter par_FirstName = new SQL_Parameter(spar_cFirstName_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, cFirstName_ID); lpar.Add(par_FirstName); cFirstName_ID_condition = " cFirstName_ID = " + spar_cFirstName_ID + " "; scFirstName_ID_value = spar_cFirstName_ID; } else { cFirstName_ID_condition = " cFirstName_ID is null "; scFirstName_ID_value = "null"; } if (cLastName_ID >= 0) { string spar_cLastName_ID = "@par_cLastName_ID"; SQL_Parameter par_LastName = new SQL_Parameter(spar_cLastName_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, cLastName_ID); lpar.Add(par_LastName); cLastName_ID_condition = " cLastName_ID = " + spar_cLastName_ID + " "; scLastName_ID_value = spar_cLastName_ID; } else { cLastName_ID_condition = " cLastName_ID is null "; scLastName_ID_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"; } if (DateOfBirth_v != null) { string spar_DateOfBirth = "@par_DateOfBirth"; SQL_Parameter par_DateOfBirth = new SQL_Parameter(spar_DateOfBirth, SQL_Parameter.eSQL_Parameter.Datetime, false, DateOfBirth_v.v); lpar.Add(par_DateOfBirth); DateOfBirth_condition = " DateOfBirth = " + spar_DateOfBirth + " "; sDateOfBirth_value = spar_DateOfBirth; } else { DateOfBirth_condition = " DateOfBirth is null "; sDateOfBirth_value = "null"; } string sql_select = "select ID from Person where " + Gender_condition + @" and " + cFirstName_ID_condition + @" and " + cLastName_ID_condition + @" and " + DateOfBirth_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 (Person_ID_v == null) { Person_ID_v = new long_v(); } Person_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { string sql_insert = @" insert into Person (Gender, cFirstName_ID, cLastName_ID, DateOfBirth, Tax_ID, Registration_ID) values (" + sGender_value + "," + scFirstName_ID_value + "," + scLastName_ID_value + "," + sDateOfBirth_value + "," + sTaxID_value + "," + sRegistration_ID_value + ")"; object oret = null; long Person_ID = -1; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, lpar, ref Person_ID, ref oret, ref Err, "Person")) { if (Person_ID_v == null) { Person_ID_v = new long_v(); } Person_ID_v.v = Person_ID; return true; } else { LogFile.Error.Show("ERROR:f_Person:Get:sql=" + sql_insert + "\r\nErr=" + Err); } } } else { LogFile.Error.Show("ERROR:f_Person:Getn:sql=" + sql_select + "\r\nErr=" + Err); } } } return false; }
public bool_v Clone() { bool_v o_v = new bool_v(); o_v.v = this.v; return o_v; }
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(string_v UserName_v, string_v Password_v, string_v Job_v, bool_v Active_v, string_v Description_v, long_v Person_ID_v, long_v Office_ID_v, ref long_v myOrganisation_Person_v) { string Err = null; DataTable dt = new DataTable(); List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string UserName_cond = null; string UserName_value = null; string spar_UserName = "******"; fs.AddPar(spar_UserName, ref lpar, UserName_v, ref UserName_cond, ref UserName_value); string Password_cond = null; string Password_value = null; string spar_Password = "******"; fs.AddPar(spar_Password, ref lpar, Password_v, ref Password_cond, ref Password_value); string Job_cond = null; string Job_value = null; string spar_Job = "Job"; fs.AddPar(spar_Job, ref lpar, Job_v, ref Job_cond, ref Job_value); string Active_cond = null; string Active_value = null; string spar_Active = "Active"; fs.AddPar(spar_Active, ref lpar, Active_v, ref Active_cond, ref Active_value); string Description_cond = null; string Description_value = null; string spar_Description = "Description"; fs.AddPar(spar_Description, ref lpar, Description_v, ref Description_cond, ref Description_value); string Person_ID_cond = null; string Person_ID_value = null; string spar_Person_ID = "Person_ID"; fs.AddPar(spar_Person_ID, ref lpar, Person_ID_v, ref Person_ID_cond, ref Person_ID_value); string Office_ID_cond = null; string Office_ID_value = null; string spar_Office_ID = "Office_ID"; fs.AddPar(spar_Office_ID, ref lpar, Office_ID_v, ref Office_ID_cond, ref Office_ID_value); string sql = "select ID from myOrganisation_Person where " + UserName_cond + " and " + Password_cond + " and " + Job_cond + " and " + Active_cond + " and " + Description_cond + " and " + Person_ID_cond + " and " + Office_ID_cond; if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (myOrganisation_Person_v == null) { myOrganisation_Person_v = new long_v(); } myOrganisation_Person_v.v = (long)dt.Rows[0]["ID"]; return true; } else { sql = "select ID from myOrganisation_Person where " + UserName_cond ; if (DBSync.DBSync.ReadDataTable(ref dt, sql,lpar, ref Err)) { if (dt.Rows.Count > 0) { if (myOrganisation_Person_v == null) { myOrganisation_Person_v = new long_v(); } myOrganisation_Person_v.v = (long)dt.Rows[0]["ID"]; sql = "update myOrganisation_Person set Password = "******", Job = " + Job_value + @", Active = " + Active_value + @", Description = " + Description_value + @", Person_ID = " + Person_ID_value + @", Office_ID = " + Office_ID_value + @" where ID = " + myOrganisation_Person_v.v.ToString(); if (DBSync.DBSync.ExecuteNonQuerySQL_NoMultiTrans(sql, lpar, ref Err)) { return true; } else { LogFile.Error.Show("ERROR:f_myOrganisation:Get: sql = " + sql + "\r\nErr=" + Err); return false; } } else { sql = @"insert into myOrganisation_Person ( UserName, Password, Job, Active, Description, Person_ID, Office_ID ) values (" + UserName_value + @", " + Password_value + @", " + Job_value + @", " + Active_value + @", " + Description_value + @", " + Person_ID_value + @", " + Office_ID_value + @")"; long myOrganisation_Person_ID = -1; object oret = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref myOrganisation_Person_ID, ref oret, ref Err, "myOrganisation_Person")) { if (myOrganisation_Person_v == null) { myOrganisation_Person_v = new long_v(); } myOrganisation_Person_v.v = myOrganisation_Person_ID; return true; } else { LogFile.Error.Show("ERROR:f_myOrganisation_Person:Get: sql = " + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:f_myOrganisation_Person:Get: sql = " + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:f_myOrganisation_Person:Get: sql = " + sql + "\r\nErr=" + Err); return false; } }
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; } }