/// <summary>
/// 获取插入数据
/// </summary>
public bool Insert(DeviceOR device)
{
if (DataCountAdd(device) > 0)
{
throw new Exception("包含重复数据！");
}
string sql = @"insert into t_device (ID,DeviceTypeID,WindowNo,WindowType,DeviceModel,
ColNumber,RowNumber,
HostAddr,Address,Status,UpdateTime,CreateTime)
values ('@ID',@DeviceTypeID,'@WindowNo','@WindowType','@DeviceModel',
'@ColNumber','@RowNumber',
'@HostAddr','@Address',0,'@UpdateTime','@CreateTime')";
sql = sql.Replace("@ID", device.Id); //
sql = sql.Replace("@DeviceTypeID", device.Devicetypeid.ToString()); //
sql = sql.Replace("@WindowNo", device.Windowno); //
sql = sql.Replace("@WindowType", device.Windowtype); //
sql = sql.Replace("@DeviceModel", device.Devicemodel); //
sql = sql.Replace("@HostAddr", device.Hostaddr); //
sql = sql.Replace("@Address", device.Address); //
sql = sql.Replace("@Status", device.Status.ToString()); //
sql = sql.Replace("@ColNumber", device.ColNumber.HasValue? device.ColNumber.Value.ToString(): "");
sql = sql.Replace("@RowNumber", device.RowNumber.HasValue ? device.RowNumber.Value.ToString() : "");
sql = sql.Replace("@UpdateTime", device.Updatetime.ToString("yyyy-MM-dd HH:mm:ss")); //
sql = sql.Replace("@CreateTime", device.Createtime.ToString("yyyy-MM-dd HH:mm:ss")); //
return dbMySql.ExecuteNoQuery(sql) > 0;
}
public int DataCountAlter(DeviceOR mobj)
{
string sql = string.Format("select count(*) from t_device where DeviceTypeID={0} and (Windowno='{1}' or Address='{2}') and id<> '{3}'"
, mobj.Devicetypeid, mobj.Windowno, mobj.Address,mobj.Id);
if(mobj.Devicetypeid== DeviceType.DeviceType_ZP)
sql = string.Format("select count(*) from t_device where DeviceTypeID={0} and Address='{1}' and id<> '{2}'"
, mobj.Devicetypeid, mobj.Windowno, mobj.Address, mobj.Id);
try
{
int count = Convert.ToInt32(dbMySql.ExecuteScalar(sql).ToString());
return count;
}
catch (Exception ex)
{
throw ex;
}
}
private DeviceOR SetValue()
{
DeviceOR m_devi =new DeviceOR();
if (opType == "add")
m_devi.Id = Guid.NewGuid().ToString();
else
m_devi.Id = DeviceID;
m_devi.Devicetypeid = Devicetypeid;//
m_devi.Windowno = txtWindowno.Text;//
m_devi.Windowtype = txtWindowtype.Text;//
m_devi.Devicemodel = txtDevicemodel.Text;//
m_devi.Hostaddr = txtHostaddr.Text;//
m_devi.Address = txtAddress.Text;//
if (isTP)
{
m_devi.ColNumber = Convert.ToInt32(txtColNumber.Text);
}
return m_devi;
}
/// <summary>
/// 查询所有
/// </summary>
/// <returns></returns>
public List<DeviceOR> SelectAllDevices()
{
string sql = "select * from t_device";
DataTable dt = null;
try
{
dt = dbMySql.ExecuteQueryDataSet(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
List<DeviceOR> listDevi = new List<DeviceOR>();
foreach (DataRow dr in dt.Rows)
{
DeviceOR m_devi = new DeviceOR(dr);
listDevi.Add(m_devi);
}
return listDevi;
}
public bool Update(DeviceOR device)
{
if (DataCountAlter(device) > 0)
{
throw new Exception("包含重复数据！");
}
string sql = @"update t_device set WindowNo='@WindowNo'
,WindowType='@WindowType'
,DeviceModel='@DeviceModel'
,ColNumber='@ColNumber'
,RowNumber='@RowNumber'
,HostAddr='@HostAddr'
,Address='@Address'
,UpdateTime='@UpdateTime' where ID='@ID'";
sql = sql.Replace("@ID", device.Id); //
sql = sql.Replace("@DeviceTypeID", device.Devicetypeid.ToString()); //
sql = sql.Replace("@WindowNo", device.Windowno); //
sql = sql.Replace("@WindowType", device.Windowtype); //
sql = sql.Replace("@DeviceModel", device.Devicemodel); //
sql = sql.Replace("@HostAddr", device.Hostaddr); //
sql = sql.Replace("@Address", device.Address); //
sql = sql.Replace("@ColNumber", device.ColNumber.HasValue ? device.ColNumber.Value.ToString() : "");
sql = sql.Replace("@RowNumber", device.RowNumber.HasValue ? device.RowNumber.Value.ToString() : "");
sql = sql.Replace("@UpdateTime", device.Updatetime.ToString("yyyy-MM-dd HH:mm:ss")); //
return dbMySql.ExecuteNoQuery(sql) > 0;
}
public DeviceOR selectARowDate(string m_id)
{
string sql = string.Format("select * from t_device where Id='{0}'", m_id);
DataTable dt = null;
try
{
dt = dbMySql.ExecuteQueryDataSet(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
if (dt.Rows.Count == 0)
return null;
DataRow dr = dt.Rows[0];
DeviceOR m_devi = new DeviceOR(dr);
return m_devi;
}
