/// <summary> /// 返回编码列表 /// </summary> /// <param name="_orderid">工单单号</param> /// <param name="_type">条码类型</param> /// <param name="_Barcode_State">条码状态</param> /// <returns></returns> public ArrayList Get_SN_List(Maticsoft.Model.PackBatch _PackBatch, Maticsoft.Model.E_SerialNumber_Type _type, Maticsoft.Model.E_Barcode_State _Barcode_State) { string strSql = "SELECT SN FROM tb_SerialNumber WHERE (BatchNo = '" + _PackBatch.BatchNo + "') AND (Type = '" + _type + "') AND (State = '" + _Barcode_State + "')"; DataSet ds = dbs.Query(strSql); ArrayList temList = new ArrayList(); foreach (DataRow dt in ds.Tables[0].Rows) { temList.Add(dt["SN"].ToString()); } return(temList); }
/// <summary> /// 返回编码列表 /// </summary> /// <param name="_orderid">工单单号</param> /// <param name="_type">条码类型</param> /// <param name="_Barcode_State">条码状态</param> /// <returns></returns> public ArrayList Get_SN_List(Maticsoft.Model.PackBatch _PackBatch, Maticsoft.Model.E_SerialNumber_Type _type, Maticsoft.Model.E_Barcode_State _Barcode_State) { return(dal.Get_SN_List(_PackBatch, _type, _Barcode_State)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.PackBatch model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.PackBatch model) { //先删除再更新 防止重复 dal.Delete(model.BatchNo); return(dal.Add(model)); }