/// <summary> /// 得到一个对象实体 /// </summary> public View_QueryStockListModel GetOutHouseModel(int GoodsSiteID, string gsStoreStatus, string gsRunStatus) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from View_QueryStockList "); strSql.Append(" where GoodsSiteID=@GoodsSiteID "); strSql.Append(" and GoodsSiteStoreStatus=@GoodsSiteStoreStatus "); strSql.Append(" and GoodsSiteRunStatus=@GoodsSiteRunStatus "); SqlParameter[] parameters = { new SqlParameter("@GoodsSiteID", SqlDbType.Int, 4), new SqlParameter("@GoodsSiteStoreStatus", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteRunStatus", SqlDbType.NVarChar, 50) }; parameters[0].Value = GoodsSiteID; parameters[1].Value = gsStoreStatus; parameters[2].Value = gsRunStatus; ECAMSDataAccess.GoodsSiteModel model = new ECAMSDataAccess.GoodsSiteModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public GoodsSiteModel GetOutHouseModel(int GoodsSiteID, string gsStoreStatus, string gsRunStatus) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 GoodsSiteID,GoodsSiteName,GoodsSiteType,GoodsSiteLayer,GoodsSiteColumn,GoodsSiteRow,DeviceID,GoodsSiteStoreStatus,GoodsSiteRunStatus,GoodsSiteInOutType,GoodsSiteStoreType,LogicStoreAreaID,StoreAreaID from GoodsSite "); strSql.Append(" where GoodsSiteID=@GoodsSiteID "); strSql.Append(" and GoodsSiteStoreStatus=@GoodsSiteStoreStatus "); strSql.Append(" and GoodsSiteRunStatus=@GoodsSiteRunStatus "); SqlParameter[] parameters = { new SqlParameter("@GoodsSiteID", SqlDbType.Int, 4), new SqlParameter("@GoodsSiteStoreStatus", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteRunStatus", SqlDbType.NVarChar, 50) }; parameters[0].Value = GoodsSiteID; parameters[1].Value = gsStoreStatus; parameters[2].Value = gsRunStatus; ECAMSDataAccess.GoodsSiteModel model = new ECAMSDataAccess.GoodsSiteModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ECAMSDataAccess.GoodsSiteModel DataRowToModel(DataRow row) { ECAMSDataAccess.GoodsSiteModel model = new ECAMSDataAccess.GoodsSiteModel(); if (row != null) { if (row["GoodsSiteID"] != null && row["GoodsSiteID"].ToString() != "") { model.GoodsSiteID = int.Parse(row["GoodsSiteID"].ToString()); } if (row["GoodsSiteName"] != null) { model.GoodsSiteName = row["GoodsSiteName"].ToString(); } if (row["GoodsSiteType"] != null) { model.GoodsSiteType = row["GoodsSiteType"].ToString(); } if (row["GoodsSiteLayer"] != null && row["GoodsSiteLayer"].ToString() != "") { model.GoodsSiteLayer = int.Parse(row["GoodsSiteLayer"].ToString()); } if (row["GoodsSiteColumn"] != null && row["GoodsSiteColumn"].ToString() != "") { model.GoodsSiteColumn = int.Parse(row["GoodsSiteColumn"].ToString()); } if (row["GoodsSiteRow"] != null && row["GoodsSiteRow"].ToString() != "") { model.GoodsSiteRow = int.Parse(row["GoodsSiteRow"].ToString()); } if (row["DeviceID"] != null) { model.DeviceID = row["DeviceID"].ToString(); } if (row["GoodsSiteStoreStatus"] != null) { model.GoodsSiteStoreStatus = row["GoodsSiteStoreStatus"].ToString(); } if (row["GoodsSiteRunStatus"] != null) { model.GoodsSiteRunStatus = row["GoodsSiteRunStatus"].ToString(); } if (row["GoodsSiteInOutType"] != null) { model.GoodsSiteInOutType = row["GoodsSiteInOutType"].ToString(); } if (row["GoodsSiteStoreType"] != null) { model.GoodsSiteStoreType = row["GoodsSiteStoreType"].ToString(); } if (row["LogicStoreAreaID"] != null && row["LogicStoreAreaID"].ToString() != "") { model.LogicStoreAreaID = int.Parse(row["LogicStoreAreaID"].ToString()); } if (row["StoreAreaID"] != null && row["StoreAreaID"].ToString() != "") { model.StoreAreaID = int.Parse(row["StoreAreaID"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ECAMSDataAccess.GoodsSiteModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GoodsSite set "); strSql.Append("GoodsSiteName=@GoodsSiteName,"); strSql.Append("GoodsSiteType=@GoodsSiteType,"); strSql.Append("GoodsSiteLayer=@GoodsSiteLayer,"); strSql.Append("GoodsSiteColumn=@GoodsSiteColumn,"); strSql.Append("GoodsSiteRow=@GoodsSiteRow,"); strSql.Append("DeviceID=@DeviceID,"); strSql.Append("GoodsSiteStoreStatus=@GoodsSiteStoreStatus,"); strSql.Append("GoodsSiteRunStatus=@GoodsSiteRunStatus,"); strSql.Append("GoodsSiteInOutType=@GoodsSiteInOutType,"); strSql.Append("GoodsSiteStoreType=@GoodsSiteStoreType,"); strSql.Append("LogicStoreAreaID=@LogicStoreAreaID,"); strSql.Append("StoreAreaID=@StoreAreaID"); strSql.Append(" where GoodsSiteID=@GoodsSiteID "); SqlParameter[] parameters = { new SqlParameter("@GoodsSiteName", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteType", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteLayer", SqlDbType.Int, 4), new SqlParameter("@GoodsSiteColumn", SqlDbType.Int, 4), new SqlParameter("@GoodsSiteRow", SqlDbType.Int, 4), new SqlParameter("@DeviceID", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteStoreStatus", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteRunStatus", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteInOutType", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteStoreType", SqlDbType.NVarChar, 50), new SqlParameter("@LogicStoreAreaID", SqlDbType.Int, 4), new SqlParameter("@StoreAreaID", SqlDbType.Int, 4), new SqlParameter("@GoodsSiteID", SqlDbType.Int, 4) }; parameters[0].Value = model.GoodsSiteName; parameters[1].Value = model.GoodsSiteType; parameters[2].Value = model.GoodsSiteLayer; parameters[3].Value = model.GoodsSiteColumn; parameters[4].Value = model.GoodsSiteRow; parameters[5].Value = model.DeviceID; parameters[6].Value = model.GoodsSiteStoreStatus; parameters[7].Value = model.GoodsSiteRunStatus; parameters[8].Value = model.GoodsSiteInOutType; parameters[9].Value = model.GoodsSiteStoreType; parameters[10].Value = model.LogicStoreAreaID; parameters[11].Value = model.StoreAreaID; parameters[12].Value = model.GoodsSiteID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ECAMSDataAccess.GoodsSiteModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into GoodsSite("); strSql.Append("GoodsSiteID,GoodsSiteName,GoodsSiteType,GoodsSiteLayer,GoodsSiteColumn,GoodsSiteRow,DeviceID,GoodsSiteStoreStatus,GoodsSiteRunStatus,GoodsSiteInOutType,GoodsSiteStoreType,LogicStoreAreaID,StoreAreaID)"); strSql.Append(" values ("); strSql.Append("@GoodsSiteID,@GoodsSiteName,@GoodsSiteType,@GoodsSiteLayer,@GoodsSiteColumn,@GoodsSiteRow,@DeviceID,@GoodsSiteStoreStatus,@GoodsSiteRunStatus,@GoodsSiteInOutType,@GoodsSiteStoreType,@LogicStoreAreaID,@StoreAreaID)"); SqlParameter[] parameters = { new SqlParameter("@GoodsSiteID", SqlDbType.Int, 4), new SqlParameter("@GoodsSiteName", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteType", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteLayer", SqlDbType.Int, 4), new SqlParameter("@GoodsSiteColumn", SqlDbType.Int, 4), new SqlParameter("@GoodsSiteRow", SqlDbType.Int, 4), new SqlParameter("@DeviceID", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteStoreStatus", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteRunStatus", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteInOutType", SqlDbType.NVarChar, 50), new SqlParameter("@GoodsSiteStoreType", SqlDbType.NVarChar, 50), new SqlParameter("@LogicStoreAreaID", SqlDbType.Int, 4), new SqlParameter("@StoreAreaID", SqlDbType.Int, 4) }; parameters[0].Value = model.GoodsSiteID; parameters[1].Value = model.GoodsSiteName; parameters[2].Value = model.GoodsSiteType; parameters[3].Value = model.GoodsSiteLayer; parameters[4].Value = model.GoodsSiteColumn; parameters[5].Value = model.GoodsSiteRow; parameters[6].Value = model.DeviceID; parameters[7].Value = model.GoodsSiteStoreStatus; parameters[8].Value = model.GoodsSiteRunStatus; parameters[9].Value = model.GoodsSiteInOutType; parameters[10].Value = model.GoodsSiteStoreType; parameters[11].Value = model.LogicStoreAreaID; parameters[12].Value = model.StoreAreaID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }