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