/// <summary>
/// 增加一条数据
/// </summary>
public long Add(AsrsStorDBAcc.Model.GoodsSiteModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into GoodsSite(");
strSql.Append("StoreHouseID,StoreHouseLogicAreaID,GoodsSiteName,GoodsSiteLayer,GoodsSiteColumn,GoodsSiteRow,GoodsSiteTaskStatus,GsEnabled,GoodsSiteType,GoodsSitePos,GoodsSiteStatus,GoodsSiteOperate,Reserve)");
strSql.Append(" values (");
strSql.Append("@StoreHouseID,@StoreHouseLogicAreaID,@GoodsSiteName,@GoodsSiteLayer,@GoodsSiteColumn,@GoodsSiteRow,@GoodsSiteTaskStatus,@GsEnabled,@GoodsSiteType,@GoodsSitePos,@GoodsSiteStatus,@GoodsSiteOperate,@Reserve)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@StoreHouseID", SqlDbType.BigInt, 8),
new SqlParameter("@StoreHouseLogicAreaID", SqlDbType.BigInt, 8),
new SqlParameter("@GoodsSiteName", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsSiteLayer", SqlDbType.Int, 4),
new SqlParameter("@GoodsSiteColumn", SqlDbType.Int, 4),
new SqlParameter("@GoodsSiteRow", SqlDbType.Int, 4),
new SqlParameter("@GoodsSiteTaskStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@GsEnabled", SqlDbType.Bit, 1),
new SqlParameter("@GoodsSiteType", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsSitePos", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsSiteStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsSiteOperate", SqlDbType.NVarChar, 50),
new SqlParameter("@Reserve", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.StoreHouseID;
parameters[1].Value = model.StoreHouseLogicAreaID;
parameters[2].Value = model.GoodsSiteName;
parameters[3].Value = model.GoodsSiteLayer;
parameters[4].Value = model.GoodsSiteColumn;
parameters[5].Value = model.GoodsSiteRow;
parameters[6].Value = model.GoodsSiteTaskStatus;
parameters[7].Value = model.GsEnabled;
parameters[8].Value = model.GoodsSiteType;
parameters[9].Value = model.GoodsSitePos;
parameters[10].Value = model.GoodsSiteStatus;
parameters[11].Value = model.GoodsSiteOperate;
parameters[12].Value = model.Reserve;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public AsrsStorDBAcc.Model.GoodsSiteModel GetModel(long GoodsSiteID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 GoodsSiteID,StoreHouseID,StoreHouseLogicAreaID,GoodsSiteName,GoodsSiteLayer,GoodsSiteColumn,GoodsSiteRow,GoodsSiteTaskStatus,GsEnabled,GoodsSiteType,GoodsSitePos,GoodsSiteStatus,GoodsSiteOperate,Reserve from GoodsSite ");
strSql.Append(" where GoodsSiteID=@GoodsSiteID");
SqlParameter[] parameters =
{
new SqlParameter("@GoodsSiteID", SqlDbType.BigInt)
};
parameters[0].Value = GoodsSiteID;
AsrsStorDBAcc.Model.GoodsSiteModel model = new AsrsStorDBAcc.Model.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 bool Update(AsrsStorDBAcc.Model.GoodsSiteModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GoodsSite set ");
strSql.Append("StoreHouseID=@StoreHouseID,");
strSql.Append("StoreHouseLogicAreaID=@StoreHouseLogicAreaID,");
strSql.Append("GoodsSiteName=@GoodsSiteName,");
strSql.Append("GoodsSiteLayer=@GoodsSiteLayer,");
strSql.Append("GoodsSiteColumn=@GoodsSiteColumn,");
strSql.Append("GoodsSiteRow=@GoodsSiteRow,");
strSql.Append("GoodsSiteTaskStatus=@GoodsSiteTaskStatus,");
strSql.Append("GsEnabled=@GsEnabled,");
strSql.Append("GoodsSiteType=@GoodsSiteType,");
strSql.Append("GoodsSitePos=@GoodsSitePos,");
strSql.Append("GoodsSiteStatus=@GoodsSiteStatus,");
strSql.Append("GoodsSiteOperate=@GoodsSiteOperate,");
strSql.Append("Reserve=@Reserve");
strSql.Append(" where GoodsSiteID=@GoodsSiteID");
SqlParameter[] parameters =
{
new SqlParameter("@StoreHouseID", SqlDbType.BigInt, 8),
new SqlParameter("@StoreHouseLogicAreaID", SqlDbType.BigInt, 8),
new SqlParameter("@GoodsSiteName", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsSiteLayer", SqlDbType.Int, 4),
new SqlParameter("@GoodsSiteColumn", SqlDbType.Int, 4),
new SqlParameter("@GoodsSiteRow", SqlDbType.Int, 4),
new SqlParameter("@GoodsSiteTaskStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@GsEnabled", SqlDbType.Bit, 1),
new SqlParameter("@GoodsSiteType", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsSitePos", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsSiteStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsSiteOperate", SqlDbType.NVarChar, 50),
new SqlParameter("@Reserve", SqlDbType.NVarChar, 200),
new SqlParameter("@GoodsSiteID", SqlDbType.BigInt, 8)
};
parameters[0].Value = model.StoreHouseID;
parameters[1].Value = model.StoreHouseLogicAreaID;
parameters[2].Value = model.GoodsSiteName;
parameters[3].Value = model.GoodsSiteLayer;
parameters[4].Value = model.GoodsSiteColumn;
parameters[5].Value = model.GoodsSiteRow;
parameters[6].Value = model.GoodsSiteTaskStatus;
parameters[7].Value = model.GsEnabled;
parameters[8].Value = model.GoodsSiteType;
parameters[9].Value = model.GoodsSitePos;
parameters[10].Value = model.GoodsSiteStatus;
parameters[11].Value = model.GoodsSiteOperate;
parameters[12].Value = model.Reserve;
parameters[13].Value = model.GoodsSiteID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public AsrsStorDBAcc.Model.GoodsSiteModel DataRowToModel(DataRow row)
{
AsrsStorDBAcc.Model.GoodsSiteModel model = new AsrsStorDBAcc.Model.GoodsSiteModel();
if (row != null)
{
if (row["GoodsSiteID"] != null && row["GoodsSiteID"].ToString() != "")
{
model.GoodsSiteID = long.Parse(row["GoodsSiteID"].ToString());
}
if (row["StoreHouseID"] != null && row["StoreHouseID"].ToString() != "")
{
model.StoreHouseID = long.Parse(row["StoreHouseID"].ToString());
}
if (row["StoreHouseLogicAreaID"] != null && row["StoreHouseLogicAreaID"].ToString() != "")
{
model.StoreHouseLogicAreaID = long.Parse(row["StoreHouseLogicAreaID"].ToString());
}
if (row["GoodsSiteName"] != null)
{
model.GoodsSiteName = row["GoodsSiteName"].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["GoodsSiteTaskStatus"] != null)
{
model.GoodsSiteTaskStatus = row["GoodsSiteTaskStatus"].ToString();
}
if (row["GsEnabled"] != null && row["GsEnabled"].ToString() != "")
{
if ((row["GsEnabled"].ToString() == "1") || (row["GsEnabled"].ToString().ToLower() == "true"))
{
model.GsEnabled = true;
}
else
{
model.GsEnabled = false;
}
}
if (row["GoodsSiteType"] != null)
{
model.GoodsSiteType = row["GoodsSiteType"].ToString();
}
if (row["GoodsSitePos"] != null)
{
model.GoodsSitePos = row["GoodsSitePos"].ToString();
}
if (row["GoodsSiteStatus"] != null)
{
model.GoodsSiteStatus = row["GoodsSiteStatus"].ToString();
}
if (row["GoodsSiteOperate"] != null)
{
model.GoodsSiteOperate = row["GoodsSiteOperate"].ToString();
}
if (row["Reserve"] != null)
{
model.Reserve = row["Reserve"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(AsrsStorDBAcc.Model.GoodsSiteModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(AsrsStorDBAcc.Model.GoodsSiteModel model)
{
return(dal.Add(model));
}
