//分页获取三相数据 public static List <SanxiangData> GetDataList(int pageSize, int pageIndex) { string sql = "select * from sanxiang_data order by time desc"; try { DataTable dt = Factory.Execute().ExecuteTableByPage(pageSize, pageIndex, sql, CommandType.Text, null); List <SanxiangData> datas = new List <SanxiangData>(); int count = dt.Rows.Count; for (int i = 0; i < count; i++) { SanxiangData data = new SanxiangData(); data.Id = dt.Rows[0]["id"].ToString(); data.Watchdog_id = dt.Rows[0]["watchdog_id"].ToString(); data.Taiqu_id = dt.Rows[0]["taiqu_id"].ToString(); data.Time = DateTime.Parse(dt.Rows[0]["time"].ToString()); data.Voltage_a = float.Parse(dt.Rows[0]["voltage_a"].ToString()); data.Voltage_b = float.Parse(dt.Rows[0]["voltage_b"].ToString()); data.Voltage_c = float.Parse(dt.Rows[0]["voltage_c"].ToString()); data.Current_a = float.Parse(dt.Rows[0]["current_a"].ToString()); data.Current_b = float.Parse(dt.Rows[0]["current_b"].ToString()); data.Current_c = float.Parse(dt.Rows[0]["current_c"].ToString()); data.Current_n = float.Parse(dt.Rows[0]["current_n"].ToString()); data.Frequency = float.Parse(dt.Rows[0]["frequency"].ToString()); data.Active_power = float.Parse(dt.Rows[0]["active_power"].ToString()); data.Reactive_power = float.Parse(dt.Rows[0]["reactive_power"].ToString()); data.Apparent_power = float.Parse(dt.Rows[0]["apparent_power"].ToString()); data.Power_factor = float.Parse(dt.Rows[0]["power_factor"].ToString()); data.Active_electric_energy = float.Parse(dt.Rows[0]["active_electric_energy"].ToString()); data.Reactive_electric_energy = float.Parse(dt.Rows[0]["rective_electric_energy"].ToString()); data.Apparent_electric_energy = float.Parse(dt.Rows[0]["apparent_electric_energy"].ToString()); data.Voltage_unbalance = float.Parse(dt.Rows[0]["voltage_unbalance"].ToString()); data.Current_unbalance = float.Parse(dt.Rows[0]["current_unbalance"].ToString()); datas.Add(data); } return(datas); } catch (Exception e) { throw e; } }
//获取某三相数据 public static SanxiangData GetSanxiangDataByID(string dataID) { SanxiangData data = new SanxiangData(); string sql = "select * from sanxiang_data where id = @id"; SqlParameter[] para = new SqlParameter[1]; para[0] = new SqlParameter("@id", dataID); try { DataTable dt = Factory.Execute().ExecuteTable(sql, CommandType.Text, para); data.Id = dt.Rows[0]["id"].ToString(); data.Watchdog_id = dt.Rows[0]["watchdog_id"].ToString(); data.Taiqu_id = dt.Rows[0]["taiqu_id"].ToString(); data.Time = DateTime.Parse(dt.Rows[0]["time"].ToString()); data.Voltage_a = float.Parse(dt.Rows[0]["voltage_a"].ToString()); data.Voltage_b = float.Parse(dt.Rows[0]["voltage_b"].ToString()); data.Voltage_c = float.Parse(dt.Rows[0]["voltage_c"].ToString()); data.Current_a = float.Parse(dt.Rows[0]["current_a"].ToString()); data.Current_b = float.Parse(dt.Rows[0]["current_b"].ToString()); data.Current_c = float.Parse(dt.Rows[0]["current_c"].ToString()); data.Current_n = float.Parse(dt.Rows[0]["current_n"].ToString()); data.Frequency = float.Parse(dt.Rows[0]["frequency"].ToString()); data.Active_power = float.Parse(dt.Rows[0]["active_power"].ToString()); data.Reactive_power = float.Parse(dt.Rows[0]["reactive_power"].ToString()); data.Apparent_power = float.Parse(dt.Rows[0]["apparent_power"].ToString()); data.Power_factor = float.Parse(dt.Rows[0]["power_factor"].ToString()); data.Active_electric_energy = float.Parse(dt.Rows[0]["active_electric_energy"].ToString()); data.Reactive_electric_energy = float.Parse(dt.Rows[0]["rective_electric_energy"].ToString()); data.Apparent_electric_energy = float.Parse(dt.Rows[0]["apparent_electric_energy"].ToString()); data.Voltage_unbalance = float.Parse(dt.Rows[0]["voltage_unbalance"].ToString()); data.Current_unbalance = float.Parse(dt.Rows[0]["current_unbalance"].ToString()); return(data); } catch (Exception e) { throw e; } }
//添加三相数据 public static int Add(SanxiangData data) { string sql = "insert into sanxiang_data values (@id,@watchdog_id,@taiqu_id,@time,@voltage_a,@voltage_b,@voltage_c,@current_a,@current_b,@current_c,@current_n,@frequency,@active_power,@reactive_power,@apparent_power,@power_factor,@active_electric_energy,@reactive_electric_energy,@apparent_electric_energy,@voltage_unbalance,@currnet_unbalance)"; SqlParameter[] para = new SqlParameter[21]; para[0] = new SqlParameter("@id", data.Id); para[1] = new SqlParameter("@watchdog_id", data.Watchdog_id); para[2] = new SqlParameter("@taiqu_id", data.Taiqu_id); para[3] = new SqlParameter("@time", data.Time); para[4] = new SqlParameter("@voltage_a", data.Voltage_a); para[5] = new SqlParameter("@voltage_b", data.Voltage_b); para[6] = new SqlParameter("@voltage_c", data.Voltage_c); para[7] = new SqlParameter("@current_a", data.Current_a); para[8] = new SqlParameter("@current_b", data.Current_b); para[9] = new SqlParameter("@current_c", data.Current_c); para[10] = new SqlParameter("@current_n", data.Current_n); para[11] = new SqlParameter("@frequency", data.Frequency); para[12] = new SqlParameter("@active_power", data.Active_power); para[13] = new SqlParameter("@reactive_power", data.Reactive_power); para[14] = new SqlParameter("@apparent_power", data.Apparent_power); para[15] = new SqlParameter("@power_factor", data.Power_factor); para[16] = new SqlParameter("@active_electric_energy", data.Active_electric_energy); para[17] = new SqlParameter("@reactive_electric_energy", data.Reactive_electric_energy); para[18] = new SqlParameter("@apparent_electric_energy", data.Apparent_electric_energy); para[19] = new SqlParameter("@voltage_unbalance", data.Voltage_unbalance); para[20] = new SqlParameter("@currnet_ubbalance", data.Current_unbalance); try { return(Factory.Execute().ExecuteNonQuery(sql, CommandType.Text, para)); } catch (Exception e) { throw e; } }
//编辑三相数据 public static int Edit(SanxiangData data) { string sql = "update sanxiang_data set watchdog_id=@watchdog_id, taiqu_id=@taiqu_id,time=@time,voltage_a=@voltage_a,voltage_b=@voltage_b,voltage_c=@voltage_c,current_a=@current_a,current_b=@current_b,current_c=@current_c,current_n=@current_n,frequency=@frequency,active_power=@active_power,reactive_power=@reactive_power,apparent_power=apparent_power,power_factor=@power_factor,active_electric_energy=@active_electric_energy,reactive_electric_energy=@reactive_electric_energy,apparent_electric_energy=@apparent_electric_energy,voltage_unbalance=@voltage_unbalance,currnet_unbalance=@currnet_unbalance where id=@id)"; SqlParameter[] para = new SqlParameter[21]; para[0] = new SqlParameter("@id", data.Id); para[1] = new SqlParameter("@watchdog_id", data.Watchdog_id); para[2] = new SqlParameter("@taiqu_id", data.Taiqu_id); para[3] = new SqlParameter("@time", data.Time); para[4] = new SqlParameter("@voltage_a", data.Voltage_a); para[5] = new SqlParameter("@voltage_b", data.Voltage_b); para[6] = new SqlParameter("@voltage_c", data.Voltage_c); para[7] = new SqlParameter("@current_a", data.Current_a); para[8] = new SqlParameter("@current_b", data.Current_b); para[9] = new SqlParameter("@current_c", data.Current_c); para[10] = new SqlParameter("@current_n", data.Current_n); para[11] = new SqlParameter("@frequency", data.Frequency); para[12] = new SqlParameter("@active_power", data.Active_power); para[13] = new SqlParameter("@reactive_power", data.Reactive_power); para[14] = new SqlParameter("@apparent_power", data.Apparent_power); para[15] = new SqlParameter("@power_factor", data.Power_factor); para[16] = new SqlParameter("@active_electric_energy", data.Active_electric_energy); para[17] = new SqlParameter("@reactive_electric_energy", data.Reactive_electric_energy); para[18] = new SqlParameter("@apparent_electric_energy", data.Apparent_electric_energy); para[19] = new SqlParameter("@voltage_unbalance", data.Voltage_unbalance); para[20] = new SqlParameter("@currnet_unbalance", data.Current_unbalance); try { return(Factory.Execute().ExecuteNonQuery(sql, CommandType.Text, para)); } catch (Exception e) { throw e; } }