public static bool WriteAmmeterUsage(AmmeterUsage info)
{
try
{
var sql = string.Format("Insert into AMMETERUSAGE(USER_NO,CHECK_TIME,CHECK_VALUE) values('{0}',{1},{2})", info.USER_NO, info.CHECK_TIME, info.CHECK_VALUE);
ForwardLogger.Log(sql);
SQLiteCommand cmd = new SQLiteCommand(sql, _conn);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
ForwardLogger.Log(e.Message);
return(false);
}
}
public static DataSet LoadAmmeterUsage(string filter = "")
{
try
{
string sql = @"SELECT
a.USER_NO as [用户编号],
a.USER_NAME as [用户],
c.USER_KINDNAME as [用户类别],
b.CHECK_TIME as [时间],
b.CHECK_VALUE as [用电量],
a.USER_MODULE as [模块],
a.USER_COMPANY as [公司] ,
a.USER_STATION as [站],
a.USER_BUS as [段],
a.USER_LINENAME as [线],
a.USER_TRANSFORMER as [变压器],
a.USER_VIRTUALADDR as [虚拟地址],
a.USER_A1 as [A1],
a.USER_A2 as [A2]
FROM AMMETERINFO a,AMMETERUSAGE b ,DICUSERKIND c
WHERE a.USER_NO = b.USER_NO and a.USER_KIND = c.USER_KIND
ORDER BY b.USER_NO ,b.CHECK_TIME
".Replace(Environment.NewLine, " ");
ForwardLogger.Log(sql);
SQLiteCommand cmd = new SQLiteCommand(sql, _conn as SQLiteConnection);
cmd.CommandType = CommandType.Text;
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
adapter.SelectCommand = cmd;
DataSet ds = new DataSet("usage");
adapter.Fill(ds);
return(ds);
}
catch (Exception e)
{
ForwardLogger.Log(e.Message);
}
return(null);
}
private void button_OK_Click(object sender, EventArgs e)
{
try
{
var cmd = CreateInsertSql();
ForwardLogger.Log("run sql:" + cmd);
Debug.Write(cmd);
AmmeterDB.ExcuteSql(cmd);
//this.DialogResult = DialogResult.OK;
MessageBox.Show("添加成功");
if (this.chkKeepWWindow.Checked != true)
{
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public static List <P_AmmeterInfo> LoadAmmInfoFromDatabase()
{
var sql = "SELECT *,rowid from AMMETERINFO";
ForwardLogger.Log(sql);
SQLiteCommand cmd = new SQLiteCommand(sql, _conn as SQLiteConnection);
var reader = cmd.ExecuteReader();
List <P_AmmeterInfo> results = new List <P_AmmeterInfo>();
while (reader.Read())
{
P_AmmeterInfo info = new P_AmmeterInfo();
info.USER_COMPANY = DbDataConvert.ToString(reader["USER_COMPANY"]);
info.USER_STATION = DbDataConvert.ToString(reader["USER_STATION"]);
info.USER_LINE = DbDataConvert.ToInt32(reader["USER_LINE"]);
info.USER_BACKLINE = DbDataConvert.ToInt32(reader["USER_BACKLINE"]);
info.USER_LINENAME = DbDataConvert.ToString(reader["USER_LINENAME"]);
info.USER_TRANSFORMER = DbDataConvert.ToString(reader["USER_TRANSFORMER"]);
//info.USER_PHASE = DbDataConvert.ToInt16(reader["USER_PHASE"]);
info.USER_NAME = DbDataConvert.ToString(reader["USER_NAME"]);
info.USER_NO = DbDataConvert.ToString(reader["USER_NO"]);
info.USER_INITIALVAL = DbDataConvert.ToSingle(reader["USER_INITIALVAL"]);
info.USER_BUS = DbDataConvert.ToInt32(reader["USER_BUS"]);
info.USER_MODULE = DbDataConvert.ToString(reader["USER_MODULE"]);
info.USER_VIRTUALADDR = DbDataConvert.ToInt32(reader["USER_VIRTUALADDR"]);
info.USER_A1 = DbDataConvert.ToString(reader["USER_A1"]);
info.USER_A2 = DbDataConvert.ToString(reader["USER_A2"]);
info.USER_CDMA = (Tigera.T_Definition.P_AmmeterInfo.CDMA_TYPE)DbDataConvert.ToInt32(reader["USER_CDMA"]);
info.USER_KIND = (Tigera.T_Definition.P_AmmeterInfo.USER_KINDTYPE)DbDataConvert.ToInt32(reader["USER_KIND"]);
info.USER_SUBAMM = DbDataConvert.ToInt32(reader["USER_SUBAMM"]);
info.USER_SUBAMMMAC = DbDataConvert.ToInt32(reader["USER_SUBAMMMAC"]);
info.USER_CHANNEL = DbDataConvert.ToInt32(reader["USER_CHANNEL"]);
info.USER_PHASE = (Tigera.T_Definition.P_AmmeterInfo.Phase)DbDataConvert.ToInt32(reader["USER_PHASE"]);
info.USER_DEC_CNL = DbDataConvert.ToInt32(reader["USER_DEC_CNL"]);
info.ROWID = DbDataConvert.ToInt32(reader["ROWID"]);
results.Add(info);
}
return(results);
}