private bool UpdateSth(string strsql, SqlParameter[] paras)
{
using (SqlCommand cmd = new SqlCommand())
{
SqlConnection conn = DB2 <SqlConnection> .GetConnection(_sqlConnection);//Get_Connection();
SqlTransaction tr = null;
try
{
conn.Open();
tr = conn.BeginTransaction();
cmd.Connection = conn;
cmd.Transaction = tr;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strsql;
cmd.Parameters.AddRange(paras);
cmd.ExecuteNonQuery();
tr.Commit();
return(true);
}
catch (Exception ex)
{
if (tr != null)
{
tr.Rollback();
}
return(false);
}
finally
{
conn.Close();
}
}
}
private object FlushSth(string strsql, SqlParameter[] paras, string returnpara)
{
SqlConnection conn = DB2 <SqlConnection> .GetConnection(_sqlConnection);
object result = null;
if (conn != null)
{
try
{
using (SqlDataReader sr = DB_BLL.SQLHelp.ExecuteReader(conn, CommandType.Text, strsql, paras))
{
while (sr.Read())
{
result = sr[returnpara];
}
}
return(result);
}
catch (Exception ex)
{
return(null);
}
}
return(null);
}
private List <MainContract> Load_Contact(string filename)
{
List <MainContract> result = new List <MainContract>();
SqlConnection con = DB2 <SqlConnection> .GetConnection(Config["Connection"]["Conn"].Value);// Get_Connection();
string sql = Config["Sql"]["Load_Contract"].Value;
if (con != null)
{
try
{
using (SqlDataReader sr = DB_BLL.SQLHelp.ExecuteReader(con, CommandType.Text, sql, null))
{
while (sr.Read())
{
MainContract s = new MainContract(Convert.ToInt32(sr["CID"]), Convert.ToInt32(sr["area_id"]), sr["area_name"].ToString().Trim(),
sr["cust_name"].ToString().Trim(), sr["Address_Comment"].ToString().Trim(), sr["contract_name"].ToString().Trim(), myArray, Config["Connection"]["Conn"].Value);
string[] keys = s.SubSys.Keys.ToArray <string>();
foreach (string a in keys)
{
//此处获取子系统的合同号，用配置文件中的子系统名称-连接到配置数据库中的字段定义，再填到sql中
s.SubSys[a] = sr[Config["Generic"][a].Value].ToString().Trim();
}
result.Add(s);
}
}
return(result);
}
catch (Exception ex)
{
return(null);
}
}
return(null);
}
public new List <Clock> GetList()
{
List <Clock> result = new List <Clock>();
DbConnection con = null;
DbDataReader sr = null;
string sql = Config["Sql"]["Load_Clock"].Value;
if (Config["Connection"]["Type"].Value == "Sqlserver")
{
con = DB2 <SqlConnection> .GetConnection(Config["Connection"]["Conn"].Value);
sr = DB_BLL.SQLHelp.ExecuteReader((SqlConnection)con, CommandType.Text, sql, null);
}
if (Config["Connection"]["Type"].Value == "Oracle")
{
con = DB2 <OracleConnection> .GetConnection(Config["Connection"]["Conn"].Value);
sr = DB_BLL.OraHelp.ExecuteReader((OracleConnection)con, CommandType.Text, sql, null);
}
if (con != null)
{
try
{
while (sr.Read())
{
if (Convert.ToInt64(sr["本次用量"]) > 0)
{
Clock s = new Clock();
s.Sy_con_id = sr["合同编号"].ToString().Trim();
s.Sy_Addr_Id = sr["资源编号"].ToString().Trim();
s.Clock_name = sr["表名"].ToString().Trim();
s.Lmrd = Convert.ToInt64(Convert.ToDouble(sr["上次抄表数"].ToString()));
s.Tmrd = Convert.ToInt64(Convert.ToDouble(sr["本次抄表数"].ToString()));
s.Current_use = Convert.ToInt64(Convert.ToDouble(sr["本次用量"]));
s.Ldate = Convert.ToDateTime(sr["上次抄表时间"]);
s.Rdate = Convert.ToDateTime(sr["本次抄表时间"]);
s.Clock_type = Convert.ToString(sr["表类型"]);
s.Account_Date = Convert.ToString(sr["所属账期"]);
s.Address = sr["室号"].ToString().Trim();
result.Add(s);
}
}
sr.Close();
con.Close();
con.Dispose();
return(result);
}
catch (Exception ex)
{
return(null);
}
finally
{
sr.Close();
con.Close();
con.Dispose();
}
}
return(null);
}
private List <SysTicket> Load_Contact()
{
List <SysTicket> result = new List <SysTicket>();
DbConnection con = null;
DbDataReader sr = null;
string sql = Config["Sql"]["Load_Bill"].Value;
if (Config["Connection"]["Type"].Value == "Sqlserver")
{
con = DB2 <SqlConnection> .GetConnection(Config["Connection"]["Conn"].Value);// Get_SqlConnection();
sr = DB_BLL.SQLHelp.ExecuteReader((SqlConnection)con, CommandType.Text, sql, null);
}
if (Config["Connection"]["Type"].Value == "Oracle")
{
//con = Get_OracleConnection();
con = DB2 <OracleConnection> .GetConnection(Config["Connection"]["Conn"].Value);
sr = DB_BLL.OraHelp.ExecuteReader((OracleConnection)con, CommandType.Text, sql, null);
}
if (con != null)
{
try
{
while (sr.Read())
{
SysTicket s = new SysTicket();
s.Fee_name = sr["收费项目"].ToString().Trim();
s.Contract_id = sr["合同编号"].ToString().Trim();
s.Fee = Convert.ToDouble(sr["本金欠收"].ToString());
s.Account_Date = sr["所属账期"].ToString(); //yyyy-mm;
s.Data_start = Convert.ToDateTime(sr["应收期间开始日期"]);
s.Data_end = Convert.ToDateTime(sr["应收期间结束日期"]);
s.Addrss_id = "";
result.Add(s);
}
sr.Close();
con.Close();
con.Dispose();
return(result);
}
catch
{
return(null);
}
finally
{
sr.Close();
con.Close();
con.Dispose();
}
}
return(null);
}
private List <Sys_Contract> Load_Contact()
{
List <Sys_Contract> result = new List <Sys_Contract>();
DbConnection con = null;
DbDataReader sr = null;
string sql = Config["Sql"]["Load_Contract"].Value;
if (Config["Connection"]["Type"].Value == "Sqlserver")
{
con = DB2 <SqlConnection> .GetConnection(Config["Connection"]["Conn"].Value);//Get_SqlConnection();
sr = DB_BLL.SQLHelp.ExecuteReader((SqlConnection)con, CommandType.Text, sql, null);
}
if (Config["Connection"]["Type"].Value == "Oracle")
{
con = DB2 <OracleConnection> .GetConnection(Config["Connection"]["Conn"].Value);//Get_OracleConnection();
sr = DB_BLL.OraHelp.ExecuteReader((OracleConnection)con, CommandType.Text, sql, null);
}
if (con != null)
{
try
{
while (sr.Read())
{
Sys_Contract s = new Sys_Contract(Config["Generic"]["Sys_Name"].Value);
s.Cust_Name = sr["客户名称"].ToString().Trim();
s.ContractCode = sr["合同编号"].ToString().Trim();
s.Add_id = sr["资源编号"].ToString().Trim();
s.Add_name = sr["租用单元"].ToString().Trim();
result.Add(s);
}
sr.Close();
con.Close();
con.Dispose();
return(result);
}
catch
{
return(null);
}
finally
{
sr.Close();
con.Close();
con.Dispose();
}
}
return(null);
}