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);
}
public bool DU_Device_UpdateOne(DU_Device newOne)
{
return(SQL_da_DU_Device.UpdateOne(newOne));
}
public bool DU_Device_InsertOne(DU_Device newOne)
{
return(SQL_da_DU_Device.InsertNew(newOne));
}
/// <summary>
/// 插入一条数据
/// </summary>
/// <param name="t_new"></param>
/// <returns></returns>
public static bool InsertNew(DU_Device t_new)
{
try
{
DU_Device tt = t_new;
StringBuilder sb = new StringBuilder();
sb.Append(" Insert into DU_Device ( ");
sb.Append("DEVICEID, ");
sb.Append("DEVICENODEID, ");
sb.Append("DEVICESERVICEID, ");
sb.Append("DEVICENAME, ");
sb.Append("DEVICETYPE, ");
sb.Append("VOID, ");
sb.Append("WAREHOUSENO, ");
sb.Append("AISLE, ");
sb.Append("LINE, ");
sb.Append("SERVERIPADDRESS, ");
sb.Append("SERVERPORTNO, ");
sb.Append("IPADDRESS, ");
sb.Append("PORTNO, ");
sb.Append("SOCKETTYPE, ");
sb.Append("LOCALIPADDRESS, ");
sb.Append("LOCALPORTNO, ");
sb.Append("REMOTEIPADDRESS, ");
sb.Append("REMOTEPORTNO, ");
sb.Append("ISONLINE, ");
sb.Append("WORKINGSTATUS )");
sb.Append(" values ( ");
sb.Append("@DEVICEID,");
sb.Append("@DEVICENODEID,");
sb.Append("@DEVICESERVICEID,");
sb.Append("@DEVICENAME,");
sb.Append("@DEVICETYPE,");
sb.Append("@VOID,");
sb.Append("@WAREHOUSENO,");
sb.Append("@AISLE,");
sb.Append("@LINE,");
sb.Append("@SERVERIPADDRESS,");
sb.Append("@SERVERPORTNO,");
sb.Append("@IPADDRESS,");
sb.Append("@PORTNO,");
sb.Append("@SOCKETTYPE,");
sb.Append("@LOCALIPADDRESS,");
sb.Append("@LOCALPORTNO,");
sb.Append("@REMOTEIPADDRESS,");
sb.Append("@REMOTEPORTNO,");
sb.Append("@ISONLINE,");
sb.Append(" @WORKINGSTATUS )");
DbCommand cmd = new SqlCommand();
cmd.CommandText = sb.ToString();
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@DEVICEID", DbType.String)
{
Value = tt.DEVICEID
});
cmd.Parameters.Add(new SqlParameter("@DEVICENODEID", DbType.String)
{
Value = tt.DEVICENODEID
});
cmd.Parameters.Add(new SqlParameter("@DEVICESERVICEID", DbType.String)
{
Value = tt.DEVICESERVICEID
});
cmd.Parameters.Add(new SqlParameter("@DEVICENAME", DbType.String)
{
Value = tt.DEVICENAME
});
cmd.Parameters.Add(new SqlParameter("@DEVICETYPE", DbType.String)
{
Value = tt.DEVICETYPE
});
cmd.Parameters.Add(new SqlParameter("@VOID", DbType.Int32)
{
Value = tt.VOID
});
cmd.Parameters.Add(new SqlParameter("@WAREHOUSENO", DbType.String)
{
Value = tt.WAREHOUSENO
});
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("@SERVERIPADDRESS", DbType.String)
{
Value = tt.SERVERIPADDRESS
});
cmd.Parameters.Add(new SqlParameter("@SERVERPORTNO", DbType.String)
{
Value = tt.SERVERPORTNO
});
cmd.Parameters.Add(new SqlParameter("@IPADDRESS", DbType.String)
{
Value = tt.IPADDRESS
});
cmd.Parameters.Add(new SqlParameter("@PORTNO", DbType.Int32)
{
Value = tt.PORTNO
});
cmd.Parameters.Add(new SqlParameter("@SOCKETTYPE", DbType.String)
{
Value = tt.SOCKETTYPE
});
cmd.Parameters.Add(new SqlParameter("@LOCALIPADDRESS", DbType.String)
{
Value = tt.LOCALIPADDRESS
});
cmd.Parameters.Add(new SqlParameter("@LOCALPORTNO", DbType.Int32)
{
Value = tt.LOCALPORTNO
});
cmd.Parameters.Add(new SqlParameter("@REMOTEIPADDRESS", DbType.String)
{
Value = tt.REMOTEIPADDRESS
});
cmd.Parameters.Add(new SqlParameter("@REMOTEPORTNO", DbType.Int32)
{
Value = tt.REMOTEPORTNO
});
cmd.Parameters.Add(new SqlParameter("@ISONLINE", DbType.Int32)
{
Value = tt.ISONLINE
});
cmd.Parameters.Add(new SqlParameter("@WORKINGSTATUS", DbType.String)
{
Value = tt.WORKINGSTATUS
});
foreach (DbParameter 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
{
return(false);
}
}
