public void SearchWhereToId(Rfid_bound data)
{
rfid_bound = data;
if (rfid_bound != null && rfid_bound.Tag_id > 0)
{
tagID = rfid_bound.Tag_id;
}
}
/// <summary>
/// 构建搜索条件
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
private string AppendWhere(object p, int thisID)
{
string sqlWhere = " 1=1 ";
if (p != null)
{
Rfid_bound obj = p as Rfid_bound;
sqlWhere += string.IsNullOrEmpty(obj.Werks) ? "" : " AND Werks LIKE '%" + obj.Werks + "%' ";
sqlWhere += string.IsNullOrEmpty(obj.Zpltn) ? "" : " AND Zpltn LIKE '%" + obj.Zpltn + "%' ";
sqlWhere += string.IsNullOrEmpty(obj.Matnr) ? "" : " AND Matnr LIKE '%" + obj.Matnr + "%' ";
sqlWhere += string.IsNullOrEmpty(obj.Exidv) ? "" : " AND Exidv LIKE '%" + obj.Exidv + "%' ";
sqlWhere += string.IsNullOrEmpty(obj.Pt) ? "" : " AND Pt LIKE '%" + obj.Pt + "%' ";
sqlWhere += string.IsNullOrEmpty(obj.StartTime) ? "" : " AND Intime>=" + obj.StartTime;
sqlWhere += string.IsNullOrEmpty(obj.EndTime) ? "" : " AND Intime<=" + obj.EndTime;
sqlWhere += string.IsNullOrEmpty(obj.Bin) ? "" : " AND Bin='" + obj.Bin + "'";
sqlWhere += obj.Inbin <= 0 ? "" : " AND Inbin=" + obj.Inbin;
sqlWhere += obj.Bounded <= 0 ? "" : " AND Bounded=" + obj.Bounded;
}
sqlWhere += (thisID <= 0) ? "" : " AND Tag_id=" + thisID;
return(sqlWhere);
}
public ActionResult EditSaveMethod(Rfid_bound data)
{
MessageShow msg = bll.EditSaveMethod(data);
return(Json(new { success = msg.success, message = msg.message }, JsonRequestBehavior.AllowGet));
}
public void SearchWhere(Rfid_bound data)
{
rfid_bound = data;
}
public ActionResult Index()
{
tagID = 0;
rfid_bound = null;
return(View());
}
