/// <summary> /// 更新钢网信息 /// </summary> /// <param name="partstoremodel"></param> /// <param name="trsn"></param> /// <returns></returns> public void UpdateGangInfo(Entity.tPartStorehousehad partstoremodel, string trsn) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "update SFCR.T_PART_STOREHOUSE_HAD set kpnumber=@kpnumber,vendercode=@vendercode,storehouseId=@storehouseId,locId=@locId,sstatus=@ssta,remark=@remark where trsn=@trsn"; cmd.Parameters.Add("trsn", MySqlDbType.VarChar, 30).Value = trsn; cmd.Parameters.Add("kpnumber", MySqlDbType.VarChar, 30).Value = partstoremodel.KpNumber; cmd.Parameters.Add("vendercode", MySqlDbType.VarChar, 30).Value = partstoremodel.VenderCode; cmd.Parameters.Add("storehouseId", MySqlDbType.VarChar, 20).Value = partstoremodel.storehouseId; cmd.Parameters.Add("locId", MySqlDbType.VarChar, 20).Value = partstoremodel.LocId; cmd.Parameters.Add("ssta", MySqlDbType.VarChar).Value = partstoremodel.status.ToString(); cmd.Parameters.Add("remark", MySqlDbType.VarChar, 100).Value = partstoremodel.Remark; BLL.BllMsSqllib.Instance.ExecteNonQuery(cmd); }
/// <summary> /// 材料接收时打印五合一标签 /// </summary> /// <param name="sd"></param> public void MaterialPrint(Entity.tPartStorehousehad sd, string kpdesc, string partgroup, string vendername, string PO) { BLL.BllMsSqllib.Instance.MaterialPrint(sd, kpdesc, partgroup, vendername, PO); }