/// <summary>
/// 検索時入力チェック処理
/// </summary>
/// <returns></returns>
private bool checkFormValidation()
{
if (string.IsNullOrEmpty(MyCompany.Text1))
{
MyCompany.Focus();
base.ErrorMessage = "自社コードは必須入力項目です。";
return(false);
}
if (string.IsNullOrEmpty(CreateYearMonth.Text))
{
CreateYearMonth.Focus();
base.ErrorMessage = "作成年月は必須入力項目です。";
return(false);
}
//if (string.IsNullOrEmpty(ClosingDate.Text))
//{
// ClosingDate.Focus();
// base.ErrorMessage = "作成締日は必須入力項目です。";
// return false;
//}
if (string.IsNullOrEmpty(ClosingDate.Text) && string.IsNullOrEmpty(Customer.Text1) && string.IsNullOrEmpty(Customer.Text2))
{
base.ErrorMessage = "締日または得意先を指定してください";
return(false);
}
return(true);
}
public override void Execute()
{
var proposalScreen = FindObjectOfType <InestmentProposalScreen>();
if (proposalScreen.urgency < 2)
{
SoundManager.PlayFastCashSound();
}
else
{
SoundManager.PlayFastCashSound();
SoundManager.Play(Sound.FillPaper);
}
// sets urgency
proposalScreen.UpdateStartDates();
Companies.AcceptAllInvestmentProposals(MyCompany, Q);
MyCompany.RemoveAcceptsInvestments();
// set goal
Investments.AddCompanyGoal(MyCompany, Q, proposalScreen.Goal);
proposalScreen.ResetOffer();
}
private void btnApply_Click(object sender, EventArgs e)
{
try
{
MyCompany _myInfo = new MyCompany();
_myInfo.B_N = txtBusinessNumber.Text;
_myInfo.businessType = txtBusinessType.Text;
_myInfo.chairMan = txtChairman.Text;
_myInfo.email = txtEmail.Text;
_myInfo.etc = rtxtETC.Text;
_myInfo.fax = txtFax.Text;
_myInfo.homePage = txtHomePage.Text;
_myInfo.myDetailAddress = txtAddress.Text;
_myInfo.myName = txtMyName.Text;
_myInfo.myPostNo = txtZipNumber.Text;
_myInfo.phone = txtPhone.Text;
_myInfo.RegistryNumber = txtSocialRegistryNumber.Text;
_myInfo.startDate = txtInitialDate.Text;
_myInfo.subB_N = txtSubBusinessNumber.Text;
_myInfo.subBusinessType = txtBusinessContents.Text;
SetMyInfo(_myInfo);
}
catch (Exception)
{
}
}
/// <summary>
/// 현재 입력된 내용을 바탕으로 myInfo를 생성 및 반환
/// </summary>
private MyCompanyProxyVO SetMyInfo()
{
MyCompany mi = new MyCompany();
mi.myDetailAddress = this.txtAddress.Text;
mi.subBusinessType = this.txtBusinessContents.Text;
mi.B_N = this.txtBusinessNumber.Text;
mi.businessType = this.txtBusinessType.Text;
mi.chairMan = this.txtChairman.Text;
mi.email = this.txtEmail.Text;
mi.fax = this.txtFax.Text;
mi.homePage = this.txtHomePage.Text;
mi.startDate = this.txtInitialDate.Text;
mi.myName = this.txtMyName.Text;
mi.phone = this.txtPhone.Text;
mi.RegistryNumber = this.txtSocialRegistryNumber.Text;
mi.subB_N = this.txtSubBusinessNumber.Text;
mi.myPostNo = this.txtZipNumber.Text;
mi.etc = this.rtxtETC.Text;
MyCompanyProxyVO mpv = new MyCompanyProxyVO();
mpv.MyCompany = mi;
return(mpv);
}
public async Task <IActionResult> Edit(string id, [Bind("myCompanyId,companyName,contactName,address,phone,fax,email,website,taxRegisteredNumber,additionalInformation,createdAt")] MyCompany myCompany)
{
if (id != myCompany.myCompanyId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(myCompany);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MyCompanyExists(myCompany.myCompanyId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(myCompany));
}
/// <summary>
/// Add one Company (a type from one of the OData clients) to a Dictionary of MyCompany objects.
/// Only one of the "Comp" parameters should be non-null.
/// </summary>
/// <param name="companies">the Dictionary to add to</param>
/// <param name="MComp">a Company to add, from the Microsoft BC API Client</param>
/// <param name="EComp">a Company to add, from the Entocare BC API Client</param>
private void AddToMyCompanyDictionary(Dictionary <string, MyCompany> companies, MicrosoftBC.Company MComp = null, Entocare.NAV.Company EComp = null)
{
//Cast the received Company "subtype" to the MyCompany "supertype"... sort of
MyCompany comp = null;
if (MComp != null)
{
comp = new MyCompany(MComp);
}
else if (EComp != null)
{
comp = new MyCompany(EComp);
}
else
{
throw new InvalidOperationException("Error building up the Company Dictionary: one of the two Company subtypes should be supplied.");
}
//Add it to the Dictionary
if (!companies.ContainsKey(comp.Name))
{
companies.Add(comp.Name, comp);
}
else
{
throw new InvalidOperationException("Company name " + comp.Name + " is not unique within this BC instance (Sandbox=" + Debug + ")");
}
}
private void SetMyInfo(MyCompany _myInfo)
{
try
{
ICMD cmd = null;
MyCompanyProxyVO preMyInfo = this._myInfo;
if (this._myInfo != null)
{
cmd = new libHitpan5.Controller.CommandController.MyCompany.Update(SetMyInfo(), preMyInfo);
}
else
{
cmd = new libHitpan5.Controller.CommandController.MyCompany.Insert(SetMyInfo());
}
frmMain.htpClientLib.Do(cmd);
frmMain.htpClientLib.myInfo = SetMyInfo();
}
catch (NotAuthException) { MessageBox.Show("나의 정보를 입력하거나 수정할 권한이 없습니다"); }
catch (NotLoginException) { MessageBox.Show("로그인을 하지 않았습니다"); }
catch (Exception)
{
throw;
}
}
public static void UploadData()
{
MyCompany.Find();
MyCategory.Find();
MyManufacturer.Find(Hardware.ComputerMake());
MyAssetModel.Find(Hardware.ComputerMake(), Hardware.ComputerModel());
MyAsset.Find(Hardware.ComputerName(), Hardware.ComputerMake(), Hardware.ComputerModel(), Hardware.SerialNumber());
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
cmdSelectFile.Attributes.Add("onclick", "jQuery('#" + LogoUploader.ClientID + "').click();return false;");
cmdDeleteLogo.Visible = false;
imgLogo.Visible = false;
//first access to the page - fill all textboxes and display the logo
if (!Page.IsPostBack)
{
txtPassSMTP.Attributes["type"] = "password";
MyCompany myComp = BLMyCompany.GetMyCompanyInfo();
txtCompName.Text = myComp.Name;
txtAddresse.Text = myComp.Address;
txtPhone.Text = myComp.Phone;
txtEmail.Text = myComp.Email;
txtServerSMTP.Text = myComp.ServerSMTP;
txtPassSMTP.Text = myComp.PassSMTP;
if (myComp.Logo != null)
{
if (myComp.Logo != "")
{
txtLogoPath.Text = myComp.Logo;
cmdDeleteLogo.Visible = true;
imgLogo.Visible = true;
imgLogo.ImageUrl = "~/LogoHandler.ashx?filename=" + myComp.Logo;
}
}
}
//Display selected Logo & save the logo file to the image folder
if (IsPostBack && LogoUploader.PostedFile != null)
{
if (LogoUploader.PostedFile.FileName.Length > 0)
{
txtLogoPath.Text = LogoUploader.PostedFile.FileName;
cmdDeleteLogo.Visible = true;
imgLogo.Visible = true;
Session["ImageBytes"] = LogoUploader.FileBytes;
imgLogo.ImageUrl = "~/ImageHandler.ashx";
}
}
}
catch (Exception ex)
{
var myCustomValidator = new CustomValidator();
myCustomValidator.IsValid = false;
myCustomValidator.ErrorMessage = ex.Message;
Page.Validators.Add(myCustomValidator);
}
}
public async Task <IActionResult> Create([Bind("myCompanyId,companyName,contactName,address,phone,fax,email,website,taxRegisteredNumber,additionalInformation,createdAt")] MyCompany myCompany)
{
if (ModelState.IsValid)
{
_context.Add(myCompany);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(myCompany));
}
private void LoadMyCompany()
{
using (var dbContext = new FarnahadManufacturingDbContext())
{
_myCompany = dbContext.MyCompanies
.Include(item => item.Addresses)
.Include("Addresses.ContactInformations")
.Include(item => item.CreatedByUser).First();
FillData(_myCompany);
MainLayoutGroup.IsEnabled = true;
}
}
public static MyCompany GetMyCompanyInfo()
{
try
{
return(MyCompany.GetMyCompanyInfo());
}
catch (Exception ex)
{
log.Error(ex.Message);
throw ex;
}
}
public MyCompany GetMyCompanyInfo(string AuthKey, string serviceURL)
{
if (!securityManager.CheckSecurityToken(AuthKey))
{
throw new Exception("인증된 사용자가 아닙니다");
}
String Query = new MyCompanyQuery().GetMyCompanyInfo();
DataTable dt = DBController.getInstance().GetData(serviceURL, Query);
MyCompany my_company = JsonConvert.DeserializeObject <MyCompany>(dt.Rows[0]["jsonmyinfo"].ToString());
return(my_company);
}
private void ReadData(MyCompany myCompany)
{
myCompany.Title = TitleTextEdit.Text;
myCompany.DefaultCarrierId = DefaultCarrierComboBoxEdit.EditValue as int?;
myCompany.DefaultCarrierServiceId = DefaultCarrierServiceComboBoxEdit.EditValue as int?;
myCompany.IsTaxExempt = Convert.ToBoolean(IsTaxExemptCheckEdit.EditValue);
if (AddressesGridControl.ItemsSource is ObservableCollection <Address> addresses)
{
myCompany.Addresses = addresses.ToList();
}
myCompany.Logo = LogoImageEdit.EditValue as byte[];
}
internal string SetMyCompanyInfo(MyCompany myCompany, bool Exist)
{
string val = JsonConvert.SerializeObject(myCompany);
if (Exist)
{
return(string.Format("update commonsetting set jsonmyinfo='{0}'", val));
}
else
{
return(string.Format("insert into commonsetting(jsonmyinfo) values('{0}')", val));
}
}
protected void cmdSave_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
try
{
//throw new Exception("error...");
//save the logo file to the Images folder
if (txtLogoPath.Text != "")
{
cmdDeleteLogo.Visible = true;
imgLogo.Visible = true;
//string logoDirectory = Path.Combine(Request.PhysicalApplicationPath, C.logoFolder);
//string fullUploadPath = Path.Combine(logoDirectory, txtLogoPath.Text);
//LogoUploader.PostedFile.SaveAs(fullUploadPath);
//string relativePath = fullUploadPath.Replace(Request.ServerVariables["APPL_PHYSICAL_PATH"], String.Empty);
//photoUrl = Page.ResolveUrl(relativePath);
}
MyCompany myComp = new MyCompany
{
Name = txtCompName.Text,
Address = txtAddresse.Text,
Phone = txtPhone.Text,
Logo = txtLogoPath.Text,
Email = txtEmail.Text,
ServerSMTP = txtServerSMTP.Text,
PassSMTP = txtPassSMTP.Text
};
BLMyCompany.UpdateMyCompany(myComp);
}
catch (Exception ex)
{
var myCustomValidator = new CustomValidator();
myCustomValidator.IsValid = false;
myCustomValidator.ErrorMessage = ex.Message;
//myCustomValidator.ValidationGroup = "Group2";
Page.Validators.Add(myCustomValidator);
}
}
public void InvoiceServicesTotalControl()
{
List <Service> list = new List <Service>
{
new Service("test1", "2", 12000), //24 000
new Service("test2", "3", 1000)
}; //3000
decimal vat = 0.25M;
var mycompany = new MyCompany("", "", "", "", "", "", "", "");
var company = new Customer("default", "default");
Invoice invoice = new Invoice(company, vat, list, mycompany, 1, 14);
decimal expected = 27000;
decimal actual = invoice.TotalPriceIncludingVAT - invoice.VATAmount;
Assert.AreEqual(expected, actual);
}
public int SetMyCompanyInfo(string AuthKey, string serviceURL, MyCompany myCompanyInfo)
{
if (!securityManager.CheckSecurityToken(AuthKey))
{
throw new Exception("인증된 사용자가 아닙니다");
}
//기존 정보가 있는지 검증
bool Exist = false;
DataTable dt = DBController.getInstance().GetData(serviceURL, new MyCompanyQuery().GetMyCompanyInfo());
if (dt != null && dt.Rows.Count > 0)
{
Exist = true;
}
string Query = new MyCompanyQuery().SetMyCompanyInfo(myCompanyInfo, Exist);
return(DBController.getInstance().SetData(serviceURL, Query));
}
private void FillData(MyCompany myCompany)
{
TitleTextEdit.Text = myCompany.Title;
DefaultAddressUserControl.AddressDetail = myCompany.Addresses.FirstOrDefault(item => item.IsDefaultAddress)?.AddressDetail;
CreatedUserTextEdit.Text = myCompany.CreatedByUser?.UserName;
CreatedDateTextEdit.Text = myCompany.CreatedDateTime.ToLongTimeString();
DefaultContactInformationsGridControl.ItemsSource = myCompany.Addresses.FirstOrDefault(item => item.IsDefaultAddress)?.ContactInformations;
DefaultCarrierComboBoxEdit.EditValue = myCompany.DefaultCarrierId;
DefaultCarrierServiceComboBoxEdit.EditValue = myCompany.DefaultCarrierId;
IsTaxExemptCheckEdit.EditValue = myCompany.IsTaxExempt;
LogoImageEdit.EditValue = myCompany.Logo;
_addresses = new ObservableCollection <Address>(myCompany.Addresses);
AddressesGridControl.ItemsSource = _addresses;
}
public static void UpdateMyCompany(MyCompany newCompany)
{
try
{
if (newCompany == null)
{
throw new Exception("The 'MyCompany' entity does not contain any data!");
}
//Handle business rules...
MyCompany.UpdateMyCompany(newCompany);
}
catch (Exception ex)
{
log.Error(ex.Message);
throw ex;
}
}
public AboutUsViewModel()
{
Company = new MyCompany()
{
Name = "Rioja{dotnet}",
Delegations = new List <Delegation>()
{
new Delegation()
{
Name = "Rioja{dotnet}", City = "Logroño", Position = new Position(42.461108, -2.427075)
},
new Delegation()
{
Name = "DotNetters", City = "Zaragoza", Position = new Position(41.646682, -0.908887)
},
new Delegation()
{
Name = "Gasteiz developers", City = "Vitoria", Position = new Position(42.851078, -2.688660)
},
}
};
}
private void frm일반정보설정_Load(object sender, EventArgs e)
{
MyCompany mc = this._myInfo.MyCompany;
if (this._myInfo != null)
{
this.txtAddress.Text = mc.myDetailAddress;
this.txtBusinessContents.Text = mc.subBusinessType;
this.txtBusinessNumber.Text = mc.B_N;
this.txtBusinessType.Text = mc.businessType;
this.txtChairman.Text = mc.chairMan;
this.txtEmail.Text = mc.email;
this.txtFax.Text = mc.fax;
this.txtHomePage.Text = mc.homePage;
this.txtInitialDate.Text = mc.startDate;
this.txtMyName.Text = mc.myName;
this.txtPhone.Text = mc.phone;
this.txtSocialRegistryNumber.Text = mc.RegistryNumber;
this.txtSubBusinessNumber.Text = mc.subB_N;
this.txtZipNumber.Text = mc.myPostNo;
this.rtxtETC.Text = mc.etc;
}
}
/// <summary>
/// 業務入力チェックをおこなう
/// </summary>
/// <returns></returns>
private bool formValidation()
{
if (string.IsNullOrEmpty(FiscalYear.Text))
{
FiscalYear.Focus();
ErrorMessage = "処理年度が入力されていません。";
return(false);
}
if (string.IsNullOrEmpty(MyCompany.Text1))
{
MyCompany.Focus();
ErrorMessage = "対象販社が設定されていません。";
return(false);
}
if (string.IsNullOrEmpty(AjustRatio.Text))
{
// 未入力時はゼロを自動設定する
AjustRatio.Text = "0";
}
return(true);
}
public virtual int Update(MyCompany.Data.Objects.Company theCompany, MyCompany.Data.Objects.Company original_Company)
{
return ExecuteAction(theCompany, original_Company, "Edit", "Update", UpdateView);
}
public List<MyCompany.Data.Objects.Company> Select(MyCompany.Data.Objects.Company qbe)
{
return Select(qbe.CompanyID, qbe.CompanyName, qbe.Address, qbe.Phone, qbe.Fax, qbe.Email, qbe.CompanyTypeID, qbe.CompanyTypeDescription, qbe.LicenseTO, qbe.CashCode, qbe.BankCode, qbe.FixedAssetCode, qbe.Depreciation, qbe.RawMAcc, qbe.FinishGAcc, qbe.Inventory, qbe.DepCalYesNo, qbe.RawmStk, qbe.FinishStk, qbe.RCurr, qbe.RCurrRate, qbe.FCurr, qbe.FCurrRate, qbe.ProfitAcc, qbe.DateType, qbe.BaseCurrency, qbe.AccountBalShow, qbe.FundCode, qbe.BranchCode, qbe.SubLedYN, qbe.AccBalShow, qbe.FundCodeYN, qbe.BranchCodeYN, qbe.FixedAssetYN, qbe.SalesAcct, qbe.PurchaseAcct, qbe.InvtoryVchrAuto, qbe.SDebitor, qbe.SCreditor, qbe.ProjectYN, qbe.GodownYN, qbe.BatchYN, qbe.MgtYN, qbe.ExpireYN, qbe.Active, qbe.License, qbe.Instal, qbe.CopYN, qbe.VchrNumberUnique, qbe.VchrNumberByType, qbe.CurrAsset, qbe.CurrLiab, qbe.SaleAcc, qbe.PurAcc, qbe.FixedAcc, qbe.LoanLiab, qbe.CapAcc, qbe.OpnStkAcc, qbe.ClsStkAcc, qbe.FabricCatID, qbe.FabricItemID, qbe.FuelAcc, qbe.BasOwnerAcc, qbe.HelperAcc, qbe.DriverAcc, qbe.AdvanceAcc, qbe.TicketSaleAcc, qbe.TicketAcc, qbe.BusRsrvAcc, qbe.CntrDepositAcc, qbe.ConsFundCode, qbe.WorkinProgressAcc);
}
public virtual int Insert(MyCompany.Data.Objects.Company theCompany)
{
return ExecuteAction(theCompany, new Company(), "New", "Insert", InsertView);
}
public virtual int Delete(MyCompany.Data.Objects.Prefix thePrefix)
{
return ExecuteAction(thePrefix, thePrefix, "Select", "Delete", DeleteView);
}
public List<MyCompany.Data.Objects.MoneyReceipts> Select(MyCompany.Data.Objects.MoneyReceipts qbe)
{
return Select(qbe.MoneyReceiptsID, qbe.MRDate, qbe.MRNo, qbe.PlotSaleID, qbe.PayCatID, qbe.PayCatCategory, qbe.PCode, qbe.ReceAmount, qbe.ModeofReceiptID, qbe.ModeofReceiptDescription, qbe.ApplicantId, qbe.AccSubNameID, qbe.AccSubNameAccSubName, qbe.AccSubNameAccSubTypeAccSubType, qbe.Fileno, qbe.Checkno, qbe.CheckDate, qbe.CheckPostDate, qbe.CheckBankName, qbe.BankBranch, qbe.Dlt, qbe.Description, qbe.MultiPayment, qbe.CancelMR, qbe.CancelDate, qbe.ReceiptType, qbe.GName, qbe.GFathersName, qbe.Gaddress, qbe.vide, qbe.Created_BY, qbe.Created_DT, qbe.Updated_BY, qbe.Updated_DT, qbe.Remarks, qbe.DisplayAction, qbe.AccFundID, qbe.CoaDetailID, qbe.CoaDetailAccName, qbe.CoaDetailAccBalTypeAccBalType, qbe.CoaDetailAccCurrencyAccCurrencyName, qbe.CoaDetailAccDestAccDest, qbe.CoaDetailAccDestCompanyTypeDescription, qbe.CoaDetailAccFundAccFundCode, qbe.CoaDetailAccSubTypeAccSubType, qbe.CoaDetailAccTypeAccType, qbe.CoaDetailCoaControlAccName, qbe.CoaDetailCoaControlAccBalTypeAccBalType, qbe.CoaDetailCoaControlAccDestAccDest, qbe.CoaDetailCoaControlAccTypeAccType, qbe.CoaDetailCoaControlCompTypeDescription, qbe.CoaDetailCoaMainAccName, qbe.CoaDetailCoaMainAccBalTypeAccBalType, qbe.CoaDetailCoaMainAccDestAccDest, qbe.CoaDetailCoaMainAccFundAccFundCode, qbe.CoaDetailCoaMainAccTypeAccType, qbe.CoaDetailCoaMainCoaControlAccName, qbe.CoaDetailCoaSubAccName, qbe.CoaDetailCoaSubAccBalTypeAccBalType, qbe.CoaDetailCoaSubAccDestAccDest, qbe.CoaDetailCoaSubAccFundAccFundCode, qbe.CoaDetailCoaSubAccTypeAccType, qbe.CoaDetailCoaSubCoaControlAccName, qbe.CoaDetailCoaSubCoaMainAccName, qbe.AccTranID);
}
public virtual int Delete(MyCompany.Data.Objects.MoneyReceipts theMoneyReceipts)
{
return ExecuteAction(theMoneyReceipts, theMoneyReceipts, "Select", "Delete", DeleteView);
}
public virtual int Update(MyCompany.Data.Objects.CoaDetailOpenBalance theCoaDetailOpenBalance, MyCompany.Data.Objects.CoaDetailOpenBalance original_CoaDetailOpenBalance)
{
return ExecuteAction(theCoaDetailOpenBalance, original_CoaDetailOpenBalance, "Edit", "Update", UpdateView);
}
private void Btn_Company_Click(object sender, EventArgs e)
{
Lbl_Company.Text = MyCompany.Find();
Btn_Company.Enabled = false;
}
public List<MyCompany.Data.Objects.CoaDetailOpenBalance> Select(MyCompany.Data.Objects.CoaDetailOpenBalance qbe)
{
return Select(qbe.CoaDetailID, qbe.AccFundID, qbe.AccFundAccFundName, qbe.AccFundCode, qbe.Acccode, qbe.AccName, qbe.AccDesc, qbe.AccTypeID, qbe.AccTypeAccType, qbe.AccDestID, qbe.AccDestAccDest, qbe.AccDestCompanyTypeDescription, qbe.AccBalTypeID, qbe.AccBalTypeAccBalType, qbe.AccCurrency, qbe.AccCurrencyAccCurrencyName, qbe.ConsTranCode, qbe.CoaControlID, qbe.CoaControlAccName, qbe.CoaControlAccBalTypeAccBalType, qbe.CoaControlAccDestAccDest, qbe.CoaControlAccDestCompanyTypeDescription, qbe.CoaControlAccTypeAccType, qbe.CoaControlCompTypeDescription, qbe.CoaSubID, qbe.CoaSubAccName, qbe.CoaSubAccBalTypeAccBalType, qbe.CoaSubAccDestAccDest, qbe.CoaSubAccDestCompanyTypeDescription, qbe.CoaSubAccFundAccFundName, qbe.CoaSubAccTypeAccType, qbe.CoaSubCoaControlAccName, qbe.CoaSubCoaControlAccBalTypeAccBalType, qbe.CoaSubCoaControlAccDestAccDest, qbe.CoaSubCoaControlAccTypeAccType, qbe.CoaSubCoaControlCompTypeDescription, qbe.CoaSubCoaMainAccName, qbe.CoaSubCoaMainAccBalTypeAccBalType, qbe.CoaSubCoaMainAccDestAccDest, qbe.CoaSubCoaMainAccFundAccFundName, qbe.CoaSubCoaMainAccTypeAccType, qbe.CoaSubCoaMainCoaControlAccName, qbe.CoaMainID, qbe.CoaMainAccName, qbe.CoaMainAccBalTypeAccBalType, qbe.CoaMainAccDestAccDest, qbe.CoaMainAccDestCompanyTypeDescription, qbe.CoaMainAccFundAccFundName, qbe.CoaMainAccTypeAccType, qbe.CoaMainCoaControlAccName, qbe.CoaMainCoaControlAccBalTypeAccBalType, qbe.CoaMainCoaControlAccDestAccDest, qbe.CoaMainCoaControlAccTypeAccType, qbe.CoaMainCoaControlCompTypeDescription, qbe.TranCode, qbe.SubsYN, qbe.AccSubTypeID, qbe.AccSubTypeAccSubTypeName, qbe.OpenDate, qbe.OpenDebit, qbe.OpenCredit, qbe.AccCurrencyRate, qbe.Revenue, qbe.VariableCost, qbe.MonthlyExp, qbe.Budget, qbe.Annex, qbe.Dlt, qbe.IsCashNature, qbe.IsBankNature, qbe.AccSubTypeID1, qbe.AccSubTypeID2, qbe.BankName, qbe.BankAccNum, qbe.BranchName, qbe.BankAccType);
}
protected virtual int ExecuteAction(MyCompany.Data.Objects.Prefix thePrefix, MyCompany.Data.Objects.Prefix original_Prefix, string lastCommandName, string commandName, string dataView)
{
ActionArgs args = new ActionArgs();
args.Controller = "Prefix";
args.View = dataView;
args.Values = CreateFieldValues(thePrefix, original_Prefix);
args.LastCommandName = lastCommandName;
args.CommandName = commandName;
ActionResult result = ControllerFactory.CreateDataController().Execute("Prefix", dataView, args);
result.RaiseExceptionIfErrors();
result.AssignTo(thePrefix);
return result.RowsAffected;
}
public virtual int Update(MyCompany.Data.Objects.Prefix thePrefix)
{
return Update(thePrefix, SelectSingle(thePrefix.PrefixID));
}
public List<MyCompany.Data.Objects.Prefix> Select(MyCompany.Data.Objects.Prefix qbe)
{
return Select(qbe.PrefixID, qbe.Prefix_);
}
public virtual int Update(MyCompany.Data.Objects.Company theCompany)
{
return Update(theCompany, SelectSingle(theCompany.CompanyID));
}
public virtual int Update(MyCompany.Data.Objects.CoaDetailOpenBalance theCoaDetailOpenBalance)
{
return Update(theCoaDetailOpenBalance, SelectSingle(theCoaDetailOpenBalance.CoaDetailID));
}
protected virtual FieldValue[] CreateFieldValues(MyCompany.Data.Objects.Company theCompany, MyCompany.Data.Objects.Company original_Company)
{
List<FieldValue> values = new List<FieldValue>();
values.Add(new FieldValue("CompanyID", original_Company.CompanyID, theCompany.CompanyID));
values.Add(new FieldValue("CompanyName", original_Company.CompanyName, theCompany.CompanyName));
values.Add(new FieldValue("Address", original_Company.Address, theCompany.Address));
values.Add(new FieldValue("Phone", original_Company.Phone, theCompany.Phone));
values.Add(new FieldValue("Fax", original_Company.Fax, theCompany.Fax));
values.Add(new FieldValue("Email", original_Company.Email, theCompany.Email));
values.Add(new FieldValue("Logo", original_Company.Logo, theCompany.Logo));
values.Add(new FieldValue("CompanyTypeID", original_Company.CompanyTypeID, theCompany.CompanyTypeID));
values.Add(new FieldValue("CompanyTypeDescription", original_Company.CompanyTypeDescription, theCompany.CompanyTypeDescription, true));
values.Add(new FieldValue("LicenseTO", original_Company.LicenseTO, theCompany.LicenseTO));
values.Add(new FieldValue("CashCode", original_Company.CashCode, theCompany.CashCode));
values.Add(new FieldValue("BankCode", original_Company.BankCode, theCompany.BankCode));
values.Add(new FieldValue("FixedAssetCode", original_Company.FixedAssetCode, theCompany.FixedAssetCode));
values.Add(new FieldValue("Depreciation", original_Company.Depreciation, theCompany.Depreciation));
values.Add(new FieldValue("RawMAcc", original_Company.RawMAcc, theCompany.RawMAcc));
values.Add(new FieldValue("FinishGAcc", original_Company.FinishGAcc, theCompany.FinishGAcc));
values.Add(new FieldValue("Inventory", original_Company.Inventory, theCompany.Inventory));
values.Add(new FieldValue("DepCalYesNo", original_Company.DepCalYesNo, theCompany.DepCalYesNo));
values.Add(new FieldValue("RawmStk", original_Company.RawmStk, theCompany.RawmStk));
values.Add(new FieldValue("FinishStk", original_Company.FinishStk, theCompany.FinishStk));
values.Add(new FieldValue("RCurr", original_Company.RCurr, theCompany.RCurr));
values.Add(new FieldValue("RCurrRate", original_Company.RCurrRate, theCompany.RCurrRate));
values.Add(new FieldValue("FCurr", original_Company.FCurr, theCompany.FCurr));
values.Add(new FieldValue("FCurrRate", original_Company.FCurrRate, theCompany.FCurrRate));
values.Add(new FieldValue("ProfitAcc", original_Company.ProfitAcc, theCompany.ProfitAcc));
values.Add(new FieldValue("DateType", original_Company.DateType, theCompany.DateType));
values.Add(new FieldValue("BaseCurrency", original_Company.BaseCurrency, theCompany.BaseCurrency));
values.Add(new FieldValue("AccountBalShow", original_Company.AccountBalShow, theCompany.AccountBalShow));
values.Add(new FieldValue("FundCode", original_Company.FundCode, theCompany.FundCode));
values.Add(new FieldValue("BranchCode", original_Company.BranchCode, theCompany.BranchCode));
values.Add(new FieldValue("SubLedYN", original_Company.SubLedYN, theCompany.SubLedYN));
values.Add(new FieldValue("AccBalShow", original_Company.AccBalShow, theCompany.AccBalShow));
values.Add(new FieldValue("FundCodeYN", original_Company.FundCodeYN, theCompany.FundCodeYN));
values.Add(new FieldValue("BranchCodeYN", original_Company.BranchCodeYN, theCompany.BranchCodeYN));
values.Add(new FieldValue("FixedAssetYN", original_Company.FixedAssetYN, theCompany.FixedAssetYN));
values.Add(new FieldValue("SalesAcct", original_Company.SalesAcct, theCompany.SalesAcct));
values.Add(new FieldValue("PurchaseAcct", original_Company.PurchaseAcct, theCompany.PurchaseAcct));
values.Add(new FieldValue("InvtoryVchrAuto", original_Company.InvtoryVchrAuto, theCompany.InvtoryVchrAuto));
values.Add(new FieldValue("SDebitor", original_Company.SDebitor, theCompany.SDebitor));
values.Add(new FieldValue("SCreditor", original_Company.SCreditor, theCompany.SCreditor));
values.Add(new FieldValue("ProjectYN", original_Company.ProjectYN, theCompany.ProjectYN));
values.Add(new FieldValue("GodownYN", original_Company.GodownYN, theCompany.GodownYN));
values.Add(new FieldValue("BatchYN", original_Company.BatchYN, theCompany.BatchYN));
values.Add(new FieldValue("MgtYN", original_Company.MgtYN, theCompany.MgtYN));
values.Add(new FieldValue("ExpireYN", original_Company.ExpireYN, theCompany.ExpireYN));
values.Add(new FieldValue("Active", original_Company.Active, theCompany.Active));
values.Add(new FieldValue("License", original_Company.License, theCompany.License));
values.Add(new FieldValue("Instal", original_Company.Instal, theCompany.Instal));
values.Add(new FieldValue("CopYN", original_Company.CopYN, theCompany.CopYN));
values.Add(new FieldValue("VchrNumberUnique", original_Company.VchrNumberUnique, theCompany.VchrNumberUnique));
values.Add(new FieldValue("VchrNumberByType", original_Company.VchrNumberByType, theCompany.VchrNumberByType));
values.Add(new FieldValue("CurrAsset", original_Company.CurrAsset, theCompany.CurrAsset));
values.Add(new FieldValue("CurrLiab", original_Company.CurrLiab, theCompany.CurrLiab));
values.Add(new FieldValue("SaleAcc", original_Company.SaleAcc, theCompany.SaleAcc));
values.Add(new FieldValue("PurAcc", original_Company.PurAcc, theCompany.PurAcc));
values.Add(new FieldValue("FixedAcc", original_Company.FixedAcc, theCompany.FixedAcc));
values.Add(new FieldValue("LoanLiab", original_Company.LoanLiab, theCompany.LoanLiab));
values.Add(new FieldValue("CapAcc", original_Company.CapAcc, theCompany.CapAcc));
values.Add(new FieldValue("OpnStkAcc", original_Company.OpnStkAcc, theCompany.OpnStkAcc));
values.Add(new FieldValue("ClsStkAcc", original_Company.ClsStkAcc, theCompany.ClsStkAcc));
values.Add(new FieldValue("FabricCatID", original_Company.FabricCatID, theCompany.FabricCatID));
values.Add(new FieldValue("FabricItemID", original_Company.FabricItemID, theCompany.FabricItemID));
values.Add(new FieldValue("FuelAcc", original_Company.FuelAcc, theCompany.FuelAcc));
values.Add(new FieldValue("BasOwnerAcc", original_Company.BasOwnerAcc, theCompany.BasOwnerAcc));
values.Add(new FieldValue("HelperAcc", original_Company.HelperAcc, theCompany.HelperAcc));
values.Add(new FieldValue("DriverAcc", original_Company.DriverAcc, theCompany.DriverAcc));
values.Add(new FieldValue("AdvanceAcc", original_Company.AdvanceAcc, theCompany.AdvanceAcc));
values.Add(new FieldValue("TicketSaleAcc", original_Company.TicketSaleAcc, theCompany.TicketSaleAcc));
values.Add(new FieldValue("TicketAcc", original_Company.TicketAcc, theCompany.TicketAcc));
values.Add(new FieldValue("BusRsrvAcc", original_Company.BusRsrvAcc, theCompany.BusRsrvAcc));
values.Add(new FieldValue("CntrDepositAcc", original_Company.CntrDepositAcc, theCompany.CntrDepositAcc));
values.Add(new FieldValue("ConsFundCode", original_Company.ConsFundCode, theCompany.ConsFundCode));
values.Add(new FieldValue("WorkinProgressAcc", original_Company.WorkinProgressAcc, theCompany.WorkinProgressAcc));
return values.ToArray();
}
protected virtual FieldValue[] CreateFieldValues(MyCompany.Data.Objects.CoaDetailOpenBalance theCoaDetailOpenBalance, MyCompany.Data.Objects.CoaDetailOpenBalance original_CoaDetailOpenBalance)
{
List<FieldValue> values = new List<FieldValue>();
values.Add(new FieldValue("CoaDetailID", original_CoaDetailOpenBalance.CoaDetailID, theCoaDetailOpenBalance.CoaDetailID, true));
values.Add(new FieldValue("AccFundID", original_CoaDetailOpenBalance.AccFundID, theCoaDetailOpenBalance.AccFundID));
values.Add(new FieldValue("AccFundAccFundName", original_CoaDetailOpenBalance.AccFundAccFundName, theCoaDetailOpenBalance.AccFundAccFundName, true));
values.Add(new FieldValue("AccFundCode", original_CoaDetailOpenBalance.AccFundCode, theCoaDetailOpenBalance.AccFundCode));
values.Add(new FieldValue("Acccode", original_CoaDetailOpenBalance.Acccode, theCoaDetailOpenBalance.Acccode));
values.Add(new FieldValue("AccName", original_CoaDetailOpenBalance.AccName, theCoaDetailOpenBalance.AccName));
values.Add(new FieldValue("AccDesc", original_CoaDetailOpenBalance.AccDesc, theCoaDetailOpenBalance.AccDesc));
values.Add(new FieldValue("AccTypeID", original_CoaDetailOpenBalance.AccTypeID, theCoaDetailOpenBalance.AccTypeID));
values.Add(new FieldValue("AccTypeAccType", original_CoaDetailOpenBalance.AccTypeAccType, theCoaDetailOpenBalance.AccTypeAccType, true));
values.Add(new FieldValue("AccDestID", original_CoaDetailOpenBalance.AccDestID, theCoaDetailOpenBalance.AccDestID));
values.Add(new FieldValue("AccDestAccDest", original_CoaDetailOpenBalance.AccDestAccDest, theCoaDetailOpenBalance.AccDestAccDest, true));
values.Add(new FieldValue("AccDestCompanyTypeDescription", original_CoaDetailOpenBalance.AccDestCompanyTypeDescription, theCoaDetailOpenBalance.AccDestCompanyTypeDescription, true));
values.Add(new FieldValue("AccBalTypeID", original_CoaDetailOpenBalance.AccBalTypeID, theCoaDetailOpenBalance.AccBalTypeID));
values.Add(new FieldValue("AccBalTypeAccBalType", original_CoaDetailOpenBalance.AccBalTypeAccBalType, theCoaDetailOpenBalance.AccBalTypeAccBalType, true));
values.Add(new FieldValue("AccCurrency", original_CoaDetailOpenBalance.AccCurrency, theCoaDetailOpenBalance.AccCurrency));
values.Add(new FieldValue("AccCurrencyAccCurrencyName", original_CoaDetailOpenBalance.AccCurrencyAccCurrencyName, theCoaDetailOpenBalance.AccCurrencyAccCurrencyName, true));
values.Add(new FieldValue("ConsTranCode", original_CoaDetailOpenBalance.ConsTranCode, theCoaDetailOpenBalance.ConsTranCode));
values.Add(new FieldValue("CoaControlID", original_CoaDetailOpenBalance.CoaControlID, theCoaDetailOpenBalance.CoaControlID));
values.Add(new FieldValue("CoaControlAccName", original_CoaDetailOpenBalance.CoaControlAccName, theCoaDetailOpenBalance.CoaControlAccName, true));
values.Add(new FieldValue("CoaControlAccBalTypeAccBalType", original_CoaDetailOpenBalance.CoaControlAccBalTypeAccBalType, theCoaDetailOpenBalance.CoaControlAccBalTypeAccBalType, true));
values.Add(new FieldValue("CoaControlAccDestAccDest", original_CoaDetailOpenBalance.CoaControlAccDestAccDest, theCoaDetailOpenBalance.CoaControlAccDestAccDest, true));
values.Add(new FieldValue("CoaControlAccDestCompanyTypeDescription", original_CoaDetailOpenBalance.CoaControlAccDestCompanyTypeDescription, theCoaDetailOpenBalance.CoaControlAccDestCompanyTypeDescription, true));
values.Add(new FieldValue("CoaControlAccTypeAccType", original_CoaDetailOpenBalance.CoaControlAccTypeAccType, theCoaDetailOpenBalance.CoaControlAccTypeAccType, true));
values.Add(new FieldValue("CoaControlCompTypeDescription", original_CoaDetailOpenBalance.CoaControlCompTypeDescription, theCoaDetailOpenBalance.CoaControlCompTypeDescription, true));
values.Add(new FieldValue("CoaSubID", original_CoaDetailOpenBalance.CoaSubID, theCoaDetailOpenBalance.CoaSubID));
values.Add(new FieldValue("CoaSubAccName", original_CoaDetailOpenBalance.CoaSubAccName, theCoaDetailOpenBalance.CoaSubAccName, true));
values.Add(new FieldValue("CoaSubAccBalTypeAccBalType", original_CoaDetailOpenBalance.CoaSubAccBalTypeAccBalType, theCoaDetailOpenBalance.CoaSubAccBalTypeAccBalType, true));
values.Add(new FieldValue("CoaSubAccDestAccDest", original_CoaDetailOpenBalance.CoaSubAccDestAccDest, theCoaDetailOpenBalance.CoaSubAccDestAccDest, true));
values.Add(new FieldValue("CoaSubAccDestCompanyTypeDescription", original_CoaDetailOpenBalance.CoaSubAccDestCompanyTypeDescription, theCoaDetailOpenBalance.CoaSubAccDestCompanyTypeDescription, true));
values.Add(new FieldValue("CoaSubAccFundAccFundName", original_CoaDetailOpenBalance.CoaSubAccFundAccFundName, theCoaDetailOpenBalance.CoaSubAccFundAccFundName, true));
values.Add(new FieldValue("CoaSubAccTypeAccType", original_CoaDetailOpenBalance.CoaSubAccTypeAccType, theCoaDetailOpenBalance.CoaSubAccTypeAccType, true));
values.Add(new FieldValue("CoaSubCoaControlAccName", original_CoaDetailOpenBalance.CoaSubCoaControlAccName, theCoaDetailOpenBalance.CoaSubCoaControlAccName, true));
values.Add(new FieldValue("CoaSubCoaControlAccBalTypeAccBalType", original_CoaDetailOpenBalance.CoaSubCoaControlAccBalTypeAccBalType, theCoaDetailOpenBalance.CoaSubCoaControlAccBalTypeAccBalType, true));
values.Add(new FieldValue("CoaSubCoaControlAccDestAccDest", original_CoaDetailOpenBalance.CoaSubCoaControlAccDestAccDest, theCoaDetailOpenBalance.CoaSubCoaControlAccDestAccDest, true));
values.Add(new FieldValue("CoaSubCoaControlAccTypeAccType", original_CoaDetailOpenBalance.CoaSubCoaControlAccTypeAccType, theCoaDetailOpenBalance.CoaSubCoaControlAccTypeAccType, true));
values.Add(new FieldValue("CoaSubCoaControlCompTypeDescription", original_CoaDetailOpenBalance.CoaSubCoaControlCompTypeDescription, theCoaDetailOpenBalance.CoaSubCoaControlCompTypeDescription, true));
values.Add(new FieldValue("CoaSubCoaMainAccName", original_CoaDetailOpenBalance.CoaSubCoaMainAccName, theCoaDetailOpenBalance.CoaSubCoaMainAccName, true));
values.Add(new FieldValue("CoaSubCoaMainAccBalTypeAccBalType", original_CoaDetailOpenBalance.CoaSubCoaMainAccBalTypeAccBalType, theCoaDetailOpenBalance.CoaSubCoaMainAccBalTypeAccBalType, true));
values.Add(new FieldValue("CoaSubCoaMainAccDestAccDest", original_CoaDetailOpenBalance.CoaSubCoaMainAccDestAccDest, theCoaDetailOpenBalance.CoaSubCoaMainAccDestAccDest, true));
values.Add(new FieldValue("CoaSubCoaMainAccFundAccFundName", original_CoaDetailOpenBalance.CoaSubCoaMainAccFundAccFundName, theCoaDetailOpenBalance.CoaSubCoaMainAccFundAccFundName, true));
values.Add(new FieldValue("CoaSubCoaMainAccTypeAccType", original_CoaDetailOpenBalance.CoaSubCoaMainAccTypeAccType, theCoaDetailOpenBalance.CoaSubCoaMainAccTypeAccType, true));
values.Add(new FieldValue("CoaSubCoaMainCoaControlAccName", original_CoaDetailOpenBalance.CoaSubCoaMainCoaControlAccName, theCoaDetailOpenBalance.CoaSubCoaMainCoaControlAccName, true));
values.Add(new FieldValue("CoaMainID", original_CoaDetailOpenBalance.CoaMainID, theCoaDetailOpenBalance.CoaMainID));
values.Add(new FieldValue("CoaMainAccName", original_CoaDetailOpenBalance.CoaMainAccName, theCoaDetailOpenBalance.CoaMainAccName, true));
values.Add(new FieldValue("CoaMainAccBalTypeAccBalType", original_CoaDetailOpenBalance.CoaMainAccBalTypeAccBalType, theCoaDetailOpenBalance.CoaMainAccBalTypeAccBalType, true));
values.Add(new FieldValue("CoaMainAccDestAccDest", original_CoaDetailOpenBalance.CoaMainAccDestAccDest, theCoaDetailOpenBalance.CoaMainAccDestAccDest, true));
values.Add(new FieldValue("CoaMainAccDestCompanyTypeDescription", original_CoaDetailOpenBalance.CoaMainAccDestCompanyTypeDescription, theCoaDetailOpenBalance.CoaMainAccDestCompanyTypeDescription, true));
values.Add(new FieldValue("CoaMainAccFundAccFundName", original_CoaDetailOpenBalance.CoaMainAccFundAccFundName, theCoaDetailOpenBalance.CoaMainAccFundAccFundName, true));
values.Add(new FieldValue("CoaMainAccTypeAccType", original_CoaDetailOpenBalance.CoaMainAccTypeAccType, theCoaDetailOpenBalance.CoaMainAccTypeAccType, true));
values.Add(new FieldValue("CoaMainCoaControlAccName", original_CoaDetailOpenBalance.CoaMainCoaControlAccName, theCoaDetailOpenBalance.CoaMainCoaControlAccName, true));
values.Add(new FieldValue("CoaMainCoaControlAccBalTypeAccBalType", original_CoaDetailOpenBalance.CoaMainCoaControlAccBalTypeAccBalType, theCoaDetailOpenBalance.CoaMainCoaControlAccBalTypeAccBalType, true));
values.Add(new FieldValue("CoaMainCoaControlAccDestAccDest", original_CoaDetailOpenBalance.CoaMainCoaControlAccDestAccDest, theCoaDetailOpenBalance.CoaMainCoaControlAccDestAccDest, true));
values.Add(new FieldValue("CoaMainCoaControlAccTypeAccType", original_CoaDetailOpenBalance.CoaMainCoaControlAccTypeAccType, theCoaDetailOpenBalance.CoaMainCoaControlAccTypeAccType, true));
values.Add(new FieldValue("CoaMainCoaControlCompTypeDescription", original_CoaDetailOpenBalance.CoaMainCoaControlCompTypeDescription, theCoaDetailOpenBalance.CoaMainCoaControlCompTypeDescription, true));
values.Add(new FieldValue("TranCode", original_CoaDetailOpenBalance.TranCode, theCoaDetailOpenBalance.TranCode));
values.Add(new FieldValue("SubsYN", original_CoaDetailOpenBalance.SubsYN, theCoaDetailOpenBalance.SubsYN));
values.Add(new FieldValue("AccSubTypeID", original_CoaDetailOpenBalance.AccSubTypeID, theCoaDetailOpenBalance.AccSubTypeID));
values.Add(new FieldValue("AccSubTypeAccSubTypeName", original_CoaDetailOpenBalance.AccSubTypeAccSubTypeName, theCoaDetailOpenBalance.AccSubTypeAccSubTypeName, true));
values.Add(new FieldValue("OpenDate", original_CoaDetailOpenBalance.OpenDate, theCoaDetailOpenBalance.OpenDate));
values.Add(new FieldValue("OpenDebit", original_CoaDetailOpenBalance.OpenDebit, theCoaDetailOpenBalance.OpenDebit));
values.Add(new FieldValue("OpenCredit", original_CoaDetailOpenBalance.OpenCredit, theCoaDetailOpenBalance.OpenCredit));
values.Add(new FieldValue("AccCurrencyRate", original_CoaDetailOpenBalance.AccCurrencyRate, theCoaDetailOpenBalance.AccCurrencyRate));
values.Add(new FieldValue("Revenue", original_CoaDetailOpenBalance.Revenue, theCoaDetailOpenBalance.Revenue));
values.Add(new FieldValue("VariableCost", original_CoaDetailOpenBalance.VariableCost, theCoaDetailOpenBalance.VariableCost));
values.Add(new FieldValue("MonthlyExp", original_CoaDetailOpenBalance.MonthlyExp, theCoaDetailOpenBalance.MonthlyExp));
values.Add(new FieldValue("Budget", original_CoaDetailOpenBalance.Budget, theCoaDetailOpenBalance.Budget));
values.Add(new FieldValue("Annex", original_CoaDetailOpenBalance.Annex, theCoaDetailOpenBalance.Annex));
values.Add(new FieldValue("Dlt", original_CoaDetailOpenBalance.Dlt, theCoaDetailOpenBalance.Dlt));
values.Add(new FieldValue("IsCashNature", original_CoaDetailOpenBalance.IsCashNature, theCoaDetailOpenBalance.IsCashNature));
values.Add(new FieldValue("IsBankNature", original_CoaDetailOpenBalance.IsBankNature, theCoaDetailOpenBalance.IsBankNature));
values.Add(new FieldValue("AccSubTypeID1", original_CoaDetailOpenBalance.AccSubTypeID1, theCoaDetailOpenBalance.AccSubTypeID1));
values.Add(new FieldValue("AccSubTypeID2", original_CoaDetailOpenBalance.AccSubTypeID2, theCoaDetailOpenBalance.AccSubTypeID2));
values.Add(new FieldValue("BankName", original_CoaDetailOpenBalance.BankName, theCoaDetailOpenBalance.BankName));
values.Add(new FieldValue("BankAccNum", original_CoaDetailOpenBalance.BankAccNum, theCoaDetailOpenBalance.BankAccNum));
values.Add(new FieldValue("BranchName", original_CoaDetailOpenBalance.BranchName, theCoaDetailOpenBalance.BranchName));
values.Add(new FieldValue("BankAccType", original_CoaDetailOpenBalance.BankAccType, theCoaDetailOpenBalance.BankAccType));
values.Add(new FieldValue("AccSubTypeAccSubTypeName1", original_CoaDetailOpenBalance.AccSubTypeAccSubTypeName1, theCoaDetailOpenBalance.AccSubTypeAccSubTypeName1));
values.Add(new FieldValue("AccSubTypeAccSubTypeName2", original_CoaDetailOpenBalance.AccSubTypeAccSubTypeName2, theCoaDetailOpenBalance.AccSubTypeAccSubTypeName2));
return values.ToArray();
}
public static List<MyCompany.Data.Objects.MoneyReceipts> Select(MyCompany.Data.Objects.MoneyReceipts qbe)
{
return new MoneyReceiptsFactory().Select(qbe);
}
public static List<MyCompany.Data.Objects.Company> Select(MyCompany.Data.Objects.Company qbe)
{
return new CompanyFactory().Select(qbe);
}
public virtual int Insert(MyCompany.Data.Objects.MoneyReceipts theMoneyReceipts)
{
return ExecuteAction(theMoneyReceipts, new MoneyReceipts(), "New", "Insert", InsertView);
}
public virtual int Delete(MyCompany.Data.Objects.Company theCompany)
{
return ExecuteAction(theCompany, theCompany, "Select", "Delete", DeleteView);
}
public virtual int Update(MyCompany.Data.Objects.MoneyReceipts theMoneyReceipts, MyCompany.Data.Objects.MoneyReceipts original_MoneyReceipts)
{
return ExecuteAction(theMoneyReceipts, original_MoneyReceipts, "Edit", "Update", UpdateView);
}
public virtual int Update(MyCompany.Data.Objects.MoneyReceipts theMoneyReceipts)
{
return Update(theMoneyReceipts, SelectSingle(theMoneyReceipts.MoneyReceiptsID));
}
protected virtual FieldValue[] CreateFieldValues(MyCompany.Data.Objects.MoneyReceipts theMoneyReceipts, MyCompany.Data.Objects.MoneyReceipts original_MoneyReceipts)
{
List<FieldValue> values = new List<FieldValue>();
values.Add(new FieldValue("MoneyReceiptsID", original_MoneyReceipts.MoneyReceiptsID, theMoneyReceipts.MoneyReceiptsID, true));
values.Add(new FieldValue("MRDate", original_MoneyReceipts.MRDate, theMoneyReceipts.MRDate));
values.Add(new FieldValue("MRNo", original_MoneyReceipts.MRNo, theMoneyReceipts.MRNo));
values.Add(new FieldValue("PlotSaleID", original_MoneyReceipts.PlotSaleID, theMoneyReceipts.PlotSaleID));
values.Add(new FieldValue("PayCatID", original_MoneyReceipts.PayCatID, theMoneyReceipts.PayCatID));
values.Add(new FieldValue("PayCatCategory", original_MoneyReceipts.PayCatCategory, theMoneyReceipts.PayCatCategory, true));
values.Add(new FieldValue("PCode", original_MoneyReceipts.PCode, theMoneyReceipts.PCode));
values.Add(new FieldValue("ReceAmount", original_MoneyReceipts.ReceAmount, theMoneyReceipts.ReceAmount));
values.Add(new FieldValue("ModeofReceiptID", original_MoneyReceipts.ModeofReceiptID, theMoneyReceipts.ModeofReceiptID));
values.Add(new FieldValue("ModeofReceiptDescription", original_MoneyReceipts.ModeofReceiptDescription, theMoneyReceipts.ModeofReceiptDescription, true));
values.Add(new FieldValue("ApplicantId", original_MoneyReceipts.ApplicantId, theMoneyReceipts.ApplicantId));
values.Add(new FieldValue("AccSubNameID", original_MoneyReceipts.AccSubNameID, theMoneyReceipts.AccSubNameID));
values.Add(new FieldValue("AccSubNameAccSubName", original_MoneyReceipts.AccSubNameAccSubName, theMoneyReceipts.AccSubNameAccSubName, true));
values.Add(new FieldValue("AccSubNameAccSubTypeAccSubType", original_MoneyReceipts.AccSubNameAccSubTypeAccSubType, theMoneyReceipts.AccSubNameAccSubTypeAccSubType, true));
values.Add(new FieldValue("Fileno", original_MoneyReceipts.Fileno, theMoneyReceipts.Fileno));
values.Add(new FieldValue("Checkno", original_MoneyReceipts.Checkno, theMoneyReceipts.Checkno));
values.Add(new FieldValue("CheckDate", original_MoneyReceipts.CheckDate, theMoneyReceipts.CheckDate));
values.Add(new FieldValue("CheckPostDate", original_MoneyReceipts.CheckPostDate, theMoneyReceipts.CheckPostDate));
values.Add(new FieldValue("CheckBankName", original_MoneyReceipts.CheckBankName, theMoneyReceipts.CheckBankName));
values.Add(new FieldValue("BankBranch", original_MoneyReceipts.BankBranch, theMoneyReceipts.BankBranch));
values.Add(new FieldValue("Dlt", original_MoneyReceipts.Dlt, theMoneyReceipts.Dlt));
values.Add(new FieldValue("Description", original_MoneyReceipts.Description, theMoneyReceipts.Description));
values.Add(new FieldValue("MultiPayment", original_MoneyReceipts.MultiPayment, theMoneyReceipts.MultiPayment));
values.Add(new FieldValue("CancelMR", original_MoneyReceipts.CancelMR, theMoneyReceipts.CancelMR));
values.Add(new FieldValue("CancelDate", original_MoneyReceipts.CancelDate, theMoneyReceipts.CancelDate));
values.Add(new FieldValue("ReceiptType", original_MoneyReceipts.ReceiptType, theMoneyReceipts.ReceiptType));
values.Add(new FieldValue("GName", original_MoneyReceipts.GName, theMoneyReceipts.GName));
values.Add(new FieldValue("GFathersName", original_MoneyReceipts.GFathersName, theMoneyReceipts.GFathersName));
values.Add(new FieldValue("Gaddress", original_MoneyReceipts.Gaddress, theMoneyReceipts.Gaddress));
values.Add(new FieldValue("vide", original_MoneyReceipts.vide, theMoneyReceipts.vide));
values.Add(new FieldValue("Created_BY", original_MoneyReceipts.Created_BY, theMoneyReceipts.Created_BY));
values.Add(new FieldValue("Created_DT", original_MoneyReceipts.Created_DT, theMoneyReceipts.Created_DT));
values.Add(new FieldValue("Updated_BY", original_MoneyReceipts.Updated_BY, theMoneyReceipts.Updated_BY));
values.Add(new FieldValue("Updated_DT", original_MoneyReceipts.Updated_DT, theMoneyReceipts.Updated_DT));
values.Add(new FieldValue("Remarks", original_MoneyReceipts.Remarks, theMoneyReceipts.Remarks));
values.Add(new FieldValue("DisplayAction", original_MoneyReceipts.DisplayAction, theMoneyReceipts.DisplayAction));
values.Add(new FieldValue("AccFundID", original_MoneyReceipts.AccFundID, theMoneyReceipts.AccFundID));
values.Add(new FieldValue("CoaDetailID", original_MoneyReceipts.CoaDetailID, theMoneyReceipts.CoaDetailID));
values.Add(new FieldValue("CoaDetailAccName", original_MoneyReceipts.CoaDetailAccName, theMoneyReceipts.CoaDetailAccName, true));
values.Add(new FieldValue("CoaDetailAccBalTypeAccBalType", original_MoneyReceipts.CoaDetailAccBalTypeAccBalType, theMoneyReceipts.CoaDetailAccBalTypeAccBalType, true));
values.Add(new FieldValue("CoaDetailAccCurrencyAccCurrencyName", original_MoneyReceipts.CoaDetailAccCurrencyAccCurrencyName, theMoneyReceipts.CoaDetailAccCurrencyAccCurrencyName, true));
values.Add(new FieldValue("CoaDetailAccDestAccDest", original_MoneyReceipts.CoaDetailAccDestAccDest, theMoneyReceipts.CoaDetailAccDestAccDest, true));
values.Add(new FieldValue("CoaDetailAccDestCompanyTypeDescription", original_MoneyReceipts.CoaDetailAccDestCompanyTypeDescription, theMoneyReceipts.CoaDetailAccDestCompanyTypeDescription, true));
values.Add(new FieldValue("CoaDetailAccFundAccFundCode", original_MoneyReceipts.CoaDetailAccFundAccFundCode, theMoneyReceipts.CoaDetailAccFundAccFundCode, true));
values.Add(new FieldValue("CoaDetailAccSubTypeAccSubType", original_MoneyReceipts.CoaDetailAccSubTypeAccSubType, theMoneyReceipts.CoaDetailAccSubTypeAccSubType, true));
values.Add(new FieldValue("CoaDetailAccTypeAccType", original_MoneyReceipts.CoaDetailAccTypeAccType, theMoneyReceipts.CoaDetailAccTypeAccType, true));
values.Add(new FieldValue("CoaDetailCoaControlAccName", original_MoneyReceipts.CoaDetailCoaControlAccName, theMoneyReceipts.CoaDetailCoaControlAccName, true));
values.Add(new FieldValue("CoaDetailCoaControlAccBalTypeAccBalType", original_MoneyReceipts.CoaDetailCoaControlAccBalTypeAccBalType, theMoneyReceipts.CoaDetailCoaControlAccBalTypeAccBalType, true));
values.Add(new FieldValue("CoaDetailCoaControlAccDestAccDest", original_MoneyReceipts.CoaDetailCoaControlAccDestAccDest, theMoneyReceipts.CoaDetailCoaControlAccDestAccDest, true));
values.Add(new FieldValue("CoaDetailCoaControlAccTypeAccType", original_MoneyReceipts.CoaDetailCoaControlAccTypeAccType, theMoneyReceipts.CoaDetailCoaControlAccTypeAccType, true));
values.Add(new FieldValue("CoaDetailCoaControlCompTypeDescription", original_MoneyReceipts.CoaDetailCoaControlCompTypeDescription, theMoneyReceipts.CoaDetailCoaControlCompTypeDescription, true));
values.Add(new FieldValue("CoaDetailCoaMainAccName", original_MoneyReceipts.CoaDetailCoaMainAccName, theMoneyReceipts.CoaDetailCoaMainAccName, true));
values.Add(new FieldValue("CoaDetailCoaMainAccBalTypeAccBalType", original_MoneyReceipts.CoaDetailCoaMainAccBalTypeAccBalType, theMoneyReceipts.CoaDetailCoaMainAccBalTypeAccBalType, true));
values.Add(new FieldValue("CoaDetailCoaMainAccDestAccDest", original_MoneyReceipts.CoaDetailCoaMainAccDestAccDest, theMoneyReceipts.CoaDetailCoaMainAccDestAccDest, true));
values.Add(new FieldValue("CoaDetailCoaMainAccFundAccFundCode", original_MoneyReceipts.CoaDetailCoaMainAccFundAccFundCode, theMoneyReceipts.CoaDetailCoaMainAccFundAccFundCode, true));
values.Add(new FieldValue("CoaDetailCoaMainAccTypeAccType", original_MoneyReceipts.CoaDetailCoaMainAccTypeAccType, theMoneyReceipts.CoaDetailCoaMainAccTypeAccType, true));
values.Add(new FieldValue("CoaDetailCoaMainCoaControlAccName", original_MoneyReceipts.CoaDetailCoaMainCoaControlAccName, theMoneyReceipts.CoaDetailCoaMainCoaControlAccName, true));
values.Add(new FieldValue("CoaDetailCoaSubAccName", original_MoneyReceipts.CoaDetailCoaSubAccName, theMoneyReceipts.CoaDetailCoaSubAccName, true));
values.Add(new FieldValue("CoaDetailCoaSubAccBalTypeAccBalType", original_MoneyReceipts.CoaDetailCoaSubAccBalTypeAccBalType, theMoneyReceipts.CoaDetailCoaSubAccBalTypeAccBalType, true));
values.Add(new FieldValue("CoaDetailCoaSubAccDestAccDest", original_MoneyReceipts.CoaDetailCoaSubAccDestAccDest, theMoneyReceipts.CoaDetailCoaSubAccDestAccDest, true));
values.Add(new FieldValue("CoaDetailCoaSubAccFundAccFundCode", original_MoneyReceipts.CoaDetailCoaSubAccFundAccFundCode, theMoneyReceipts.CoaDetailCoaSubAccFundAccFundCode, true));
values.Add(new FieldValue("CoaDetailCoaSubAccTypeAccType", original_MoneyReceipts.CoaDetailCoaSubAccTypeAccType, theMoneyReceipts.CoaDetailCoaSubAccTypeAccType, true));
values.Add(new FieldValue("CoaDetailCoaSubCoaControlAccName", original_MoneyReceipts.CoaDetailCoaSubCoaControlAccName, theMoneyReceipts.CoaDetailCoaSubCoaControlAccName, true));
values.Add(new FieldValue("CoaDetailCoaSubCoaMainAccName", original_MoneyReceipts.CoaDetailCoaSubCoaMainAccName, theMoneyReceipts.CoaDetailCoaSubCoaMainAccName, true));
values.Add(new FieldValue("AccTranID", original_MoneyReceipts.AccTranID, theMoneyReceipts.AccTranID));
return values.ToArray();
}
public MyCompanyProxyVO()
{
this.MyCompany = new MyCompany();
}
public virtual int Insert(MyCompany.Data.Objects.Prefix thePrefix)
{
return ExecuteAction(thePrefix, new Prefix(), "New", "Insert", InsertView);
}
protected virtual FieldValue[] CreateFieldValues(MyCompany.Data.Objects.AccountsReceivable theAccountsReceivable, MyCompany.Data.Objects.AccountsReceivable original_AccountsReceivable)
{
List<FieldValue> values = new List<FieldValue>();
values.Add(new FieldValue("AccSubCode", original_AccountsReceivable.AccSubCode, theAccountsReceivable.AccSubCode, true));
values.Add(new FieldValue("AccSubTypeID", original_AccountsReceivable.AccSubTypeID, theAccountsReceivable.AccSubTypeID));
values.Add(new FieldValue("AccSubTypeAccSubType", original_AccountsReceivable.AccSubTypeAccSubType, theAccountsReceivable.AccSubTypeAccSubType, true));
values.Add(new FieldValue("AccSubID", original_AccountsReceivable.AccSubID, theAccountsReceivable.AccSubID));
values.Add(new FieldValue("AccSubType", original_AccountsReceivable.AccSubType, theAccountsReceivable.AccSubType));
values.Add(new FieldValue("AccSubName", original_AccountsReceivable.AccSubName, theAccountsReceivable.AccSubName));
values.Add(new FieldValue("Address", original_AccountsReceivable.Address, theAccountsReceivable.Address));
values.Add(new FieldValue("OfficeAdd", original_AccountsReceivable.OfficeAdd, theAccountsReceivable.OfficeAdd));
values.Add(new FieldValue("OffPhone", original_AccountsReceivable.OffPhone, theAccountsReceivable.OffPhone));
values.Add(new FieldValue("HmPhone", original_AccountsReceivable.HmPhone, theAccountsReceivable.HmPhone));
values.Add(new FieldValue("Mobile", original_AccountsReceivable.Mobile, theAccountsReceivable.Mobile));
values.Add(new FieldValue("Fax", original_AccountsReceivable.Fax, theAccountsReceivable.Fax));
values.Add(new FieldValue("Email", original_AccountsReceivable.Email, theAccountsReceivable.Email));
values.Add(new FieldValue("CPerson", original_AccountsReceivable.CPerson, theAccountsReceivable.CPerson));
values.Add(new FieldValue("LicenseNum", original_AccountsReceivable.LicenseNum, theAccountsReceivable.LicenseNum));
values.Add(new FieldValue("LicenseExpDate", original_AccountsReceivable.LicenseExpDate, theAccountsReceivable.LicenseExpDate));
values.Add(new FieldValue("Dlt", original_AccountsReceivable.Dlt, theAccountsReceivable.Dlt));
values.Add(new FieldValue("DesigID", original_AccountsReceivable.DesigID, theAccountsReceivable.DesigID));
values.Add(new FieldValue("DeptID", original_AccountsReceivable.DeptID, theAccountsReceivable.DeptID));
values.Add(new FieldValue("CustType", original_AccountsReceivable.CustType, theAccountsReceivable.CustType));
values.Add(new FieldValue("AccFundID", original_AccountsReceivable.AccFundID, theAccountsReceivable.AccFundID));
return values.ToArray();
}
public virtual int Update(MyCompany.Data.Objects.Prefix thePrefix, MyCompany.Data.Objects.Prefix original_Prefix)
{
return ExecuteAction(thePrefix, original_Prefix, "Edit", "Update", UpdateView);
}
public static List<MyCompany.Data.Objects.CoaDetailOpenBalance> Select(MyCompany.Data.Objects.CoaDetailOpenBalance qbe)
{
return new CoaDetailOpenBalanceFactory().Select(qbe);
}
protected virtual FieldValue[] CreateFieldValues(MyCompany.Data.Objects.Prefix thePrefix, MyCompany.Data.Objects.Prefix original_Prefix)
{
List<FieldValue> values = new List<FieldValue>();
values.Add(new FieldValue("PrefixID", original_Prefix.PrefixID, thePrefix.PrefixID, true));
values.Add(new FieldValue("Prefix", original_Prefix.Prefix_, thePrefix.Prefix_));
return values.ToArray();
}
public virtual int Delete(MyCompany.Data.Objects.CoaDetailOpenBalance theCoaDetailOpenBalance)
{
return ExecuteAction(theCoaDetailOpenBalance, theCoaDetailOpenBalance, "Select", "Delete", DeleteView);
}
public static List<MyCompany.Data.Objects.Prefix> Select(MyCompany.Data.Objects.Prefix qbe)
{
return new PrefixFactory().Select(qbe);
}
public virtual int Insert(MyCompany.Data.Objects.CoaDetailOpenBalance theCoaDetailOpenBalance)
{
return ExecuteAction(theCoaDetailOpenBalance, new CoaDetailOpenBalance(), "New", "Insert", InsertView);
}