/// <summary> /// 绑定条形码 /// </summary> /// <param name="barCode">条形码</param> /// <param name="jobID">工单号</param> /// <returns></returns> public void BindFile(string barCode, string jobID) { try { JobBar da = new JobBar(); DataTable dt = da.GetList("IsDelete=0 and JobID='" + jobID + "'").Tables[0]; Entity.JobBar bar = new Entity.JobBar(); if (dt.Rows.Count > 0) { bar = da.DataRowToModel(dt.Rows[0]); bar.BarCode = barCode; da.Update(bar); } else { bar.Guid = Guid.NewGuid().ToString(); bar.BarCode = barCode; bar.JobID = jobID; bar.IsDelete = false; da.Add(bar); } } catch (Exception ex) { throw ex; } }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "JobBar"; * parameters[1].Value = "Guid"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod /// <summary> /// 判断是否已绑定 /// </summary> /// <param name="barCode"></param> /// <returns></returns> public bool IsBind(string barCode) { JobBar da = new JobBar(); DataTable dt = da.GetList("IsDelete=0 and BarCode='" + barCode + "'").Tables[0]; if (dt.Rows.Count > 0) { return(true); } else { return(false); } }
/// <summary> /// 解绑条形码 /// </summary> /// <param name="jobID">工单号</param> /// <returns></returns> public void DisBindFile(string jobID) { try { JobBar da = new JobBar(); DataTable dt = da.GetList("IsDelete=0 and jobID='" + jobID + "'").Tables[0]; Entity.JobBar bar = new Entity.JobBar(); if (dt.Rows.Count > 0) { bar = da.DataRowToModel(dt.Rows[0]); bar.IsDelete = true; da.Update(bar); } } catch (Exception ex) { throw ex; } }