/// <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; }