Пример #1
0
        /// <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);
        }
Пример #2
0
 /// <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);
 }