private static List <Query_Stored> DoQuery(string sql_str)
{
List <Query_Stored> rtn = new List <Query_Stored>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new Query_Stored();
#region 逐个赋值
p.WAREHOUSENO = DBHelper_SqlServer.GetDataValue <string>(dr, "WAREHOUSENO");
p.PLACEID = DBHelper_SqlServer.GetDataValue <string>(dr, "PLACEID");
p.CONTAINERID = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERID");
p.ITEMSKU = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMSKU");
p.ITEMDESC = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMDESC");
p.ITEMQTY = DBHelper_SqlServer.GetDataValue <decimal>(dr, "ITEMQTY");
#endregion
rtn.Add(p);
}
}
}
catch
{
}
return(rtn);
}
private static List <Device_Alert> DoQuery(string sql_str)
{
List <Device_Alert> rtn = new List <Device_Alert>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new Device_Alert();
#region 逐个赋值
p.ID = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
p.DEVICEID = DBHelper_SqlServer.GetDataValue <string>(dr, "DEVICEID");
p.ALERTID = DBHelper_SqlServer.GetDataValue <string>(dr, "ALERTID");
p.ALERTNAME = DBHelper_SqlServer.GetDataValue <string>(dr, "ALERTNAME");
p.CREATETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "CREATETIME");
p.FINISH_TIME = DBHelper_SqlServer.GetDataValue <string>(dr, "FINISH_TIME");
p.TIME_OF_DURATION = DBHelper_SqlServer.GetDataValue <string>(dr, "TIME_OF_DURATION");
p.SYSTEMFLAG = DBHelper_SqlServer.GetDataValue <string>(dr, "SYSTEMFLAG");
#endregion
rtn.Add(p);
}
}
}
catch
{
}
return(rtn);
}
private static List <IM_Container> DoQuery(string sql_str)
{
List <IM_Container> rtn = new List <IM_Container>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new IM_Container();
p.CONTAINERID = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERID");
p.CONTAINERDESC = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERDESC");
p.CONTAINERTYPE = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERTYPE");
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.VOID = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID");
p.STATUS = DBHelper_SqlServer.GetDataValue <int>(dr, "STATUS");
p.WAREHOUSENO = DBHelper_SqlServer.GetDataValue <string>(dr, "WAREHOUSENO");
p.ONLINEMODEL = DBHelper_SqlServer.GetDataValue <string>(dr, "ONLINEMODEL");
p.UPDATETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
p.UPDATEUSER = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATEUSER");
rtn.Add(p);
}
}
}
catch (Exception ex)
{
}
return(rtn);
}
private static List <MODULE_VS_GROUP> DoQuery(string sql_str)
{
List <MODULE_VS_GROUP> rtn = new List <MODULE_VS_GROUP>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new MODULE_VS_GROUP();
p.ID = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
p.GROUP_NAME = DBHelper_SqlServer.GetDataValue <string>(dr, "GROUP_NAME");
p.GROUP_DESC = DBHelper_SqlServer.GetDataValue <string>(dr, "GROUP_DESC");
p.MODULE_ID = DBHelper_SqlServer.GetDataValue <string>(dr, "MODULE_ID");
p.MODULE_NAME = DBHelper_SqlServer.GetDataValue <string>(dr, "MODULE_NAME");
rtn.Add(p);
}
}
}
catch
{
}
return(rtn);
}
private static List <MODULE> DoQuery(string sql_str)
{
List <MODULE> rtn = new List <MODULE>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new MODULE();
p.ID = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
p.MODULE_NAME = DBHelper_SqlServer.GetDataValue <string>(dr, "MODULE_NAME");
p.MODULE_DESCRIBE = DBHelper_SqlServer.GetDataValue <string>(dr, "MODULE_DESCRIBE");
p.TAGNAME = DBHelper_SqlServer.GetDataValue <string>(dr, "TAGNAME");
p.STATUS = DBHelper_SqlServer.GetDataValue <string>(dr, "STATUS");
rtn.Add(p);
}
}
}
catch
{
}
return(rtn);
}
private static List <PW_User> DoQuery(string sql_str)
{
List <PW_User> rtn = new List <PW_User>();
DBHelper DBHelper_SqlServer = new DBLink();
try
{
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new PW_User();
p.ID = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
p.USERNAME = DBHelper_SqlServer.GetDataValue <string>(dr, "USERNAME");
p.PASSWORD = DBHelper_SqlServer.GetDataValue <string>(dr, "PASSWORD");
p.USERGROUP = DBHelper_SqlServer.GetDataValue <string>(dr, "USERGROUP");
p.DEPARTMENT = DBHelper_SqlServer.GetDataValue <string>(dr, "DEPARTMENT");
p.UPDATETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
p.PASSWORDUPDATETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "PASSWORDUPDATETIME");
p.PASSWORDEXPIRETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "PASSWORDEXPIRETIME");
p.LASTLOGINTIME = DBHelper_SqlServer.GetDataValue <string>(dr, "LASTLOGINTIME");
p.ISLOGININ = DBHelper_SqlServer.GetDataValue <string>(dr, "ISLOGININ");
p.HANDSHAKE = DBHelper_SqlServer.GetDataValue <string>(dr, "HANDSHAKE");
p.PW_BACKUP1 = DBHelper_SqlServer.GetDataValue <string>(dr, "PW_BACKUP1");
p.PW_BACKUP2 = DBHelper_SqlServer.GetDataValue <string>(dr, "PW_BACKUP2");
p.PW_BACKUP3 = DBHelper_SqlServer.GetDataValue <string>(dr, "PW_BACKUP3");
rtn.Add(p);
}
}
}
catch
{
}
return(rtn);
}
private static List <OD_Task> DoQuery(string sql_str)
{
List <OD_Task> rtn = new List <OD_Task>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new OD_Task();
#region 逐个赋值
p.TASKID = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKID");
p.TASKNAME = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKNAME");
p.DODEVICEID = DBHelper_SqlServer.GetDataValue <string>(dr, "DODEVICEID");
p.DODEVICENODEID = DBHelper_SqlServer.GetDataValue <string>(dr, "DODEVICENODEID");
p.DODEVICETYPE = DBHelper_SqlServer.GetDataValue <string>(dr, "DODEVICETYPE");
p.TASKTYPE = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKTYPE");
p.TASKLEVEL = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKLEVEL");
p.TASKSTATUS = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKSTATUS");
p.TASKCONTENTSTRING = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKCONTENTSTRING");
p.TASKTYPEDESCRIPTION = DBHelper_SqlServer.GetDataValue <string>(dr, "TASKTYPEDESCRIPTION");
p.CONTAINERNO = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERNO");
p.SOURCEPLACE = DBHelper_SqlServer.GetDataValue <string>(dr, "SOURCEPLACE");
p.TOPLACE = DBHelper_SqlServer.GetDataValue <string>(dr, "TOPLACE");
p.ORDERDETAILSID = DBHelper_SqlServer.GetDataValue <string>(dr, "ORDERDETAILSID");
p.ORDERHEADID = DBHelper_SqlServer.GetDataValue <string>(dr, "ORDERHEADID");
p.SENDTIMES = DBHelper_SqlServer.GetDataValue <int>(dr, "SENDTIMES");
p.RELEASESTATUS = DBHelper_SqlServer.GetDataValue <string>(dr, "RELEASESTATUS");
p.HADFINISH = DBHelper_SqlServer.GetDataValue <string>(dr, "HADFINISH");
p.VOID = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID");
p.UPDATETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
p.UPDATEUSER = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATEUSER");
p.WAREHOUSENO = DBHelper_SqlServer.GetDataValue <string>(dr, "WAREHOUSENO");
p.ISCURRENTTASK = DBHelper_SqlServer.GetDataValue <string>(dr, "ISCURRENTTASK");
p.INPUTLOCATIONLEVEL = DBHelper_SqlServer.GetDataValue <int>(dr, "INPUTLOCATIONLEVEL");
p.ISLASTTASK = DBHelper_SqlServer.GetDataValue <string>(dr, "ISLASTTASK");
p.ISEMPTYCONTAINER = DBHelper_SqlServer.GetDataValue <string>(dr, "ISEMPTYCONTAINER");
#endregion
rtn.Add(p);
}
}
}
catch
{
}
return(rtn);
}
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>
/// 获取被锁定库位
/// </summary>
/// <returns></returns>
public static List <string> GetLockedPlace()
{
string getstr = "";
List <string> LockedPlace = new List <string>();
StringBuilder sb = new StringBuilder();
sb.Append(" select distinct placeid from PL_Place where islock='1'");
getstr = sb.ToString();
DBHelper DBHelper_SqlServer = new DBLink();
var rd = DBHelper_SqlServer.ExecuteReader(getstr);
while (rd.Read())
{
LockedPlace.Add(rd["PLACEID"].ToString());
}
return(LockedPlace);
}
private static List <IM_Item> DoQuery(string sql_str)
{
List <IM_Item> rtn = new List <IM_Item>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
{
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new IM_Item();
p.SKU = DBHelper_SqlServer.GetDataValue <string>(dr, "SKU");
p.SKUDESC = DBHelper_SqlServer.GetDataValue <string>(dr, "SKUDESC");
p.BARCODE = DBHelper_SqlServer.GetDataValue <string>(dr, "BARCODE");
p.EANCODE = DBHelper_SqlServer.GetDataValue <string>(dr, "EANCODE");
p.COMPATIBLECODE = DBHelper_SqlServer.GetDataValue <string>(dr, "COMPATIBLECODE");
p.SPEC = DBHelper_SqlServer.GetDataValue <string>(dr, "SPEC");
p.ITEMCLASS = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMCLASS");
p.ABCCLASS = DBHelper_SqlServer.GetDataValue <string>(dr, "ABCCLASS");
p.UOM = DBHelper_SqlServer.GetDataValue <string>(dr, "UOM");
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.WEIGHT = DBHelper_SqlServer.GetDataValue <decimal>(dr, "WEIGHT");
p.SAVEQTY = DBHelper_SqlServer.GetDataValue <decimal>(dr, "SAVEQTY");
p.STORGELIFE = DBHelper_SqlServer.GetDataValue <string>(dr, "STORGELIFE");
p.VOID = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID");
p.UPDATETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
p.UPDATEUSER = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATEUSER");
p.ITEM_BK1 = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEM_BK1");
p.ITEM_BK2 = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEM_BK2");
p.ITEM_BK3 = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEM_BK3");
rtn.Add(p);
}
}
}
}
catch (Exception ex)
{
}
return(rtn);
}
private static List <DU_Device> DoQuery(string sql_str)
{
List <DU_Device> rtn = new List <DU_Device>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new DU_Device();
#region 逐个赋值
p.DEVICEID = DBHelper_SqlServer.GetDataValue <string>(dr, "DEVICEID");
p.DEVICENODEID = DBHelper_SqlServer.GetDataValue <string>(dr, "DEVICENODEID");
p.DEVICESERVICEID = DBHelper_SqlServer.GetDataValue <string>(dr, "DEVICESERVICEID");
p.DEVICENAME = DBHelper_SqlServer.GetDataValue <string>(dr, "DEVICENAME");
p.DEVICETYPE = DBHelper_SqlServer.GetDataValue <string>(dr, "DEVICETYPE");
p.VOID = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID");
p.WAREHOUSENO = DBHelper_SqlServer.GetDataValue <string>(dr, "WAREHOUSENO");
p.AISLE = DBHelper_SqlServer.GetDataValue <string>(dr, "AISLE");
p.LINE = DBHelper_SqlServer.GetDataValue <string>(dr, "LINE");
p.SERVERIPADDRESS = DBHelper_SqlServer.GetDataValue <string>(dr, "SERVERIPADDRESS");
p.SERVERPORTNO = DBHelper_SqlServer.GetDataValue <string>(dr, "SERVERPORTNO");
p.IPADDRESS = DBHelper_SqlServer.GetDataValue <string>(dr, "IPADDRESS");
p.PORTNO = DBHelper_SqlServer.GetDataValue <int>(dr, "PORTNO");
p.SOCKETTYPE = DBHelper_SqlServer.GetDataValue <string>(dr, "SOCKETTYPE");
p.LOCALIPADDRESS = DBHelper_SqlServer.GetDataValue <string>(dr, "LOCALIPADDRESS");
p.LOCALPORTNO = DBHelper_SqlServer.GetDataValue <int>(dr, "LOCALPORTNO");
p.REMOTEIPADDRESS = DBHelper_SqlServer.GetDataValue <string>(dr, "REMOTEIPADDRESS");
p.REMOTEPORTNO = DBHelper_SqlServer.GetDataValue <int>(dr, "REMOTEPORTNO");
p.ISONLINE = DBHelper_SqlServer.GetDataValue <int>(dr, "ISONLINE");
p.WORKINGSTATUS = DBHelper_SqlServer.GetDataValue <string>(dr, "WORKINGSTATUS");
#endregion
rtn.Add(p);
}
}
}
catch
{
}
return(rtn);
}
/// <summary>
/// 获取空库位
/// </summary>
/// <returns></returns>
public static List <string> GetEmptyPlace()
{
string getstr = "";
List <string> emptyplace = new List <string>();
StringBuilder sb;
sb = new StringBuilder();
sb.Append("select PlaceID from PL_PLACE where IsLock !='Y' and PLACEID not in (");
sb.Append(" select PLACEID from IV_PLACE_VS_CONTAINER)");
// sb.Append(" and PlaceID not in(select PlaceID from IV_place_vs_container) order by LayerNo,RowNo,ColumnNo");
DBHelper DBHelper_SqlServer = new DBLink();
getstr = sb.ToString();
var rd = DBHelper_SqlServer.ExecuteReader(getstr);
while (rd.Read())
{
emptyplace.Add(rd["PLACEID"].ToString());
}
return(emptyplace);
}
private static List <IV_container_vs_item> DoQuery(string sql_str)
{
List <IV_container_vs_item> rtn = new List <IV_container_vs_item>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new IV_container_vs_item();
p.ID = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
p.CONTAINERID = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERID");
p.ITEMSKU = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMSKU");
p.ITEMDESC = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMDESC");
p.ITEMBATCHNO = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMBATCHNO");
p.ITEMSTATUSNO = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMSTATUSNO");
p.ITEMQTY = DBHelper_SqlServer.GetDataValue <decimal>(dr, "ITEMQTY");
p.OCC_QTY = DBHelper_SqlServer.GetDataValue <decimal>(dr, "OCC_QTY");
p.WITHORDER = DBHelper_SqlServer.GetDataValue <string>(dr, "WITHORDER");
p.UPDATETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
p.UPDATEUSER = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATEUSER");
p.VOID = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID");
p.EXPIREDAY = DBHelper_SqlServer.GetDataValue <string>(dr, "EXPIREDAY");
p.CVI_BACKUP1 = DBHelper_SqlServer.GetDataValue <string>(dr, "CVI_BACKUP1");
p.CVI_BACKUP2 = DBHelper_SqlServer.GetDataValue <string>(dr, "CVI_BACKUP2");
p.CVI_BACKUP3 = DBHelper_SqlServer.GetDataValue <string>(dr, "CVI_BACKUP3");
rtn.Add(p);
}
}
}
catch (Exception ex)
{
}
return(rtn);
}
private static List <IV_place_vs_container> DoQuery(string sql_str)
{
List <IV_place_vs_container> rtn = new List <IV_place_vs_container>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new IV_place_vs_container();
#region 逐个赋值
p.ID = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
p.WAREHOUSENO = DBHelper_SqlServer.GetDataValue <string>(dr, "WAREHOUSENO");
p.PLACEID = DBHelper_SqlServer.GetDataValue <string>(dr, "PLACEID");
p.CONTAINERID = DBHelper_SqlServer.GetDataValue <string>(dr, "CONTAINERID");
p.UPDATETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
p.UPDATEUSER = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATEUSER");
p.VOID = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID");
p.ISEMPTYCONTAINER = DBHelper_SqlServer.GetDataValue <string>(dr, "ISEMPTYCONTAINER");
p.ISEMPTYPLACE = DBHelper_SqlServer.GetDataValue <string>(dr, "ISEMPTYPLACE");
p.PVC_BACKUP1 = DBHelper_SqlServer.GetDataValue <string>(dr, "PVC_BACKUP1");
p.PVC_BACKUP2 = DBHelper_SqlServer.GetDataValue <string>(dr, "PVC_BACKUP2");
p.PVC_BACKUP3 = DBHelper_SqlServer.GetDataValue <string>(dr, "PVC_BACKUP3");
#endregion
rtn.Add(p);
}
}
}
catch
{
}
return(rtn);
}