/// <summary>
///
/// </summary>
private void UpdateRecord()
{
try
{
DBcon con = new DBcon();
SqlCommand cmd = new SqlCommand("UserUpdate", con.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@p_EditName", m_strEditUser);
cmd.Parameters.Add("@p_Name", txtUserName.Text.Trim());
cmd.Parameters.Add("@p_Password", txtPwd.Text);
cmd.Parameters.Add("@p_Description", txtDescription.Text.Trim());
SqlDataReader dr = cmd.ExecuteReader();
if (!dr.Read())
{
dr.Close();
return;
}
string UserID = dr["ID"].ToString().Trim();
int intUserID = Convert.ToInt32(UserID);
dr.Close();
cmd.Dispose();
//delete old funID
cmd = new SqlCommand("DELETE FROM WUserFunction WHERE UserID=" + intUserID, con.GetConnection());
cmd.ExecuteNonQuery();
cmd.Dispose();
for (int i = 0; i < cklPurview.Items.Count; i++)
{
if (cklPurview.GetItemChecked(i))
{
int intFunID = Convert.ToInt32(m_FunName2FunID[cklPurview.Items[i]].ToString());
//add userid -> codeID to UserFunction
cmd = new SqlCommand("UserFunctionAdd", con.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@p_UserID", intUserID);
cmd.Parameters.Add("@p_FunctionID", intFunID);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
}
catch (Exception ex)
{
// 2007.05.30
//
//MessageBox.Show("编辑用户失败！");
ExceptionHandler.Handle("编辑用户失败！", ex);
}
}
private void AddRecord()
{
try
{
con = new DBcon();
SqlCommand cmd = new SqlCommand("PointDataAdd", con.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@p_PointName", cmbPoint.Text.ToString().Trim());
cmd.Parameters.Add("@p_DT", m_DT);
cmd.Parameters.Add("@p_Temp1", m_Temp1);
cmd.Parameters.Add("@p_Temp2", m_Temp2);
cmd.Parameters.Add("@p_Flux", m_Flux);
cmd.Parameters.Add("@p_Heat", m_Heat);
cmd.Parameters.Add("@p_HeatAll", m_HeatAll);
cmd.Parameters.Add("@p_FluxAll1", m_FluxAll1);
cmd.Parameters.Add("@p_FluxAll2", m_FluxAll2);
cmd.Parameters.Add("@p_FluxInstant", m_FluxInstant);
cmd.Parameters.Add("@p_Description", txtDescription.Text.Trim());
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void Delete()
{
if (NoRecordDataGrid())
{
return;
}
int row = m_dataGrid.CurrentCell.RowNumber;
int col = 1;
string UserName = m_dataGrid[row, col].ToString().ToString().Trim();
if (UserName == null)
{
MessageBox.Show("请正确选择需要删除的数据行!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (MessageBox.Show("确定要删除该行数据?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
row = m_dataGrid.CurrentCell.RowNumber;
col = 0;
DBcon con = new DBcon();
int id = Convert.ToInt32(m_dataGrid[row, col].ToString());
SqlCommand sqlCmd = new SqlCommand("DELETE FROM tbWUser WHERE ID=" + id, con.GetConnection());
sqlCmd.ExecuteNonQuery();
sqlCmd.Dispose();
RefreshDataGrid();
}
private void RefreshDataGrid()
{
try
{
if (!d_Type)
{
m_dataGrid.DataSource = ds.Tables[0].DefaultView;
this.Width = 170 + 90 * (ds.Tables[0].Columns.Count - 1);
}
else
{
DataTable dt = CreatTable();
DBcon con = new DBcon();
int z = 0;
string strName = "select name from v_HeatDatas group by name";
SqlDataAdapter daName = new SqlDataAdapter(strName, con.GetConnection());
DataSet dsName = new DataSet();
daName.Fill(dsName, "Name");
daName.Dispose();
for (int i = 0; i < dsName.Tables["Name"].Rows.Count; i++)
{
string str = "select top 1 name,team,time,oneBackTemp from v_HeatDatas where name='" + dsName.Tables["Name"].Rows[i]["name"].ToString() + "' order by time desc";
SqlDataAdapter da = new SqlDataAdapter(str, con.GetConnection());
DataSet dsOBT = new DataSet();
da.Fill(dsOBT, "table");
for (int j = 0; j < dsOBT.Tables["table"].Rows.Count; j++)
{
DataRow newrow = dt.NewRow();
dt.Rows.Add(newrow);
dt.Rows[z]["name"] = dsOBT.Tables["table"].Rows[j]["name"].ToString();
dt.Rows[z]["team"] = dsOBT.Tables["table"].Rows[j]["team"].ToString();
dt.Rows[z]["time"] = System.Convert.ToDateTime(dsOBT.Tables["table"].Rows[j]["time"].ToString());
dt.Rows[z]["oneBackTemp"] = System.Convert.ToDecimal(dsOBT.Tables["table"].Rows[j]["oneBackTemp"].ToString());
z = z + 1;
}
}
m_dataGrid.DataSource = dt;
this.Width = 184 + 90 * (dt.Columns.Count - 1);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void LoadDatas()
{
try
{
string str = "select * from tbl_HeatIndex order by outTemp desc";
SqlDataAdapter da = new SqlDataAdapter(str, con.GetConnection());
ds = new DataSet();
da.Fill(ds, "HeatIndex");
da.Dispose();
dt = ds.Tables["HeatIndex"];
m_dataGrid.DataSource = dt;
}
catch (Exception ex)
{
// 2007.05.30
//
//MessageBox.Show("参数读取错误");
ExceptionHandler.Handle("参数读取错误", ex);
}
}
private void LoadDataGrid()
{
try
{
DBcon con = new DBcon();
string str = "select * from tbWUser";
SqlCommand cmd = new SqlCommand(str, con.GetConnection());
cmd.ExecuteNonQuery();
cmd.Dispose();
SqlDataAdapter da = new SqlDataAdapter(str, con.GetConnection());
DataSet ds = new DataSet();
da.Fill(ds, "User");
da.Dispose();
this.m_dataGrid.DataSource = ds.Tables["User"];
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
///
/// </summary>
private void ReadStations()
{
try
{
dtEnd.Value = dtBegin.Value.AddDays(1);
string str =//"select Name from V_heatDatas Group by name"; //筛选以存站点
"select distinct name from tbl_gprs_station order by name";
SqlCommand cmd = new SqlCommand(str, con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
cmbStation.Items.Add(dr.GetValue(0).ToString());
}
dr.Close();
InitializeColor();
InitializeCurve();
ReadIndex();
}
catch (Exception ex)
{
// 2007.05.30
//
//MessageBox.Show("读取站点失败！");
ExceptionHandler.Handle("读取站点失败！", ex);
}
}
private void LoadStation()
{
string str = "select name from PointInfo";
con = new DBcon();
SqlCommand cmd = new SqlCommand(str, con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
cmbPoint.Items.Add(dr.GetValue(0).ToString().Trim());
}
dr.Close();
}
private void LoadStation()
{
dtDateDown.Value = dtDateUp.Value.AddDays(1);
string str = "select Name from V_heatDatas Group by name";
DBcon con = new DBcon();
SqlCommand cmd = new SqlCommand(str, con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
cmbID.Items.Add(dr.GetValue(0).ToString().Trim());
}
dr.Close();
m_PageCount = 1;
cmbID.Items.Add("<全部站点>");
}
private void ReadFunction()
{
try
{
dtEnd.Value = dtBegin.Value.AddDays(1);
string str = "select Name from V_heatDatas Group by name"; //筛选以存站点
DBcon con = new DBcon();
SqlCommand cmd = new SqlCommand(str, con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
cmbStation.Items.Add(dr.GetValue(0).ToString());
}
dr.Close();
InitializeColor();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void EditLoad()
{
DateTime dt;
try
{
con = new DBcon();
SqlCommand cmd = new SqlCommand("select * from v_PointData where id=@m_id", con.GetConnection());
cmd.Parameters.Add("@m_id", m_DataID);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
dt = System.Convert.ToDateTime(dr["DT"]);
dtDate.Value = dt.Date;
dtTime.Value = dt.Hour;
// dtDate.Value=System.Convert.ToDateTime(dr["DT"]);
cmbPoint.Text = dr["Name"].ToString();
txtDescription.Text = dr["Description"].ToString();
txtFlux.Text = dr["Flux"].ToString();
txtFluxAll1.Text = dr["FluxAll1"].ToString();
txtFluxAll2.Text = dr["FluxAll2"].ToString();
txtFulxInstant.Text = dr["FluxInstant"].ToString();
txtHeat.Text = dr["Heat"].ToString();
txtHeatAll.Text = dr["HeatAll"].ToString();
txtTemp1.Text = dr["Temp1"].ToString();
txtTemp2.Text = dr["Temp2"].ToString();
}
dr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
///
/// </summary>
private void ReadEditUserInfo()
{
try
{
txtUserName.Text = m_strEditUser;
DBcon con = new DBcon();
SqlCommand cmd = new SqlCommand("SELECT * FROM tbWUser WHERE Name='" + m_strEditUser + "'", con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
int intUserID;
if (!dr.Read())
{
dr.Close();
cmd.Dispose();
return;
}
intUserID = Convert.ToInt32(dr["ID"]);
txtPwd.Text = dr["Password"].ToString();
txtPwd2.Text = txtPwd.Text;
txtDescription.Text = dr["Description"].ToString().Trim();
dr.Close();
cmd.Dispose();
cmd = new SqlCommand("SELECT * FROM WUserFunction WHERE UserID=" + intUserID, con.GetConnection());
dr = cmd.ExecuteReader();
ArrayList arrFun = new ArrayList();
while (dr.Read())
{
arrFun.Add(dr["FunctionID"]);
}
dr.Close();
cmd.Dispose();
for (int i = 0; i < arrFun.Count; i++)
{
SetItemCheckedByFunID((int)arrFun[i]);
}
}
catch (Exception ex)
{
// 2007.05.30
//
//MessageBox.Show(ex.ToString());
ExceptionHandler.Handle(ex);
}
}
/// <summary>
///
/// </summary>
private void ReadFunction()
{
try
{
DBcon con = new DBcon();
SqlCommand cmd = new SqlCommand("SELECT * FROM tbWFunction ORDER BY ID", con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string FunName = dr["Name"].ToString().Trim();
cklPurview.Items.Add(FunName);
m_FunName2FunID.Add(FunName, (int)dr["id"]);
}
dr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
///
/// </summary>
/// <param name="UserName"></param>
/// <returns></returns>
private bool UserNameExist(string UserName)
{
DBcon con = new DBcon();
SqlCommand cmd = new SqlCommand("SELECT * FROM tbWUser WHERE Name='" + UserName.Trim() + "'", con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
bool bln = dr.Read();
dr.Close();
if (bln)
{
return(true);
}
else
{
return(false);
}
}
private void DrawCurve(string Station, string Curve, int Sign)
{
try
{
ds = new DataSet();
list = new PointPairList();
myPane.CurveList.Clear();
if (Curve != "")
{
myPane.Title = m_Begin.ToShortDateString() + "日 至" + m_End.ToShortDateString() + "日 " + Station + " " + Curve + " 趋势曲线图";
bolCurve = true;
}
else
{
myPane.Title = "趋势曲线图";
}
myPane.XAxis.Title = "时间";
myPane.YAxis.Title = "";
myPane.XAxis.Type = AxisType.Date;
myPane.XAxis.ScaleFontSpec.Size = 8;
myPane.YAxis.ScaleFontSpec.Size = 8;
string Yaxis;
if (Sign == 1)
{
for (int i = 0; i < lvCurve.Items.Count + 3; i++)
{
if (curveInfo[i].m_Chart == Curve)
{
chartInfo = curveInfo[i].m_Sqlname;
Yaxis = curveInfo[i].m_Y;
UStr = Yaxis;
DBcon con = new DBcon();
string str = "select " + chartInfo + ",time from V_heatDatas where Name='" + Station + "' and time between '" + m_Begin + "' and '" + m_End + "' order by time";
SqlCommand cmd = new SqlCommand(str, con.GetConnection());
SqlDataAdapter adp = new SqlDataAdapter(str, con.GetConnection());
adp.Fill(ds);
adp.Dispose();
SqlDataReader dr = cmd.ExecuteReader();
if (!dr.Read())
{
return;
}
while (dr.Read())
{
string time = dr.GetValue(1).ToString();
int yearlast = time.IndexOf("-", 0);
int monthlast = time.IndexOf("-", yearlast + 1);
int daylast = time.IndexOf(" ", monthlast + 1);
int hourlast = time.IndexOf(":", daylast + 1);
int minituelast = time.IndexOf(":", hourlast + 1);
string year = time.Substring(0, 4);
string month = time.Substring(yearlast + 1, monthlast - yearlast - 1);
string day = time.Substring(monthlast + 1, daylast - monthlast - 1);
string hour = time.Substring(daylast + 1, hourlast - daylast - 1);
string minitue = time.Substring(hourlast + 1, minituelast - hourlast - 1);
string second = time.Substring(minituelast + 1);
double x = new XDate(Convert.ToInt32(year), Convert.ToInt32(month), Convert.ToInt32(day), Convert.ToInt32(hour), Convert.ToInt32(minitue), Convert.ToInt32(second));
double y = System.Convert.ToDouble(dr.GetValue(0));
list.Add(x, y);
}
dr.Close();
myPane.YAxis.Title = Yaxis;
break;
}
}
LineItem myCurve = myPane.AddCurve(Curve, list, Color.Blue, SymbolType.Circle);
myCurve.Symbol.Fill = new Fill(Color.White);
myCurve.Symbol.Size = 3;
myPane.XAxis.Title = "时间（小时）";
myPane.AxisFill = new Fill(Color.White, Color.LightGray, 45F);
zgCurve.IsShowPointValues = true;
zgCurve.PointValueEvent += new ZedGraphControl.PointValueHandler(MyPointValueHandler);
zgCurve.AxisChange();
zgCurve.Invalidate();
}
else if (Sign == 2)
{
for (int i = 0; i < lvCurve.Items.Count; i++)
{
if (typeInfo[i].m_TName == Curve)
{
string cID = typeInfo[i].m_TNum;
string m_curve = "";
int z = 0;
for (int j = 0; j < curveInfo.Length; j++)
{
if (System.Convert.ToInt32(cID) < 3)
{
if (curveInfo[j].m_Type == cID || curveInfo[j].m_Type == "5")
{
list = new PointPairList();
chartInfo = curveInfo[j].m_Sqlname;
m_curve = m_curve + chartInfo + ",";
Yaxis = curveInfo[j].m_Y;
UStr = Yaxis;
DBcon con = new DBcon();
string str = "select " + chartInfo + ",time from V_heatDatas where Name='" + Station + "' and time between '" + m_Begin + "' and '" + m_End + "' order by time";
SqlCommand cmd = new SqlCommand(str, con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string time = dr.GetValue(1).ToString();
int yearlast = time.IndexOf("-", 0);
int monthlast = time.IndexOf("-", yearlast + 1);
int daylast = time.IndexOf(" ", monthlast + 1);
int hourlast = time.IndexOf(":", daylast + 1);
int minituelast = time.IndexOf(":", hourlast + 1);
string year = time.Substring(0, 4);
string month = time.Substring(yearlast + 1, monthlast - yearlast - 1);
string day = time.Substring(monthlast + 1, daylast - monthlast - 1);
string hour = time.Substring(daylast + 1, hourlast - daylast - 1);
string minitue = time.Substring(hourlast + 1, minituelast - hourlast - 1);
string second = time.Substring(minituelast + 1);
double x = new XDate(Convert.ToInt32(year), Convert.ToInt32(month), Convert.ToInt32(day), Convert.ToInt32(hour), Convert.ToInt32(minitue), Convert.ToInt32(second));
double y = System.Convert.ToDouble(dr.GetValue(0));
list.Add(x, y);
}
// break;
LineItem myCurve = myPane.AddCurve(curveInfo[j].m_Chart, list, m_Color[z], SymbolType.Circle);
myCurve.Symbol.Fill = new Fill(Color.White);
myCurve.Symbol.Size = 3;
myPane.XAxis.Title = "时间（小时）";
myPane.YAxis.Title = Yaxis;
myPane.AxisFill = new Fill(Color.White, Color.LightGray, 45F);
zgCurve.IsShowPointValues = true;
zgCurve.PointValueEvent += new ZedGraphControl.PointValueHandler(MyPointValueHandler);
zgCurve.AxisChange();
zgCurve.Invalidate();
z = ++z;
}
}
else
{
if (curveInfo[j].m_Type == cID)
{
list = new PointPairList();
chartInfo = curveInfo[j].m_Sqlname;
m_curve = m_curve + chartInfo + ",";
Yaxis = curveInfo[j].m_Y;
UStr = Yaxis;
DBcon con = new DBcon();
string str = "select " + chartInfo + ",time from V_heatDatas where Name='" + Station + "' and time between '" + m_Begin + "' and '" + m_End + "' order by time";
SqlCommand cmd = new SqlCommand(str, con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string time = dr.GetValue(1).ToString();
int yearlast = time.IndexOf("-", 0);
int monthlast = time.IndexOf("-", yearlast + 1);
int daylast = time.IndexOf(" ", monthlast + 1);
int hourlast = time.IndexOf(":", daylast + 1);
int minituelast = time.IndexOf(":", hourlast + 1);
string year = time.Substring(0, 4);
string month = time.Substring(yearlast + 1, monthlast - yearlast - 1);
string day = time.Substring(monthlast + 1, daylast - monthlast - 1);
string hour = time.Substring(daylast + 1, hourlast - daylast - 1);
string minitue = time.Substring(hourlast + 1, minituelast - hourlast - 1);
string second = time.Substring(minituelast + 1);
double x = new XDate(Convert.ToInt32(year), Convert.ToInt32(month), Convert.ToInt32(day), Convert.ToInt32(hour), Convert.ToInt32(minitue), Convert.ToInt32(second));
double y = System.Convert.ToDouble(dr.GetValue(0));
list.Add(x, y);
}
// break;
LineItem myCurve = myPane.AddCurve(curveInfo[j].m_Chart, list, m_Color[z], SymbolType.Circle);
myCurve.Symbol.Fill = new Fill(Color.White);
myCurve.Symbol.Size = 3;
myPane.XAxis.Title = "时间（小时）";
myPane.YAxis.Title = Yaxis;
myPane.AxisFill = new Fill(Color.White, Color.LightGray, 45F);
zgCurve.IsShowPointValues = true;
zgCurve.PointValueEvent += new ZedGraphControl.PointValueHandler(MyPointValueHandler);
zgCurve.AxisChange();
zgCurve.Invalidate();
z = ++z;
}
}
}
m_curve = m_curve + "time";
DBcon cond = new DBcon();
string strd = "select " + m_curve + " from V_heatDatas where Name='" + Station + "' and time between '" + m_Begin + "' and '" + m_End + "' order by time";
SqlDataAdapter adpd = new SqlDataAdapter(strd, cond.GetConnection());
adpd.Fill(ds);
}
}
}
lvCurve.SelectedItems.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
