private static List <PL_Place> DoQuery(string sql_str)
{
List <PL_Place> rtn = new List <PL_Place>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new PL_Place();
#region 逐个赋值
p.PLACEID = DBHelper_SqlServer.GetDataValue <string>(dr, "PLACEID");
p.PLACENODEID = DBHelper_SqlServer.GetDataValue <string>(dr, "PLACENODEID");
p.PLACETYPE = DBHelper_SqlServer.GetDataValue <string>(dr, "PLACETYPE");
p.PLACEAREA = DBHelper_SqlServer.GetDataValue <string>(dr, "PLACEAREA");
p.ROWNO = DBHelper_SqlServer.GetDataValue <string>(dr, "ROWNO");
p.COLUMNNO = DBHelper_SqlServer.GetDataValue <string>(dr, "COLUMNNO");
p.LAYERNO = DBHelper_SqlServer.GetDataValue <string>(dr, "LAYERNO");
p.DEEPCELLNO = DBHelper_SqlServer.GetDataValue <string>(dr, "DEEPCELLNO");
p.AISLE = DBHelper_SqlServer.GetDataValue <string>(dr, "AISLE");
p.LINE = DBHelper_SqlServer.GetDataValue <string>(dr, "LINE");
p.AISLESIDE = DBHelper_SqlServer.GetDataValue <string>(dr, "AISLESIDE");
p.ISLOCK = DBHelper_SqlServer.GetDataValue <string>(dr, "ISLOCK");
p.ISFULL = DBHelper_SqlServer.GetDataValue <string>(dr, "ISFULL");
p.HASTASKDOING = DBHelper_SqlServer.GetDataValue <string>(dr, "HASTASKDOING");
p.WAREHOUSENO = DBHelper_SqlServer.GetDataValue <string>(dr, "WAREHOUSENO");
p.POSITIONNO_FOR_SRM = DBHelper_SqlServer.GetDataValue <string>(dr, "POSITIONNO_FOR_SRM");
p.X = DBHelper_SqlServer.GetDataValue <string>(dr, "X");
p.Y = DBHelper_SqlServer.GetDataValue <string>(dr, "Y");
p.Z = DBHelper_SqlServer.GetDataValue <string>(dr, "Z");
p.LENGTH = DBHelper_SqlServer.GetDataValue <decimal>(dr, "LENGTH");
p.WIDTH = DBHelper_SqlServer.GetDataValue <decimal>(dr, "WIDTH");
p.HEIGHT = DBHelper_SqlServer.GetDataValue <decimal>(dr, "HEIGHT");
p.MAXWEIGHT = DBHelper_SqlServer.GetDataValue <decimal>(dr, "MAXWEIGHT");
p.HEIGHTLEVEL = DBHelper_SqlServer.GetDataValue <string>(dr, "HEIGHTLEVEL");
p.PRIORITY = DBHelper_SqlServer.GetDataValue <int>(dr, "PRIORITY");
p.AREA_LOGIC = DBHelper_SqlServer.GetDataValue <string>(dr, "AREA_LOGIC");
#endregion
rtn.Add(p);
}
}
}
catch
{
}
return(rtn);
}
/// <summary>
/// 检测货位号是否放置了货物。有，则返回false，无有东西则返回true
/// </summary>
/// <param name="placeID"></param>
/// <returns></returns>
public static bool CheckPlaceEmpty(string placeID)
{
string getstr = string.Format("select * from PL_place where PlaceID='" + placeID + "'");
List <PL_Place> lisPlace = DoQuery(getstr);
if (lisPlace.Count > 0)
{
PL_Place p = lisPlace[0];
if (p.ISFULL == "Y")
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
/// <summary>
/// 更新某条数据
/// </summary>
/// <param name="t_new"></param>
/// <returns></returns>
public static bool UpdateOne(PL_Place t_new)
{
try
{
PL_Place tt = t_new;
StringBuilder sb = new StringBuilder();
sb.Append(" update PL_PLACE set ");
sb.Append("PLACENODEID=@PLACENODEID, ");
sb.Append("PLACETYPE=@PLACETYPE, ");
sb.Append("PLACEAREA=@PLACEAREA, ");
sb.Append("ROWNO=@ROWNO, ");
sb.Append("COLUMNNO=@COLUMNNO, ");
sb.Append("LAYERNO=@LAYERNO, ");
sb.Append("DEEPCELLNO=@DEEPCELLNO, ");
sb.Append("AISLE=@AISLE, ");
sb.Append("LINE=@LINE, ");
sb.Append("AISLESIDE=@AISLESIDE, ");
sb.Append("ISLOCK=@ISLOCK, ");
sb.Append("ISFULL=@ISFULL, ");
sb.Append("HASTASKDOING=@HASTASKDOING, ");
sb.Append("WAREHOUSENO=@WAREHOUSENO, ");
sb.Append("POSITIONNO_FOR_SRM=@POSITIONNO_FOR_SRM, ");
sb.Append("X=@X, ");
sb.Append("Y=@Y, ");
sb.Append("Z=@Z, ");
sb.Append("LENGTH=@LENGTH, ");
sb.Append("WIDTH=@WIDTH, ");
sb.Append("HEIGHT=@HEIGHT, ");
sb.Append("MAXWEIGHT=@MAXWEIGHT, ");
sb.Append("HEIGHTLEVEL=@HEIGHTLEVEL, ");
sb.Append("PRIORITY=@PRIORITY, ");
sb.Append("AREA_LOGIC=@AREA_LOGIC ");
sb.Append(" where PLACEID=@PLACEID ");
DbCommand cmd = new SqlCommand();
cmd.CommandText = sb.ToString();
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@PLACENODEID", DbType.String)
{
Value = tt.PLACENODEID
});
cmd.Parameters.Add(new SqlParameter("@PLACETYPE", DbType.String)
{
Value = tt.PLACETYPE
});
cmd.Parameters.Add(new SqlParameter("@PLACEAREA", DbType.String)
{
Value = tt.PLACEAREA
});
cmd.Parameters.Add(new SqlParameter("@ROWNO", DbType.String)
{
Value = tt.ROWNO
});
cmd.Parameters.Add(new SqlParameter("@COLUMNNO", DbType.String)
{
Value = tt.COLUMNNO
});
cmd.Parameters.Add(new SqlParameter("@LAYERNO", DbType.String)
{
Value = tt.LAYERNO
});
cmd.Parameters.Add(new SqlParameter("@DEEPCELLNO", DbType.String)
{
Value = tt.DEEPCELLNO
});
cmd.Parameters.Add(new SqlParameter("@AISLE", DbType.String)
{
Value = tt.AISLE
});
cmd.Parameters.Add(new SqlParameter("@LINE", DbType.String)
{
Value = tt.LINE
});
cmd.Parameters.Add(new SqlParameter("@AISLESIDE", DbType.String)
{
Value = tt.AISLESIDE
});
cmd.Parameters.Add(new SqlParameter("@ISLOCK", DbType.String)
{
Value = tt.ISLOCK
});
cmd.Parameters.Add(new SqlParameter("@ISFULL", DbType.String)
{
Value = tt.ISFULL
});
cmd.Parameters.Add(new SqlParameter("@HASTASKDOING", DbType.String)
{
Value = tt.HASTASKDOING
});
cmd.Parameters.Add(new SqlParameter("@WAREHOUSENO", DbType.String)
{
Value = tt.WAREHOUSENO
});
cmd.Parameters.Add(new SqlParameter("@POSITIONNO_FOR_SRM", DbType.String)
{
Value = tt.POSITIONNO_FOR_SRM
});
cmd.Parameters.Add(new SqlParameter("@X", DbType.String)
{
Value = tt.X
});
cmd.Parameters.Add(new SqlParameter("@Y", DbType.String)
{
Value = tt.Y
});
cmd.Parameters.Add(new SqlParameter("@Z", DbType.String)
{
Value = tt.Z
});
cmd.Parameters.Add(new SqlParameter("@LENGTH", DbType.Decimal)
{
Value = tt.LENGTH
});
cmd.Parameters.Add(new SqlParameter("@WIDTH", DbType.Decimal)
{
Value = tt.WIDTH
});
cmd.Parameters.Add(new SqlParameter("@HEIGHT", DbType.Decimal)
{
Value = tt.HEIGHT
});
cmd.Parameters.Add(new SqlParameter("@MAXWEIGHT", DbType.Decimal)
{
Value = tt.MAXWEIGHT
});
cmd.Parameters.Add(new SqlParameter("@HEIGHTLEVEL", DbType.String)
{
Value = tt.HEIGHTLEVEL
});
cmd.Parameters.Add(new SqlParameter("@PRIORITY", DbType.Int32)
{
Value = tt.PRIORITY
});
cmd.Parameters.Add(new SqlParameter("@AREA_LOGIC", DbType.String)
{
Value = tt.AREA_LOGIC
});
cmd.Parameters.Add(new SqlParameter("@PLACEID", DbType.String)
{
Value = tt.PLACEID
});
foreach (SqlParameter p in cmd.Parameters)
{
p.IsNullable = true;
if (p.Value == null)
{
p.Value = DBNull.Value;
}
}
DBHelper DBHelper_SqlServer = new DBLink();
int val = DBHelper_SqlServer.ExecuteNonQuery(cmd);
if (val > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool PL_PLACE_UpdateNew(PL_Place t_new)
{
return(SQL_Da_PL_Place.UpdateOne(t_new));
}
public bool PL_PLACE_InsertNew(PL_Place t_new)
{
return(SQL_Da_PL_Place.InsertNew(t_new));
}
