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