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);
}
}
}
}
