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