public void CalculateSellUnitPrice() { CPromotionProcessor pp = new CPromotionProcessor(null, "", null); MIntervalConfig ivc = new MIntervalConfig(new CTable("")); ivc.DeserializeConfig(PricingDefination); MIntervalConfig ivcm = new MIntervalConfig(ivc.GetDbObject()); ivcm.DeserializeConfig(PricingDefination); MInventoryItem mi = new MInventoryItem(this.GetDbObject()); CBasketItem bi = new CBasketItem(ItemCode, mi, 1); CPrice o = null; if (ivcm.SelectionType == 1) { //step o = pp.getStepPrice(ivcm, bi); } else { //Tier o = pp.getTierPrice(ivcm, bi); } if (o != null) { DefaultSellPrice = o.UnitPrice.ToString(); } }
public virtual void SellBuy(string position, string qty, string tradeType) { try { ExApi.XingApi.UpayaOrder(Item, position, qty, tradeType, CPrice.ToString()); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); } }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of CPrice</returns> internal List <CPrice> PopulateObjectsFromReader(IDataReader dataReader) { List <CPrice> list = new List <CPrice>(); while (dataReader.Read()) { CPrice businessObject = new CPrice(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
/// <summary> /// insert new row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true of successfully insert</returns> public bool Insert(CPrice businessObject) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_price_Insert"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.AddWithValue("p_idprice", businessObject.Idprice); sqlCommand.Parameters["p_idprice"].NpgsqlDbType = NpgsqlDbType.Integer; sqlCommand.Parameters["p_idprice"].Direction = ParameterDirection.InputOutput; sqlCommand.Parameters.AddWithValue("p_cod_price", businessObject.Cod_price); sqlCommand.Parameters["p_cod_price"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_dispatch_person", businessObject.Dispatch_person); sqlCommand.Parameters["p_dispatch_person"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_dispatch_mail", businessObject.Dispatch_mail); sqlCommand.Parameters["p_dispatch_mail"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_dispatch_curier", businessObject.Dispatch_curier); sqlCommand.Parameters["p_dispatch_curier"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_dispatch_transport", businessObject.Dispatch_transport); sqlCommand.Parameters["p_dispatch_transport"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_dispatch_fax", businessObject.Dispatch_fax); sqlCommand.Parameters["p_dispatch_fax"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_dispatch_otro", businessObject.Dispatch_otro); sqlCommand.Parameters["p_dispatch_otro"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_request_reference", businessObject.Request_reference); sqlCommand.Parameters["p_request_reference"].NpgsqlDbType = NpgsqlDbType.Integer; MainConnection.Open(); sqlCommand.ExecuteNonQuery(); businessObject.Idprice = Convert.ToInt32(sqlCommand.Parameters["p_idprice"].Value); return(true); } catch (Exception ex) { throw new Exception("CPrice::Insert::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
//计算单价 public double CalcPrice(CProduct product, COrderDetail od) { double dblPrice = 0; //如果是促销,取促销价 bool bHasPrice = false; if (Global.GetStore().PromotionMgr.FindByProduct(product.Id) != null) { List <CBaseObject> lstPrice = product.PriceMgr.FindByType(PriceType.Promotion); if (lstPrice.Count > 0) { dblPrice = ((CPrice)lstPrice[0]).Price; bHasPrice = true; } } if (!bHasPrice) { //如果数量符合批发,则取批发价 List <CBaseObject> lstPrice = product.PriceMgr.FindByType(PriceType.Wholesale); if (lstPrice.Count > 0) { for (int i = lstPrice.Count - 1; i >= 0; i--) { CPrice price = (CPrice)lstPrice[i]; if (price.MinOrderNum <= od.Num) { dblPrice = price.Price; bHasPrice = true; break; } } } //如果没有符合,则取零售价 if (!bHasPrice) { List <CBaseObject> lstPrice2 = product.PriceMgr.FindByType(PriceType.Retail); if (lstPrice2.Count > 0) { CPrice price = (CPrice)lstPrice2[0]; dblPrice = price.Price; bHasPrice = true; } } } return(dblPrice); }
public FormPrice(CPrice_version pPrice_version, LoadData pLoadData) { InitializeComponent(); Init(); oPrice_version = pPrice_version; loadData = pLoadData; if (pPrice_version != null) { oPrice = new CPriceFactory().GetByPrimaryKey(new CPriceKeys(Convert.ToInt32(oPrice_version.Idprice))); } Recuperar_Registro(); ShowStatusControl(); }
protected override void Limpiar_Campos() { oPrice = null; oPrice_version = null; LstPrice_version_detail = null; totalAmount = 0; cbTypeSample.EditValue = null; cbCompany.EditValue = null; deDateCreation.DateTime = Comun.GetDate(); tbNumDaysValid.Value = new CSettings().GetNumDaysPriceDefault(); tbClientDomicile.Text = ""; tbClientPhone.Text = ""; tbClientRuc.Text = ""; tabHead.Text = "Datos"; tbCodPrice.Text = ""; tbNumVersion.Text = ""; ckDispatchCurier.Checked = false; ckDispatchFax.Checked = false; ckDispatchPerson.Checked = false; ckDispatchTransport.Checked = false; ckSaveHistoryEnd.Checked = false; ckSaveHistoryIni.Checked = false; tbObservation.Text = ""; tbSubTotalAmount.Value = 0; tbTotalAmount.Value = 0; tbTotalIgv.Value = 0; gcPrice.DataSource = new BindingList <PriceMethod>(new ModPrice().GetPriceMethod(null)); gcContact.DataSource = null; richTextIni.RichTextBox.Clear(); richTextEnd.RichTextBox.Clear(); gcAnexos.DataSource = new BindingList <Anexos>(new ModPrice().GetLstAnexos(null)); previewControl1.Clear(); loadData = LoadData.Nothing; ShowStatusControl(); }
/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(CPrice businessObject, IDataReader dataReader) { businessObject.Idprice = dataReader.GetInt32(dataReader.GetOrdinal(CPrice.CPriceFields.Idprice.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice.CPriceFields.Cod_price.ToString()))) { businessObject.Cod_price = dataReader.GetString(dataReader.GetOrdinal(CPrice.CPriceFields.Cod_price.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice.CPriceFields.Dispatch_person.ToString()))) { businessObject.Dispatch_person = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CPrice.CPriceFields.Dispatch_person.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice.CPriceFields.Dispatch_mail.ToString()))) { businessObject.Dispatch_mail = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CPrice.CPriceFields.Dispatch_mail.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice.CPriceFields.Dispatch_curier.ToString()))) { businessObject.Dispatch_curier = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CPrice.CPriceFields.Dispatch_curier.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice.CPriceFields.Dispatch_transport.ToString()))) { businessObject.Dispatch_transport = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CPrice.CPriceFields.Dispatch_transport.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice.CPriceFields.Dispatch_fax.ToString()))) { businessObject.Dispatch_fax = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CPrice.CPriceFields.Dispatch_fax.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice.CPriceFields.Dispatch_otro.ToString()))) { businessObject.Dispatch_otro = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CPrice.CPriceFields.Dispatch_otro.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice.CPriceFields.Request_reference.ToString()))) { businessObject.Request_reference = dataReader.GetInt32(dataReader.GetOrdinal(CPrice.CPriceFields.Request_reference.ToString())); } }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>CPrice business object</returns> public CPrice SelectByPrimaryKey(CPriceKeys keys) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_price_SelectByPrimaryKey"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new NpgsqlParameter("p_idprice", NpgsqlDbType.Integer, 4, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idprice)); MainConnection.Open(); NpgsqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { CPrice businessObject = new CPrice(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch (Exception ex) { throw new Exception("CPrice::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public void Save(CPrice price, CPrice_version price_version) { foreach (CItemCopy item in this) { //copiar item if (ComunForm.CopyAndSaveFile(item.Source_file, item.Destiny_directory, item.Filename)) { CPrice_attach price_attach = new CPrice_attach(); price_attach.Idprice = price_version.Idprice; price_attach.Idprice_version = price_version.Idprice_version; price_attach.Name_document = item.Filename; //guardar adjunto if (!new CPrice_attachFactory().Update(price_attach)) { new CPrice_attachFactory().Insert(price_attach); } } } }
public virtual void ForceSell() { try { if (!IsBuyed) { return; } string type = "청산"; string position = Position == "1" ? "2" : "1"; ExApi.XingApi.Order(type, ItemCode, position, Quantity.ToString(), CPrice.ToString(), BuyPrice.ToString()); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); } finally { } }
private void ucToolButtons_onFind() { // --- FormMasterSearch fmBusqueda = new FormMasterSearch(); UcFilterPrice filter = new UcFilterPrice(); filter.onSearch += delegate(ModMasterSearch.KeyFilterPrice key) { fmBusqueda.BindGrid(new ModMasterSearch().GetPrices(key)); }; fmBusqueda.BindGrid(filter, filter.Size, new ModMasterSearch().GetPrices(filter.keyDefault)); fmBusqueda.ShowDialog(); Dictionary <string, string> keys = fmBusqueda.getKeyValues(); if (keys != null) { Limpiar_Campos(); loadData = LoadData.MasterSearchPrice; /// recuperar cotización seleccionada oPrice_version = new CPrice_versionFactory() .GetByPrimaryKey(new CPrice_versionKeys(Convert.ToInt32(keys["Idprice_version"]))); oPrice = new CPriceFactory() .GetByPrimaryKey(new CPriceKeys(Convert.ToInt32(oPrice_version.Idprice))); Recuperar_Registro(); ShowStatusControl(); } }
public virtual void SellBuy(string type, string position) { try { if (type == "진입") { ExApi.XingApi.Order(type, ItemCode, position, Quantity.ToString(), CPrice.ToString()); } else if (type == "청산") { ExApi.XingApi.Order(type, ItemCode, position, Quantity.ToString(), CPrice.ToString(), BuyPrice.ToString()); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); } finally { InitHighLowPrice(); } }
protected override bool Grabar_Registro() { // --- save company bool result_company = false; CCompany oCompany = new CCompany(); if (cbCompany.EditValue != null) { CCorr_modulesFactory faCorr_modules = new CCorr_modulesFactory(); CCompanyFactory faCompany = new CCompanyFactory(); oCompany.Idcompany = Convert.ToInt16(cbCompany.EditValue); //oCompany.Cod_company = faCorr_modules.GetCorrModule(Comun.Formulario.fmEmpresa.ToString()); oCompany.Ruc = tbClientRuc.Text; oCompany.Business_name = cbCompany.Text; oCompany.Domicile = tbClientDomicile.Text; oCompany.Type_company = 'C'; // --- client oCompany.Phone_client = tbClientPhone.Text; if (!(result_company = faCompany.Update(oCompany))) { result_company = faCompany.Insert(oCompany); } } bool result_price = false; if (oPrice == null) { oPrice = new CPrice(); } CPriceFactory faPrice = new CPriceFactory(); if (!(loadData == LoadData.FromPrice_ToNewVersion)) { oPrice.Cod_price = new ModCorrelatives().GetCorrelative(Comun.Correlative.Price); } // --- person if (ckDispatchPerson.Checked) { oPrice.Dispatch_person = 1; } else { oPrice.Dispatch_person = 0; } // --- curier if (ckDispatchCurier.Checked) { oPrice.Dispatch_curier = 1; } else { oPrice.Dispatch_curier = 0; } // --- transport if (ckDispatchTransport.Checked) { oPrice.Dispatch_transport = 1; } else { oPrice.Dispatch_transport = 0; } // --- fax if (ckDispatchFax.Checked) { oPrice.Dispatch_fax = 1; } else { oPrice.Dispatch_fax = 0; } if (!(result_price = faPrice.Update(oPrice))) { result_price = faPrice.Insert(oPrice); } // --- save contacts CPerson oContact = new CPerson(); CPersonFactory faPerson = new CPersonFactory(); CPrice_company_person oPrice_company_person = new CPrice_company_person(); CPrice_company_personFactory faPrice_company_person = new CPrice_company_personFactory(); // --- delete all if (result_price) { oPrice_version = new CPrice_version(); CPrice_versionFactory faPrice_version = new CPrice_versionFactory(); oPrice_version.Idprice = oPrice.Idprice; oPrice_version.Idcompany = null; if (cbCompany.EditValue != null) { oPrice_version.Idcompany = Convert.ToInt16(cbCompany.EditValue); } oPrice_version.Cod_type_sample = cbTypeSample.EditValue.ToString(); oPrice_version.Num_version = new ModPrice().GetNextNumVersion(oPrice.Idprice); oPrice_version.Date_creation = deDateCreation.DateTime; oPrice_version.Num_days_valid = Convert.ToInt16(tbNumDaysValid.Value); oPrice_version.Observation = tbObservation.Text; oPrice_version.Iduser = Comun.User_system.Iduser; oPrice_version.Status_price = 1; bool result_price_version = false; if (!(result_price_version = faPrice_version.Update(oPrice_version))) { result_price_version = faPrice_version.Insert(oPrice_version); } if (result_price_version) { //guardar párrafos iniciales CMemo_price oMemoPrice; CMemo_priceFactory faMemo_price = new CMemo_priceFactory(); //guardando el parrafo inicial oMemoPrice = new CMemo_price(); oMemoPrice.Idprice_version = oPrice_version.Idprice_version; oMemoPrice.Paragraph = richTextIni.RichTextBox.Rtf; oMemoPrice.Memo_type = 1; faMemo_price.Insert(oMemoPrice); //guardando el parrafo final oMemoPrice = new CMemo_price(); oMemoPrice.Idprice_version = oPrice_version.Idprice_version; oMemoPrice.Paragraph = richTextEnd.RichTextBox.Rtf; oMemoPrice.Memo_type = 2; faMemo_price.Insert(oMemoPrice); if (ckSaveHistoryIni.Checked) { CMemo_template oMemo_template = new CMemo_template(); CMemo_templateFactory faMemo_template = new CMemo_templateFactory(); oMemo_template.Paragraph = richTextIni.RichTextBox.Text; oMemo_template.Paragraph_rtf = richTextIni.RichTextBox.Rtf.ToString(); oMemo_template.Memo_type = 1; faMemo_template.Insert(oMemo_template); } //guardar párrafos finales if (ckSaveHistoryEnd.Checked) { CMemo_template oMemo_template = new CMemo_template(); CMemo_templateFactory faMemo_template = new CMemo_templateFactory(); oMemo_template.Paragraph_rtf = richTextEnd.RichTextBox.Rtf; oMemo_template.Paragraph = richTextEnd.RichTextBox.Text.ToString(); oMemo_template.Memo_type = 2; faMemo_template.Insert(oMemo_template); } } if (result_price) { CCompany_person oCompany_person = new CCompany_person(); CCompany_personFactory faCompany_person = new CCompany_personFactory(); for (int i = 0; i < gvContact.RowCount; i++) { oContact.Idperson = Convert.ToInt16(gvContact.GetRowCellValue(i, gcCon_Idperson)); oContact.Phone = gvContact.GetRowCellValue(i, gcCon_Phone).ToString(); oContact.Cellphone = gvContact.GetRowCellValue(i, gcCon_Cellphone).ToString(); oContact.Mail = gvContact.GetRowCellValue(i, gcCon_Mail).ToString(); oContact.Allname = gvContact.GetRowCellValue(i, gcCon_Allname).ToString(); bool result_contact = false; if (!(result_contact = faPerson.Update(oContact))) { result_contact = faPerson.Insert(oContact); } if (result_contact) { oPrice_company_person = new CPrice_company_person(); oPrice_company_person.Idprice_company_person = 0; oPrice_company_person.Idcompany = oCompany.Idcompany; oPrice_company_person.Idprice = oPrice.Idprice; oPrice_company_person.Idperson = oContact.Idperson; oPrice_company_person.Idprice_version = oPrice_version.Idprice_version; oPrice_company_person.Person_type = Convert.ToInt16(gvContact.GetRowCellValue(i, gcCon_Person_type)); if (!faPrice_company_person.Update(oPrice_company_person)) { faPrice_company_person.Insert(oPrice_company_person); } } // --- save history company person if (!faCompany_person.GetAll().Exists(c => c.Idcompany == oCompany.Idcompany && c.Idperson == oContact.Idperson)) { oCompany_person = new CCompany_person(); oCompany_person.Idcompany = oCompany.Idcompany; oCompany_person.Idperson = oContact.Idperson; if (!faCompany_person.Update(oCompany_person)) { faCompany_person.Insert(oCompany_person); } } } } if (result_price_version) { // guardar detalle CPrice_version_detail oPrice_version_detail = new CPrice_version_detail(); CPrice_version_detailFactory faPrice_version_detail = new CPrice_version_detailFactory(); for (int i = 0; i < gvPrice.RowCount; i++) { oPrice_version_detail = new CPrice_version_detail(); oPrice_version_detail.Idprice_version = oPrice_version.Idprice_version; oPrice_version_detail.Idtemplate_method = Convert.ToInt32(gvPrice.GetRowCellValue(i, gcolItem_Idtemplate_method)); oPrice_version_detail.Num_item = Convert.ToInt32(gvPrice.GetRowCellValue(i, gcolItem_Num_item)); oPrice_version_detail.Amount_item = Convert.ToInt32(gvPrice.GetRowCellValue(i, gcolItem_Amount_item)); oPrice_version_detail.Sale_price = Convert.ToDecimal(gvPrice.GetRowCellValue(i, gcolItem_Sale_price)); oPrice_version_detail.Unit_price = Convert.ToDecimal(gvPrice.GetRowCellValue(i, gcolItem_Unit_price)); if (!faPrice_version_detail.Update(oPrice_version_detail)) { faPrice_version_detail.Insert(oPrice_version_detail); } } } if (result_price_version) { if (gvAnexos.RowCount > 0) { // guardar adjuntos ListCopy lstCopySave = new ListCopy(); List <Anexos> lstAnexos = (gcAnexos.DataSource as BindingList <Anexos>).ToList(); if (lstAnexos != null && lstAnexos.Count > 0) { foreach (Anexos item in lstAnexos) { if (item.Source_filename.Trim().Length > 0) { string destiny_directory = oSettings.GetPathAttachPrice(); lstCopySave.Add( new CItemCopy() { Filename = item.Filename, Source_file = item.Source_filename, Destiny_directory = destiny_directory }); } } lstCopySave.Save(oPrice, oPrice_version); } } } } return(true); }
protected override void Limpiar_Campos() { txIdrecep_sample.Text = ""; IDCompany = 0; cbCompany.EditValue = null; tbClientRuc.Text = ""; tbClientDomicile.Text = ""; tbClientPhone.Text = ""; ckDispatchPerson.Checked = false; ckDispatchCurier.Checked = false; ckDispatchTransport.Checked = false; ckDispatchFax.Checked = false; tbSubTotalAmount.Text = ""; tbTotalIgv.Text = ""; tbTotalAmount.Text = ""; totalAmount = 0; tbAmortization.Text = ""; tbResidue.Text = ""; deReception.DateTime = DateTime.Now; deHourReception.EditValue = DateTime.Now; deResult.Text = ""; deHourResult.Text = ""; tbCod_recep_sample.Text = ""; deHourResult.Time = DateTime.Now; tbNumDays.Value = 0; deResult.EditValue = null; deHourResult.EditValue = null; tpRightReports.PageVisible = false; tpRightAttach.PageVisible = false; tpRightProgram.PageVisible = false; lstItemsSelAttach.Clear(); lstItemsSelReport.Clear(); lstItemsSelProgram.Clear(); InitDatatable(); InitDataControls(); gcContact.DataSource = null; gcReport.DataSource = null; gcAttachFile.DataSource = null; gcProgram.DataSource = null; ClearElemColumns(); ucSignReception.Clear(); oRecep_sample = null; oPrice = null; oPrice_version = null; }