public static Oilwell_monthModel Select(string yjh, string yearmonth) { string sql = "Select * from OIL_WELL_MONTH Where JH=@JH And NY=@NY"; OleDbParameter[] parameters = new OleDbParameter[2]; parameters[0] = new OleDbParameter("@JH", yjh); parameters[1] = new OleDbParameter("@NY", yearmonth); OleDbDataReader reader = DbHelperOleDb.ExecuteReader(sql, parameters); if (reader.HasRows == false) { return(null); } reader.Read(); Oilwell_monthModel data = new Oilwell_monthModel(); data.JH = yjh; data.NY = yearmonth; data.YCYL = reader["YCYL"].ToString(); data.LY = reader["LY"].ToString(); reader.Close(); reader.Dispose(); return(data); }
/// <summary> /// 导入word文档 /// </summary> /// <param name="tpj_name"></param> private void ImportWordFile(string tpj_name) { OpenFileDialog op = new OpenFileDialog(); op.RestoreDirectory = true; op.Filter = "Word(*.doc)|*.doc"; bool?b = op.ShowDialog(); StringBuilder sqlStr = new StringBuilder(); if (b == true) { MessageBoxResult result = MessageBox.Show("确定导入?", "提示", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { byte[] file = wordConvertByte(op.FileName); sqlStr.Append("select * from PC_XTPJ_REPORT where MC = '" + tpj_name + "'"); bool isExist = DbHelperOleDb.ExecuteReader(sqlStr.ToString()).HasRows; sqlStr.Clear(); if (isExist) { sqlStr.Append("Delete from PC_XTPJ_REPORT where MC = '" + tpj_name + "'"); DbHelperOleDb.ExecuteSql(sqlStr.ToString()); sqlStr.Clear(); } sqlStr.Append("INSERT INTO PC_XTPJ_REPORT (MC,XNBG) VALUES ('" + tpj_name + "',@XNBG)"); DbHelperOleDb.ExecuteSqlInsertImg(sqlStr.ToString(), file); MessageBox.Show("导入成功!"); } else { return; } } }
public static Waterwell_monthModel Select(string sjh, string yearmonth) { string sql = "Select * from WATER_WELL_MONTH Where JH=@JH And NY=@NY and zt=0"; OleDbParameter[] parameters = new OleDbParameter[2]; parameters[0] = new OleDbParameter("@JH", sjh); parameters[1] = new OleDbParameter("@NY", yearmonth); OleDbDataReader reader = DbHelperOleDb.ExecuteReader(sql, parameters); if (reader.HasRows == false) { return(null); } reader.Read(); Waterwell_monthModel data = new Waterwell_monthModel(); data.JH = sjh; data.NY = yearmonth; data.YZSL = reader["YZSL"].ToString(); data.YY = reader["YY"].ToString(); reader.Close(); reader.Dispose(); return(data); }
/// <summary> /// 判断数据库是否可以连接 /// </summary> /// <returns></returns> public bool UpdateSettings() { IDataReader reader = null; try { string sql = "select top 1 * from Settings"; reader = DbHelperOleDb.ExecuteReader(sql); if (reader.Read()) { reader.Close(); } return(true); } catch { if (reader != null) { reader.Close(); } return(false); } }
/// <summary> /// 得到规则ID以及回复类型 /// </summary> public int GetRuleIdAndResponseType(string strWhere, out int response_type) { int rule_id = 0; response_type = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,response_type from " + databaseprefix + "weixin_request_rule"); if (!string.IsNullOrEmpty(strWhere)) { strSql.Append(" where " + strWhere); } OleDbDataReader sr = DbHelperOleDb.ExecuteReader(strSql.ToString()); while (sr.Read()) { rule_id = int.Parse(sr["id"].ToString()); response_type = int.Parse(sr["response_type"].ToString()); } sr.Close(); return(rule_id); }