public FormStorageStockDetails() { InitializeComponent(); // 默认查询得本月第一天开始到本月最后一天的数据 DateTime nowDate = DateTime.Now; DateTime currentMonthFirstDay = new DateTime(nowDate.Year, nowDate.Month, 1); DateTime currentMonthLastDay = currentMonthFirstDay.AddMonths(1).AddDays(-1); m_countStartDate = currentMonthFirstDay.ToString("yyyyMMdd"); m_countEndDate = currentMonthLastDay.ToString("yyyyMMdd"); m_materielList = Materiel.getInctance().getAllMaterielInfo(); if (m_materielList.Count > 0) { m_currentRecordIndex = 0; } // 判断下是否有查看单价的权限 SortedDictionary <int, ActionTable> list = MainProgram.model.Action.getInctance().getActionInfoFromModuleID(m_moduleID); foreach (KeyValuePair <int, ActionTable> index in list) { if (index.Value.uiActionName == "dispaly") { m_isDisplayJG = AccessAuthorization.getInctance().isAccessAuthorization(index.Value.pkey, Convert.ToString(DbPublic.getInctance().getCurrentLoginUserID())); } } }
public Boolean Ajout(Materiel m) { try { string reference = m.getReference(); string des = m.getDescription(); string prix = m.getPrix(); string quantite = m.getQuantite(); string lien = m.getLien(); Fabricant fab = m.getFabricant(); Cassier c = m.getCassier(); string req = string.Format("insert into Materiel values ('" + reference + "','" + des + "','" + prix + "','" + quantite + "','" + lien + "','" + fab.getNom() + "','" + c.getNom() + "')"); cmd.Connection = cn; cn.Open(); cmd.CommandText = req; cmd.ExecuteNonQuery(); return(true); } catch (SqlException ex) { Console.WriteLine("error :" + ex.Message); return(false); } finally { cn.Close(); } }
//***************************************************************************************************************** // pour chaque materiel il faut : // faire un split du string csv représentant le materiel // peupler une entité materiel et l'inscrire en BDD private void peuplerTableMateriel() { Materiel materiel = new Materiel(); // Création d'un objet matériel qu'il faudra persister // Lire chaque ligne du fichier de peuplement de la table matériel // Chaque élément du tableau "tabLines" représente une ligne du fichier String[] tabLines = System.IO.File.ReadAllLines(@"..\..\..\DonneesInitialesBdd\Materiels.csv", Encoding.GetEncoding("iso-8859-1")); using (MaterielManager materielManager = new MaterielManager()) // appel automatique de la methode dispose qui ferme la connexion { foreach (String line in tabLines) // pour toutes les lignes du jeux d'essais { String[] str = line.Split(';'); // on a choisi ; comme séparateur csv if (str[0] != "#") // si oui c'est une ligne de commentaire { materiel.TypeMateriel = str[0]; materiel.NumeroSerie = str[1]; materiel.NumeroTel = str[2]; materiel.Imei = str[3]; materiel.IdGoogle = str[4]; materiel.FkLoginE = str[5]; materiel.EtatMateriel = str[6]; // On persiste l'entité en BDD materielManager.insertUpdateMateriel(ref materiel); } } } }
public DataView getDS(string TypeName) { if (TypeName == "Measure") { Hownet.BLL.Measure bllM = new Measure(); return(bllM.GetAllList().Tables[0].DefaultView); } else if (TypeName == "Company") { Hownet.BLL.Company bllC = new Company(); return(bllC.GetList("TypeID=1").Tables[0].DefaultView); } else if (TypeName == "Materiel") { Hownet.BLL.Materiel bllMat = new Materiel(); return(bllMat.GetList("AttributeID=1").Tables[0].DefaultView); } else if (TypeName == "VerifyMan") { Hownet.BLL.Users bllU = new Users(); return(bllU.GetAllList().Tables[0].DefaultView); } else if (TypeName == "ProductsType") { Hownet.BLL.MaterielType bllMT = new MaterielType(); return(bllMT.GetList("AttributeID=1").Tables[0].DefaultView); } else { DataView dv = new DataView(); return(dv); } }
public Boolean AjouterP(Materiel m) { try { string reference = m.getReference(); string des = m.getDescription(); string prix = m.getPrix(); string quantite = m.getQuantite(); string lien = m.getLien(); Fabricant fab = m.getFabricant(); Cassier c = m.getCassier(); cn.Open(); cmd.Connection = cn; cmd.CommandText = "insert into Materiel values (@reference,@des,@prix,@quantite,@lien,@fab,@casier)"; cmd.Parameters.Add(new SqlParameter("@reference", reference)); cmd.Parameters.Add(new SqlParameter("@des", des)); cmd.Parameters.Add(new SqlParameter("@prix", prix)); cmd.Parameters.Add(new SqlParameter("@quantite", quantite)); cmd.Parameters.Add(new SqlParameter("@lien", lien)); cmd.Parameters.Add(new SqlParameter("@fab", fab.getNom())); cmd.Parameters.Add(new SqlParameter("@casier", c.getNom())); cmd.ExecuteNonQuery(); return(true); } catch (SqlException ex) { Console.WriteLine("error :" + ex); return(false); } finally { cn.Close(); } }
public ActionControllerResult ChangeOrdreMateriel(int Id, int newOrdre, string userId = null) { ActionControllerResult result; try { Materiel unMateriel = this.materielRepository.GetByID(Id); if (unMateriel == null) { return(ActionControllerResult.FAILURE); } unMateriel.DateModification = DateTime.Now; unMateriel.Rank = newOrdre; this.materielRepository.Update(unMateriel); this.unitOfWork.Save(); result = ActionControllerResult.SUCCESS; } catch (Exception ex) { this.logService.LogErreur(LOG_TYPE_OBJECT.Materiel, null, "Erreur Lors de la modification de l'ordre d'un matériel", ex.Message, userId); result = ActionControllerResult.FAILURE; } return(result); }
private void buttonNoForbid_Click(object sender, EventArgs e) { for (int i = 0; i < this.listViewNoForbidList.Items.Count; i++) { if (this.listViewNoForbidList.Items[i].Checked) { int pkey = Convert.ToInt32(listViewNoForbidList.Items[i].SubItems[1].Text.ToString()); if (m_forbidDataType == ForbidDataType.Supplier) { Supplier.getInctance().noForbidSupplier(pkey); } else if (m_forbidDataType == ForbidDataType.Customer) { Customer.getInctance().noForbidCustomer(pkey); } else if (m_forbidDataType == ForbidDataType.Materiel) { Materiel.getInctance().noForbidMateriel(pkey); } else if (m_forbidDataType == ForbidDataType.Staff) { Staff.getInctance().noForbidStaff(pkey); } else { // 咱不支持的数据类型 } this.listViewNoForbidList.Items[i].Remove(); i--; } } }
private void btAjout_Click(object sender, EventArgs e) { try { if ((txtRef.Text.Equals("") || (txtDesc.Text.Equals("")) || (txtPrix.Text.Equals("") || (txtQuantite.Equals("")) || (txtLien.Text.Equals("") || listFab.SelectedItem.ToString() == null)))) { MessageBox.Show("Il y a au mois un champ vide ", "Message d'erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (materielDA.refExist(materielDA.getAllMateriel(), txtRef.Text)) { MessageBox.Show("Ce matériel est déjà Existe", "Message d'erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { Materiel m = new Materiel(txtRef.Text, txtDesc.Text, txtPrix.Text, txtQuantite.Text, txtLien.Text, new Fabricant(listFab.SelectedItem.ToString()), new Cassier(getCasier())); Boolean test = materielDA.AjouterP(m); if (test == true) { MessageBox.Show("L'ajout de matériel est effectué avec succes", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Vérifiez les valeurs", "Message d'erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } catch (NullReferenceException ex) { MessageBox.Show("Il faut choisir un Fabricant", "Message d'erreur :" + ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void FormInitMaterielEdit_Load(object sender, EventArgs e) { if (m_isEditMaterielData) { this.buttonEdit.Enabled = true; this.buttonSelect.Enabled = false; this.textBoxPrice.Enabled = false; this.textBoxValue.Enabled = false; this.buttonEnter.Enabled = false; MaterielTable materiel = Materiel.getInctance().getMaterielInfoFromPkey(m_materielPkey); this.textBoxName.Text = Convert.ToString(materiel.pkey) + "-" + materiel.name; m_materielName = materiel.name; if (InitMateriel.getInctance().checkMaterielIsExist(m_materielPkey)) { InitMaterielTable materielStock = InitMateriel.getInctance().getMaterielInfoFromMaterielID(m_materielPkey); this.textBoxValue.Text = Convert.ToString(materielStock.value); this.textBoxPrice.Text = Convert.ToString(materielStock.price); } else { this.textBoxValue.Text = "0"; this.textBoxPrice.Text = "0"; } } }
private void buttonSelect_Click(object sender, EventArgs e) { if (m_selectedTextboxIndex <= 0 || m_selectedTextboxIndex > 3) { MessageBoxExtend.messageWarning("请将光标移动到指定输入框中后再重新选择物料"); this.buttonSelect.Enabled = false; return; } FormBaseMateriel fbs = new FormBaseMateriel(true); fbs.ShowDialog(); m_materielPkey = fbs.getSelectRecordPkey(); if (m_materielPkey != 0) { if (m_selectedTextboxIndex == 1) { this.textBoxStartID.Text = Convert.ToString(m_materielPkey); } else if (m_selectedTextboxIndex == 2) { this.textBoxEndID.Text = Convert.ToString(m_materielPkey); } else { MaterielTable materiel = Materiel.getInctance().getMaterielInfoFromPkey(m_materielPkey); this.textBoxName.Text = materiel.name; } } this.buttonSelect.Enabled = false; m_selectedTextboxIndex = 0; }
private void btAjout_Click(object sender, EventArgs e) { try { if (materielDA.refExist(materielDA.getAllMateriel(), txtRef.Text)) { MessageBox.Show("Ce réféerence est déjà existe", "Message d'erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { Materiel m = new Materiel(txtRef.Text, txtDesc.Text, txtPrix.Text, txtQuantite.Text, txtLien.Text, new Fabricant(listFab.SelectedItem.ToString()), new Cassier(listNomCasier.SelectedItem.ToString())); Boolean test = materielDA.AjouterP(m); if (test == true) { MessageBox.Show("L'ajout de matériel est effectué avec succes", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Echec", "Message d'erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } catch (NullReferenceException ex) { MessageBox.Show("Les choix de fabricant ou casier sont nulle", "Message d'erreur :" + ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public IHttpActionResult PutMateriel(int id, Materiel materiel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != materiel.MaterielId) { return(BadRequest()); } db.Entry(materiel).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!MaterielExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
//*********************************************************************************************** private void dgvTechnicien_CellClick(object sender, DataGridViewCellEventArgs e) { int IdxLigneActuelle = e.RowIndex; Materiel materiel = new Materiel(); viderChamps(); if (IdxLigneActuelle >= 0) { // On récupère le login du technicien de la ligne sélectionnée dans le dgvTechnicien string loginTechnicien = (string)dgvTechnicien.Rows[IdxLigneActuelle].Cells[2].Value; // On récupère l'indice de ce technicien dans la listTechnicien int indiceDansListTechnicien = listTechnicien.FindIndex(item => item.LoginT == loginTechnicien); // On récupère le technicien complet technicienSelectionne = listTechnicien[indiceDansListTechnicien]; // On affiche les données du Technicien textBoxNom.Text = technicienSelectionne.Nom; textBoxPrenom.Text = technicienSelectionne.Prenom; // recherche du matériel affecté au technicien pour récupérer son numéro de téléphone int indiceDansListMateriel = listMateriel.FindIndex(materielRecherché => materielRecherché.IdMateriel == technicienSelectionne.FkIdMateriel); if (indiceDansListMateriel >= 0) // matériel trouvé si >=0 { materiel = listMateriel[indiceDansListMateriel]; mTxtBoxNumtel.Text = materiel.NumeroTel; } else { mTxtBoxNumtel.ResetText(); MessageBox.Show("Ce technicien n'a pas de matériel affecté, rentrer manuellement un numéro"); } } }
public ActionResult GetFormDetail(int materielId) { Materiel unMateriel = this.materielService.GetMaterielById(materielId); TicketIncident unTicket = unMateriel.Tickets.Where(w => w.Statut != TICKET_INCIDENT_STATUT.Resolu).OrderByDescending(f => f.DateCreation).FirstOrDefault(); return(PartialView("_FormDetailTicket", unTicket)); }
private void updateStatusLable(int ID) { MaterielTable record = Materiel.getInctance().getMaterielInfoFromPkey(ID); string countInfoToStatusLable = "当前数据过滤条件: "; string materielName = "物料名称:" + record.name; string startDate = " 开始日期: "; string endDate = " 结束日期: "; string isReview = " 是否审核: "; startDate += m_countStartDate.Substring(0, 4) + "年"; startDate += m_countStartDate.Substring(4, 2) + "月"; startDate += m_countStartDate.Substring(6) + "日"; endDate += m_countEndDate.Substring(0, 4) + "年"; endDate += m_countEndDate.Substring(4, 2) + "月"; endDate += m_countEndDate.Substring(6) + "日"; isReview += "已审核单据"; countInfoToStatusLable += materielName; countInfoToStatusLable += startDate; countInfoToStatusLable += endDate; countInfoToStatusLable += isReview; this.toolStripStatusLabelCountInfo.Text = countInfoToStatusLable; }
private bool modifyMateriel() { MaterielTable materiel = getPageMaterielActiveData(); if (materiel.name.Length == 0) { MessageBoxExtend.messageWarning("物料信息保存失败, 物料名称不能为空,请重新输入"); return(false); } if (materiel.num.Length == 0) { MessageBoxExtend.messageWarning("物料信息保存失败, 物料编号不能为空,请重新输入"); return(false); } if (materiel.mnemonicCode.Length > 10) { MessageBoxExtend.messageWarning("物料信息保存失败, 助记码长度应小于10,请重新输入"); return(false); } Materiel.getInctance().update(m_materielPkey, materiel); return(true); }
public async Task <IActionResult> Edit(int id, [Bind("Id,Reference,Tarif,Type,Taille,Unite,Couleur,UserId")] Materiel materiel) { if (id != materiel.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(materiel); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MaterielExists(materiel.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(materiel)); }
private void FormMaterielEdit_Load(object sender, EventArgs e) { // 初始化下拉框值 ComboBoxExtend.initComboBox(this.comboBoxMaterielAttribut, MATERIEL_ATTRIBUTE_TABLE_NAME, true); ComboBoxExtend.initComboBox(this.comboBoxValuationType, VALUATION_TYPE_LIST_TABLE_NAME, true); ComboBoxExtend.initComboBox(this.comboBoxUnit, UNIT_LIST_TABLE_NAME, true); ComboBoxExtend.initComboBox(this.comboBoxUnitPurchase, UNIT_LIST_TABLE_NAME, true); ComboBoxExtend.initComboBox(this.comboBoxUnitSale, UNIT_LIST_TABLE_NAME, true); ComboBoxExtend.initComboBox(this.comboBoxStorage, STORAGE_LIST_TABLE_NAME, true); if (!m_isAdd) { this.buttonAdd.Enabled = false; this.buttonMaterielGroup.Enabled = false; if (m_isEditMateriel) { m_materiel = Materiel.getInctance().getMaterielInfoFromPkey(m_materielPkey); } else { m_materielType = MaterielType.getInctance().getMaterielTypeInfoFromPkey(m_materielGroupPkey); m_isMaterielGroup = true; } setPageActiveState(); setPageActiveValue(); } m_isInit = true; }
private void setMatetielInfoToDataGridView(string id) { double pkey = Convert.ToDouble(id.ToString()); //使用这个输入的值,匹配物料编号 MaterielTable record = Materiel.getInctance().getMaterielInfoFromNum(Convert.ToString(id)); if (id != record.num || record.pkey == 0) { //使用这个输入的值,匹配物料key record = Materiel.getInctance().getMaterielInfoFromPkey((int)pkey); if (pkey != record.pkey || record.pkey == 0) { MessageBoxExtend.messageWarning("[" + dataGridViewDataList.Rows[m_rowIndex].Cells[m_columnIndex].EditedFormattedValue.ToString() + "]不存在,请重新输入或选择"); m_dateGridVeiwListDataList.clearDataGridViewRow(m_rowIndex); return; } } dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value = record.pkey; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.name; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.model; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Unit].Value = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", record.unitSale); dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Price].Value = "0"; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Value].Value = "0"; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = "0"; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.TransportationCost].Value = "0"; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value = "0"; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.SumTurnover].Value = "0"; }
private void BtnValider_Click(object sender, RoutedEventArgs e) { try { if (string.IsNullOrWhiteSpace(txtDesignation.Text) || string.IsNullOrWhiteSpace(txtQte.Text) || string.IsNullOrWhiteSpace(txtDatePeremption.Text) || cmbEtatMateriel.SelectedIndex == -1) { MessageBox.Show("Veuillez remplir tous les champs !", "mTransport", MessageBoxButton.OK, MessageBoxImage.Error); } else { Materiel M = new Materiel(); M.Designation = txtDesignation.Text; M.QteStock = int.Parse(txtQte.Text); M.Etat = cmbEtatMateriel.SelectedItem.ToString(); M.DatePeremption = txtDatePeremption.SelectedDate; M.Insert(); ListMateriel.Add(M); TabMateriel.Items.Refresh(); MessageBox.Show("Enregistrement effectué !"); GriserChamps(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void FormBaseMateriel_Load(object sender, EventArgs e) { // 树控件初始化 refreshTreeView(); // DataGridView控件初始化 m_dataGridViewExtend.addDataGridViewColumn("ID", 30); m_dataGridViewExtend.addDataGridViewColumn("物料组", 200, false); m_dataGridViewExtend.addDataGridViewColumn("物料名称", 200); m_dataGridViewExtend.addDataGridViewColumn("物料简称", 100); m_dataGridViewExtend.addDataGridViewColumn("助记码", 100); m_dataGridViewExtend.addDataGridViewColumn("规格型号", 100); m_dataGridViewExtend.addDataGridViewColumn("收料仓库", 100); m_dataGridViewExtend.addDataGridViewColumn("物料属性", 100); m_dataGridViewExtend.addDataGridViewColumn("计价方式", 100); m_dataGridViewExtend.addDataGridViewColumn("基本单位", 100); m_dataGridViewExtend.addDataGridViewColumn("采购单位", 100); m_dataGridViewExtend.addDataGridViewColumn("销售单位", 100); m_dataGridViewExtend.addDataGridViewColumn("库存单位", 100, false); m_dataGridViewExtend.addDataGridViewColumn("存货上限", 100); m_dataGridViewExtend.addDataGridViewColumn("存货下限", 100); m_dataGridViewExtend.addDataGridViewColumn("保质期", 100); m_dataGridViewExtend.addDataGridViewColumn("备注", 100); m_dataGridViewExtend.initDataGridViewColumn(this.dataGridViewMaterielList); updateDataGridView(Materiel.getInctance().getAllMaterielInfo()); setPageActionEnable(); ToolStripMenuItemAddMateriel.Enabled = this.add.Enabled; ToolStripMenuItemModifyMateriel.Enabled = this.modify.Enabled; ToolStripMenuItemDeleteMateriel.Enabled = this.delete.Enabled; ToolStripMenuItemForbidMateriel.Enabled = this.forbid.Enabled; ToolStripMenuItemNoForbidMateriel.Enabled = this.noForbid.Enabled; }
private void writeBillDetailsInfoFromBillNumber(string billNumber) { // DataGridView 赋值 SortedDictionary <int, MaterielInOtherOrderDetailsTable> orderDetails = MaterielInOtherOrderDetails.getInctance().getMaterielInOtherInfoFromBillNumber(billNumber); foreach (KeyValuePair <int, MaterielInOtherOrderDetailsTable> index in orderDetails) { MaterielInOtherOrderDetailsTable record = new MaterielInOtherOrderDetailsTable(); record = index.Value; int rowIndex = Convert.ToInt32(record.rowNumber.ToString()) - 1; MaterielTable materielInfo = Materiel.getInctance().getMaterielInfoFromPkey(record.materielID); dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value = record.materielID; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.materielName; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.materielModel; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Parameter].Value = materielInfo.materielParameter; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Brand].Value = materielInfo.brand; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Unit].Value = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", materielInfo.unitSale); dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.CZ].Value = materielInfo.CZ; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Price].Value = record.price; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Value].Value = record.value; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = record.sumMoney; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Note].Value = record.note; } }
private void setMatetielInfoToDataGridView(double pkey) { /* 如果是物料编码列,需要判断该物料编码是否存在 * 如果存在读取相应的值填充DataGridView中对应的其他列,如果不存在该物料编码,则清空该行 * */ MaterielTable record = Materiel.getInctance().getMaterielInfoFromPkey((int)pkey); if (pkey != record.pkey || record.pkey == 0) { MessageBoxExtend.messageWarning("[" + dataGridViewDataList.Rows[m_rowIndex].Cells[m_columnIndex].EditedFormattedValue.ToString() + "]不存在,请重新输入或选择"); m_dateGridVeiwListDataList.clearDataGridViewRow(m_rowIndex); } else { InitMaterielTable MaterielCountdata = InitMateriel.getInctance().getMaterielInfoFromMaterielID((int)pkey); dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.name; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.model; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Unit].Value = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", record.unitSale); dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Price].Value = Convert.ToString(MaterielCountdata.price); dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Value].Value = "0"; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = "0"; } }
private void writeBillDetailsInfoFromBillNumber(string billNumber) { // DataGridView 赋值 SortedDictionary <int, SaleOrderDetailsTable> saleOrderDetails = SaleOrderDetails.getInctance().getSaleInfoFromBillNumber(billNumber); foreach (KeyValuePair <int, SaleOrderDetailsTable> index in saleOrderDetails) { SaleOrderDetailsTable record = new SaleOrderDetailsTable(); record = index.Value; int rowIndex = Convert.ToInt32(record.rowNumber.ToString()) - 1; MaterielTable materielInfo = Materiel.getInctance().getMaterielInfoFromPkey(record.materielID); dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value = record.materielID; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.materielName; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Brand].Value = materielInfo.brand; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.materielModel; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Unit].Value = record.materielUnitSale; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Price].Value = record.price; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Value].Value = record.value; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = record.sumMoney; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.TransportationCost].Value = record.transportationCost; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value = record.otherCost; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.SumTurnover].Value = record.totalMoney; } }
public Boolean ModifierPa(Materiel m, string refe) { try { string reference = m.getReference(); string des = m.getDescription(); string prix = m.getPrix(); string quantite = m.getQuantite(); string lien = m.getLien(); Fabricant fab = m.getFabricant(); Cassier c = m.getCassier(); cn.Open(); cmd.Connection = cn; cmd.CommandText = "update Materiel set ref= @reference, description = @des, prix = @prix, quantite = @quantite, lien = @lien, nomFab = @nomFab, nomCasier=@nomCasier where ref=@refe"; cmd.Parameters.Add(new SqlParameter("@reference", reference)); cmd.Parameters.Add(new SqlParameter("@des", des)); cmd.Parameters.Add(new SqlParameter("@prix", prix)); cmd.Parameters.Add(new SqlParameter("@quantite", quantite)); cmd.Parameters.Add(new SqlParameter("@lien", lien)); cmd.Parameters.Add(new SqlParameter("@nomFab", fab.getNom())); cmd.Parameters.Add(new SqlParameter("@nomCasier", c.getNom())); cmd.Parameters.Add(new SqlParameter("@refe", refe)); cmd.ExecuteNonQuery(); return(true); } catch (SqlException ex) { Console.WriteLine("error :" + ex); return(false); } finally { cn.Close(); } }
public ActionResult Edit(int?id) { if (id == null && !Request.IsAjaxRequest()) { string ErrorMessage = "Id Materiel manquant"; return(RedirectToAction("Index", new { MessageErreur = ErrorMessage })); } Materiel unMateriel = this.materielService.GetMaterielById(id); if (unMateriel == null && !Request.IsAjaxRequest()) { return(HttpNotFound()); } this.IsFromBlocInventaire(); FormMaterielViewModels formModel = this.GetFormMateriel(true, unMateriel); if (Request.IsAjaxRequest()) { return(PartialView("_AjaxEditMateriel", formModel)); } else { return(View(formModel)); } }
public Boolean modifier(Materiel m, string refe) { try { string reference = m.getReference(); string des = m.getDescription(); string prix = m.getPrix(); string quantite = m.getQuantite(); string lien = m.getLien(); Fabricant fab = m.getFabricant(); Cassier c = m.getCassier(); string req = string.Format("update Materiel set ref='" + reference + "', description='" + des + "' , prix='" + prix + "' , quantite='" + quantite + "' , lien='" + lien + "' , nomFab='" + fab.getNom() + "' , nomCasier='" + c.getNom() + "' where ref='" + refe + "'"); cmd.Connection = cn; cn.Open(); cmd.CommandText = req; cmd.ExecuteNonQuery(); return(true); } catch (SqlException ex) { System.Console.WriteLine("error :" + ex.Message); return(false); } finally { cn.Close(); } }
public ActionResult Details(int?id, bool?isFromBlocInventaire) { if (id == null) { string ErrorMessage = "Id Materiel manquant"; return(RedirectToAction("Index", new { MessageErreur = ErrorMessage })); } Materiel unMateriel = this.materielService.GetMaterielById(id); if (unMateriel == null) { return(HttpNotFound()); } //Gestion session isFromInventaire if (isFromBlocInventaire != null && isFromBlocInventaire == true) { if (Session["isFromBlocInventaire"] == null) { Session.Add("isFromBlocInventaire", true); } } this.IsFromBlocInventaire(); return(View(unMateriel)); }
private void FormMaterielStorageInfo_Load(object sender, EventArgs e) { // 树控件初始化 refreshTreeView(); // DataGridView控件初始化 m_dataGridViewExtend.addDataGridViewColumn("ID", 30); m_dataGridViewExtend.addDataGridViewColumn("物料名称", 170); m_dataGridViewExtend.addDataGridViewColumn("型号", 60); m_dataGridViewExtend.addDataGridViewColumn("实际库存", 78); if (m_isDisplayJG) { m_dataGridViewExtend.addDataGridViewColumn("加权单价", 78); m_dataGridViewExtend.addDataGridViewColumn("合计", 60); } // 2016-11-11++ 增加库存预占信息显示 m_dataGridViewExtend.addDataGridViewColumn("预占数量", 78); m_dataGridViewExtend.addDataGridViewColumn("预占人", 78); m_dataGridViewExtend.addDataGridViewColumn("可用数量参考", 110); // ++2016-11-11 m_dataGridViewExtend.addDataGridViewColumn("单位", 60); m_dataGridViewExtend.addDataGridViewColumn("存货上限", 78); m_dataGridViewExtend.addDataGridViewColumn("存货下限", 78); m_dataGridViewExtend.addDataGridViewColumn("保质期", 78); m_dataGridViewExtend.addDataGridViewColumn("收料仓库", 78); m_dataGridViewExtend.initDataGridViewColumn(this.dataGridViewMaterielList); getMaterielProOccupiedList(); updateDataGridView(Materiel.getInctance().getAllMaterielInfo()); }
public void SaveBow(DataTable dt, int TaskID) { Hownet.BLL.SizeBow bllSB = new SizeBow(); Hownet.BLL.Materiel bllMat = new Materiel(); Hownet.BLL.MaterielAttribute blMa = new MaterielAttribute(); Hownet.Model.SizeBow modSB = new Hownet.Model.SizeBow(); int sizeID = 0; modSB.ProduceTaskID = TaskID; for (int c = 1; c < dt.Columns.Count; c++) { if (dt.DefaultView[0][c].ToString() != string.Empty) { sizeID = blMa.GetID(dt.DefaultView[0][c].ToString(), 2); modSB.SizeID = sizeID; if (dt.DefaultView[2][c] != null && dt.DefaultView[2][c].ToString() != string.Empty) { modSB.BowID = bllMat.GetID(dt.DefaultView[2][c].ToString()); } if (dt.DefaultView[1][c] != null && dt.DefaultView[2][c].ToString() != string.Empty) { modSB.CottonID = bllMat.GetID(dt.DefaultView[1][c].ToString()); } modSB.SizeBowID = bllSB.SelectSize(TaskID, sizeID); if (modSB.SizeBowID != 0) { bllSB.Update(modSB); } else { bllSB.Add(modSB); } } } }