/// <summary> /// 更新一条数据 /// </summary> public bool Update(FTDataAccess.Model.OnlineProductsModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OnlineProducts set "); strSql.Append("rfidCode=@rfidCode,"); strSql.Append("inputTime=@inputTime,"); strSql.Append("currentNode=@currentNode"); strSql.Append(" where productBarcode=@productBarcode "); SqlParameter[] parameters = { new SqlParameter("@inputTime", SqlDbType.DateTime), new SqlParameter("@currentNode", SqlDbType.NVarChar, 50), new SqlParameter("@productBarcode", SqlDbType.NVarChar, 50), new SqlParameter("@rfidCode", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.inputTime; parameters[1].Value = model.currentNode; parameters[2].Value = model.productBarcode; parameters[3].Value = model.rfidCode; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(FTDataAccess.Model.OnlineProductsModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OnlineProducts("); strSql.Append("productBarcode,inputTime,currentNode,rfidCode)"); strSql.Append(" values ("); strSql.Append("@productBarcode,@inputTime,@currentNode,@rfidCode)"); SqlParameter[] parameters = { new SqlParameter("@productBarcode", SqlDbType.NVarChar, 50), new SqlParameter("@inputTime", SqlDbType.DateTime), new SqlParameter("@currentNode", SqlDbType.NVarChar, 50), new SqlParameter("@rfidCode", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.productBarcode; parameters[1].Value = model.inputTime; parameters[2].Value = model.currentNode; parameters[3].Value = model.rfidCode; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public FTDataAccess.Model.OnlineProductsModel DataRowToModel(DataRow row) { FTDataAccess.Model.OnlineProductsModel model = new FTDataAccess.Model.OnlineProductsModel(); if (row != null) { if (row["productBarcode"] != null) { model.productBarcode = row["productBarcode"].ToString(); } if (row["inputTime"] != null && row["inputTime"].ToString() != "") { model.inputTime = DateTime.Parse(row["inputTime"].ToString()); } if (row["currentNode"] != null) { model.currentNode = row["currentNode"].ToString(); } if (row["rfidCode"] != null) { model.rfidCode = row["rfidCode"].ToString(); } } return(model); }
public FTDataAccess.Model.OnlineProductsModel GetModelByrfid(string rfidcode) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 productBarcode,inputTime,currentNode,rfidCode from OnlineProducts "); strSql.Append(" where rfidCode=@rfidCode "); SqlParameter[] parameters = { new SqlParameter("@rfidCode", SqlDbType.NVarChar, 50) }; parameters[0].Value = rfidcode; FTDataAccess.Model.OnlineProductsModel model = new FTDataAccess.Model.OnlineProductsModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }