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