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