//分页获取三相数据
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;
}
}
