private void btnXoa_Click(object sender, EventArgs e) { if (btnXoa.Text == "Xóa") { DialogResult rs = MessageBox.Show("Bạn có chắc chắn muốn xóa ?", "Thông báo", MessageBoxButtons.YesNo); if (rs == DialogResult.Yes) { long Emp_ID = Convert.ToInt32(grv_NL.GetFocusedRowCellValue("ID")); bool result = new MaterialDAO().Delete_Material(Emp_ID); if (result) { MessageBox.Show("Xóa nguyên liệu thành công"); Disable_Control(); Load_dgr_NL(); } else { MessageBox.Show("Có lỗi xảy ra"); } } } if (btnXoa.Text == "Hủy") { btnThem.Text = "Thêm"; btnSua.Text = "Sửa"; btnXoa.Text = "Xóa"; Disable_Control(); Load_dgr_NL(); } }
private void 除_Click(object sender, EventArgs e) { if (this.dataGridView1.SelectedRows.Count <= 0) { return; } if (this.dataGridView1.SelectedRows[0].Cells["物料编号"].Value == null) { return; } if (this.dataGridView1.SelectedRows[0].Cells["物料编号"].Value.ToString().Trim() == "") { return; } DialogResult dr = MessageBox.Show("确认删除选中记录?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (dr == DialogResult.OK) { try { MaterialDAO mat_dao = new MaterialDAO(); mat_dao.delete_mat(this.dataGridView1.SelectedRows[0].Cells["物料编号"].Value.ToString().Trim()); initDataGridView(); } catch { MessageBox.Show("请先删除其它表中涉及该物料的记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } }
private void button2_Click(object sender, EventArgs e) { if (text单位.Text == "") { MessageBox.Show("未填写单位"); return; } if (text供应单价.Text == "") { MessageBox.Show("未填写供应单价"); return; } if (com供应商.Text == "") { MessageBox.Show("未填写供应商"); return; } try { MaterialDAO at = new MaterialDAO(); MaterialFlow mtf = new MaterialFlow(); //mtf.Id = com原料编号 mtf.Type = "入仓"; mtf.FlowCount = Convert.ToInt32(textBox进出数量.Text); mtf.MaterialId = Convert.ToInt32(com原料编号.SelectedValue); mtf.Supplier = com供应商.Text; mtf.Price = Convert.ToDouble(text供应单价.Text); mtf.Operator = Utils.GetCurrentUsername(); mtf.OccurredTime = DateTime.Now; String name = textBoxNewName.Text;//原料名称 DialogResult dr = MessageBox.Show("将要对原料[" + name + "]进行入仓,供应商:" + mtf.Supplier + ", 单价: " + mtf.Price + ", 数量:" + mtf.FlowCount, "请确认", MessageBoxButtons.OKCancel); if (dr == DialogResult.OK) { //原料名称this.material.GetMaterialNameBySerial(com原料编号.Text); if (material.AddNewMaterialEx(mtf, name, text单位.Text)) { MessageBox.Show("[" + name + "]更新库存成功!"); dataGridView1.DataSource = this.material.GetAllMaterials(); dataGridView1.Update(); dataGridView2.DataSource = this.material.GetAllMaterialFlow(); dataGridView2.Update(); } } } catch (Exception ex) { MessageBox.Show("更新库存失败!" + ex.ToString()); } }
public int eliminar(Material material) { MaterialDAO oMaterial = new MaterialDAO(); try { return(oMaterial.Eliminar(material)); } catch (Exception) { throw; } }
public DataSet listado() { MaterialDAO oMaterial = new MaterialDAO(); try { return(oMaterial.GetAll()); } catch (Exception) { throw; } }
public static void DeleteMaterialCost(string MaterialCostCode) { try { EntityData entity = MaterialDAO.GetMaterialCostByCode(MaterialCostCode); MaterialDAO.DeleteMaterialCost(entity); entity.Dispose(); } catch (Exception exception) { throw exception; } }
public static void DeleteSupplierMaterial(string SupplierMaterialCode) { try { EntityData entity = MaterialDAO.GetSupplierMaterialByCode(SupplierMaterialCode); MaterialDAO.DeleteSupplierMaterial(entity); entity.Dispose(); } catch (Exception exception) { throw exception; } }
public ActionResult Edit(Material obj) { try { MaterialDAO mdao = new MaterialDAO(); mdao.update(obj); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(Material mat) { try { MaterialDAO mdao = new MaterialDAO(); mdao.insert(mat); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Delete(int id, FormCollection collection) { try { MaterialDAO mdao = new MaterialDAO(); mdao.delete(new Material() { Id_mat = id }); return(RedirectToAction("Index")); } catch { return(View()); } }
private void btnSua_Click(object sender, EventArgs e) { if (btnSua.Text == "Sửa") { btnSua.Text = "Lưu"; btnSua.Image = Resources.download_32x32; btnXoa.Text = "Hủy"; btnXoa.Image = Resources.cancel_32x32; btnThem.Enabled = false; Enable_Control(); return; } if (btnSua.Text == "Lưu") { if (Validate()) { Material item = new Material(); item.ID = Convert.ToInt32(txb_MaNL.Text); item.Name = txb_TenNL.Text; item.Unit = txb_DonViTinh.Text; item.Price = Convert.ToDecimal(txb_Gia.Text); item.TypeMaterialID = Convert.ToInt32(cbo_LoaiNL.SelectedValue); bool result = new MaterialDAO().Update_Material(item); if (result) { MessageBox.Show("Sửa nguyên liệu thành công"); Disable_Control(); Load_dgr_NL(); } else { MessageBox.Show("Sửa nguyên liệu xảy ra lỗi"); } } return; } }
private void InitializeMaterials() { MaterialDAO = new MaterialDAO(Material, MaterialStr); var materials = MaterialDAO.GetColunm(MaterialStr); for (int i = 0; i < materials.Length; i++) { if (materialDict.ContainsKey(materials[i])) { continue; } var bulletHole = Resources.Load <GameObject>(MaterialDAO.GetBulletHole(materials[i])); var detectionDepth = MaterialDAO.GetDetectionDepth(materials[i]); var impactEffect = Resources.Load <GameObject>(MaterialDAO.GetImpactEffect(materials[i])); var impactSize = MaterialDAO.GetImpactSize(materials[i]); materialDict.Add(materials[i], new MaterialData(bulletHole, detectionDepth, impactEffect, impactSize)); } }
public int Guardar(Material material) { MaterialDAO oMaterial = new MaterialDAO(); try { if (material.Id == 0) { return(oMaterial.Insertar(material)); } else { return(oMaterial.Actualizar(material)); } } catch (Exception) { throw; } }
public string EliminarMaterial(int Id) { return(MaterialDAO.Eliminar(Id)); }
public string ActualizarMaterial(Material mat) { return(MaterialDAO.Actualizar(mat)); }
public Material ListarMaterial(int IdMaterial) { return(MaterialDAO.Listar(IdMaterial)); }
public string IngresarMaterial(Material mat) { return(MaterialDAO.Ingresar(mat)); }
public Prestamo ObtenerPrestamo(string cod) { String _sql = @" SELECT CONCAT('PR-',c.pres_id) Codigo ,c.[estado] Estado ,c.[fec_reserva] FechaReserva ,c.[fec_ini_pre] FechaPrestamo ,c.[fec_fin_pre] FechaEntrega ,c.[fec_devolucion] FechaDevolucion ,c.[observacion] Observacion ,c.[per_id] Persona ,c.[adm_id] UsuarioCreacion ,convert(varchar(256),(select concat(',',m.mat_cod ) from [tb_prestamo_det] p inner join tb_material m on p.mat_id=m.mat_id where p.pres_id = c.pres_id for xml path('')) ) Materiales FROM [dbo].[tb_prestamo] c with(nolock) WHERE CONCAT('PR-',c.pres_id) = @Codigo"; Prestamo _pres = null; string _mat = string.Empty; List <Material> _materiales = new List <Material>(); MaterialDAO _matDao = new MaterialDAO(); Conexion _cnx = new Conexion(); SqlCommand _cmd = new SqlCommand(_sql, _cnx.ObtenerConexion()); _cmd.Parameters.AddWithValue("@Codigo", cod); _cnx.AbrirConexion(); using (SqlDataReader _reader = _cmd.ExecuteReader()) { if (_reader.Read()) { _pres = new Prestamo { Codigo = _reader["Codigo"].ToString(), Estado = Convert.ToInt16(_reader["Estado"].ToString()), FechaDevolucion = string.IsNullOrEmpty(_reader["FechaDevolucion"].ToString()) ? _dateNull: Convert.ToDateTime(_reader["FechaDevolucion"].ToString()), FechaEntrega = _reader["FechaEntrega"] == null ? _dateNull : Convert.ToDateTime(_reader["FechaEntrega"].ToString()), FechaPrestamo = _reader["FechaPrestamo"] == null ? _dateNull : Convert.ToDateTime(_reader["FechaPrestamo"].ToString()), FechaReserva = string.IsNullOrEmpty(_reader["FechaReserva"].ToString()) ? _dateNull : Convert.ToDateTime(_reader["FechaReserva"].ToString()), Observacion = _reader["Observacion"] == null ? string.Empty: _reader["Observacion"].ToString(), PersonaId = Convert.ToInt32(_reader["Persona"].ToString()), UsuarioCreacion = Convert.ToInt32(_reader["UsuarioCreacion"].ToString()) }; _pres.Persona = new Persona { Codigo = ObtenerPersonaCodigo(_pres.PersonaId.Value) }; _mat = _reader["Materiales"] == null ? string.Empty : _reader["Materiales"].ToString(); foreach (string codmat in _mat.Split(',')) { if (string.IsNullOrEmpty(codmat)) { continue; } _materiales.Add(_matDao.ObtenerMaterial(codmat)); } _pres.Materiales = _materiales; } } _cnx.CerrarConexion(); return(_pres); }
public List <Material> ListarMaterial() { return(MaterialDAO.Listar()); }
private void 删除_Click(object sender, EventArgs e) { if (this.dataGridView1.SelectedRows.Count <= 0) return; if (this.dataGridView1.SelectedRows[0].Cells["物料编号"].Value == null) return; if (this.dataGridView1.SelectedRows[0].Cells["物料编号"].Value.ToString().Trim() == "") return; DialogResult dr= MessageBox.Show("确认删除选中记录?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (dr == DialogResult.OK) { try { MaterialDAO mat_dao = new MaterialDAO(); mat_dao.delete_mat(this.dataGridView1.SelectedRows[0].Cells["物料编号"].Value.ToString().Trim()); initDataGridView(); } catch { MessageBox.Show("请先删除其它表中涉及该物料的记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } }
public MaterialManager() { this.dao = new MaterialDAO(); }
public MaterialBL() { _dao = new MaterialDAO(); }
public Material ObtenerMaterial(int pId) { MaterialDAO _MaterialDAO = new MaterialDAO(); return(_MaterialDAO.ObtenerMaterialPorCodigo(pId)); }
private void button1_Click(object sender, EventArgs e) { string str = "已完成原料编号领料:"; //for (int i = 0; i < dataGridView1.RowCount - 1; i++) //{ // if (dataGridView1.Rows[i].Cells["供应商"].Value.ToString() == "") // { // MessageBox.Show("请选择供应商和单价!"); // return; // } //} try { for (int i = 0; i < dataGridView1.RowCount; i++) { if (Convert.ToInt32(dataGridView1.Rows[i].Cells["需要原料数量"].Value) >= Convert.ToInt32(dataGridView1.Rows[i].Cells["库存数量"].Value)) { MessageBox.Show("领料失败:\n\r原料库存不足!"); return; } } bool ok = true; int num = 0; for (int i = 0; i < dataGridView1.RowCount; i++) { num = Convert.ToInt32(dataGridView1.Rows[i].Cells["库存数量"].Value) - Convert.ToInt32(dataGridView1.Rows[i].Cells["需要原料数量"].Value); if (mtm.MaterialDesTo(dataGridView1.Rows[i].Cells["原料编号"].Value.ToString(), num) == true) { str += dataGridView1.Rows[i].Cells["原料编号"].Value.ToString() + ","; //ok = false; //***************************** MaterialDAO at = new MaterialDAO(); MaterialFlow mtf = new MaterialFlow(); //mtf.Id = com原料编号 mtf.Type = "领料生产"; mtf.FlowCount = 0 - Convert.ToInt32(dataGridView1.Rows[i].Cells["需要原料数量"].Value); mtf.MaterialId = Convert.ToInt32(dataGridView1.Rows[i].Cells["原料编号"].Value); //供应商选择 //mtf.Supplier = dataGridView1.Rows[i].Cells["供应商"].Value.ToString(); //mtf.Price = Convert.ToDouble(dataGridView1.Rows[i].Cells["供应单价"].Value); //mtf.Price = 0.0; mtf.Operator = Utils.GetCurrentUsername(); mtf.OccurredTime = DateTime.Now; String name = text原料名称.Text;//原料名称 if (material.AddNewMaterialEx(mtf, name, text单位.Text)) { com供应商.Text = ""; // text单价.Text = ""; // text单位.Text = ""; text原料名称.Text = ""; } //***************************** } else { ok = false; MessageBox.Show("领料失败!此原料为," + dataGridView1.Rows[i].Cells["原料编号"].Value.ToString()); return; } } if (ok) { if (ppm.UpdatePlanStatus(ProductionPlanStatus.PROCESSING, textBox订单.Text)) { MessageBox.Show("领料成功!!!"); this.Close(); } else { MessageBox.Show("领料失败!"); } } } catch (Exception ex) { MessageBox.Show("领料失败!"); }; }
public ActionResult Index() { MaterialDAO mdao = new MaterialDAO(); return(View(mdao.Select())); }
public ActionResult Delete(int id) { MaterialDAO mdao = new MaterialDAO(); return(View(mdao.Select(id))); }