/// <summary>
/// 根据报表名称获取报表样式
/// </summary>
/// <param name="rptName">报表NAME</param>
/// <returns></returns>
public DataTable GetRptStyleByName(string rptName)
{
var query = "SELECT * FROM T_INFO_SISREPORT WHERE REPORTNAME='" + rptName + "'";
var errMsg = string.Empty;
var dt = new DataTable();
if (dbTypeValue == "SQL")
{
dt = DBsql.RunDataTable(query, out errMsg);
}
else if (dbTypeValue == "ORACLE")
{
dt = OracleHelper.Query(query).Tables[0];
}
else
{
dt = DBdb2.RunDataTable(query, out errMsg);
}
if (errMsg != string.Empty)
{
throw new Exception(errMsg);
}
else
{
return(dt);
}
}
/// <summary>
/// 通过报表名称，ORGID,TREEID获取报表样式
/// </summary>
/// <param name="rptName"></param>
/// <param name="treeId"></param>
/// <param name="orgId"></param>
/// <returns></returns>
public DataTable GetRptStyle(string rptId, string treeId, string orgId)
{
//var query = "SELECT * FROM T_INFO_SISREPORT WHERE REPORTNAME='" + rptName + "' AND ORGID='" + orgId +
// "' AND TREEID='" + treeId + "'";
var query = "";
//if(treeId !="" && orgId!="")
// query="SELECT * FROM T_INFO_SISREPORT WHERE reportid='" + rptId + "' AND ORGID='" + orgId +
// "' AND TREEID='" + treeId + "'";
//else
query = "SELECT * FROM T_INFO_SISREPORT WHERE reportid='" + rptId + "'";
var errMsg = string.Empty;
DataSet ds;
if (dbTypeValue == "SQL")
{
ds = DBsql.RunDataSet(query, out errMsg);
}
else if (dbTypeValue == "ORACLE")
{
ds = OracleHelper.Query(query);
}
else
{
ds = DBdb2.RunDataSet(query, out errMsg);
//dt = DBdb2.RunDataTable(query, out errMsg);
}
if (string.IsNullOrEmpty(errMsg))
{
return(ds.Tables[0] ?? new DataTable());
}
else
{
throw new Exception(errMsg);
}
}
public string rlmdwfrl(string repType, string qsrq, string jsrq, int unit, string bz)
{
string val = "";
if (repType == "值报")
{
string sql = "select 低位发热量 from 入炉煤质分析表 where 日期='" + qsrq + "' and 班值=" + bz;
object obj = DBsql.RunSingle(sql, out errMsg);
if (obj != null && obj.ToString() != "")
{
val = obj.ToString();
}
else
{
val = "0";
}
}
return(val);
}
/// <summary>
/// 根据报表ID获取报表样式
/// 所有的保存都在这一个方法里面，不区分insert或者update
/// </summary>
/// <param name="rptID">报表ID</param>
/// <returns></returns>
public DataTable GetRptStyleByID(string rptID)
{
var query = "SELECT * FROM T_INFO_SISREPORT WHERE REPORTID='" + rptID + "'";
var errMsg = string.Empty;
var dt = new DataTable();
if (dbTypeValue == "SQL")
{
dt = DBsql.RunDataTable(query, out errMsg);
}
else
{
dt = DBdb2.RunDataTable(query, out errMsg);
}
if (errMsg != string.Empty)
{
throw new Exception(errMsg);
}
else
{
return(dt);
}
}
public InvoiceDAL()
{
conn = DBsql.OpenConnection();
}
public string SaveRptStyle(ReportStyle rpt)
{
//要加入时间类型判断
var rptId = rpt.RptID;
var rptName = rpt.RptName;
var rptStyle = rpt.RptStyle;
var orgId = rpt.OrgId;
var treeId = rpt.TreeId;
var styleType = rpt.styleType;
string errMsg = string.Empty;
switch (dbTypeValue)
{
case "SQL":
{
var sqlInsert = "INSERT INTO T_INFO_SISREPORT(REPORTTYPE,REPORTID,REPORTNAME,REPORTSTYLE,ORGID,TREEID) VALUES(@p1,@p2,@p3,@p4,@p5,@p6)";
var sqlDelete = "DELETE FROM T_INFO_SISREPORT WHERE REPORTID=@p1 AND ORGID=@p2 AND TREEID=@p3";
using (var conn = new SqlConnection(DBsql.GetConnectionstr()))
{
conn.Open();
SqlTransaction transaction = conn.BeginTransaction();
var pDel = new[]
{
new SqlParameter("@p1", rptId),
new SqlParameter("@p2", orgId),
new SqlParameter("@p3", treeId)
};
var pIns = new[]
{
new SqlParameter("@p1", styleType),
new SqlParameter("@p2", rptId),
new SqlParameter("@p3", rptName),
new SqlParameter("@p4", rptStyle),
new SqlParameter("@p5", orgId),
new SqlParameter("@p6", treeId)
};
try
{
DBsql.ExecuteNonQuery(transaction, CommandType.Text, sqlDelete, pDel);
DBsql.ExecuteNonQuery(transaction, CommandType.Text, sqlInsert, pIns);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
errMsg = ex.Message;
}
}
}
break;
case "ORACLE":
{
//修改Oracle后按照SqlServer对照一次，否则出错
var sqlInsert = "INSERT INTO T_INFO_SISREPORT(REPORTID,REPORTNAME,REPORTSTYLE,ORGID,TREEID,REPORTTYPE) VALUES(:p1,:p2,:p3,:p4,:p5,:p6)";
var sqlDelete = "DELETE FROM T_INFO_SISREPORT WHERE REPORTNAME=:p1 AND ORGID=:p2 AND TREEID=:p3";
var pDel = new[]
{
new OracleParameter(":p1", rptName),
new OracleParameter(":p2", orgId),
new OracleParameter(":p3", treeId)
};
var pIns = new[]
{
new OracleParameter(":p1", rptId),
new OracleParameter(":p2", rptName),
new OracleParameter(":p3", rptStyle),
new OracleParameter(":p4", orgId),
new OracleParameter(":p5", treeId),
new OracleParameter(":p6", styleType)
};
using (var conn = new OracleConnection(OracleHelper.retStr()))
{
conn.Open();
var transaction = conn.BeginTransaction();
try
{
SAC.DBOperations.OracleHelper.ExecuteNonQuery(transaction, CommandType.Text, sqlDelete, pDel);
SAC.DBOperations.OracleHelper.ExecuteNonQuery(transaction, CommandType.Text, sqlInsert, pIns);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
errMsg = ex.Message;
}
}
}
break;
default: //db2
{
var sqlInsert = "INSERT INTO T_INFO_SISREPORT(REPORTID,REPORTNAME,REPORTSTYLE,ORGID,TREEID) VALUES(?,?,?,?,?)";
var sqlDelete = "DELETE FROM T_INFO_SISREPORT WHERE REPORTNAME=? AND ORGID=? AND TREEID=?";
var pDel = new[]
{
new OleDbParameter("?", rptName),
new OleDbParameter("?", orgId),
new OleDbParameter("?", treeId)
};
var pIns = new[]
{
new OleDbParameter("?", rptId),
new OleDbParameter("?", rptName),
new OleDbParameter("?", rptStyle),
new OleDbParameter("?", orgId),
new OleDbParameter("?", treeId)
};
using (var conn = DBdb2.GetConn())
{
conn.Open();
var transaction = conn.BeginTransaction();
try
{
DBdb2.ExecuteNonQuery(transaction, CommandType.Text, sqlDelete, pDel);
DBdb2.ExecuteNonQuery(transaction, CommandType.Text, sqlInsert, pIns);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
errMsg = ex.Message;
}
}
}
break;
}
return(errMsg);
}
/// <summary>
/// 入炉煤低位热值
/// </summary>
/// <param name="repType"></param>
/// <param name="qsrq"></param>
/// <param name="jsrq"></param>
/// <param name="unit"></param>
/// <returns></returns>
public string rlmdwfrl(string repType, string qsrq, string jsrq, int unit)
{
object objML1;
object objML2;
string val1 = "";
string val2 = "";
double res = 0;
string mon = "";
string re = "";
string dwfrl1 = "0";
string dwfrl2 = "0";
string dwfrl3 = "0";
string mz1ml1 = "0"; //煤量1
string mz1ml2 = "0";
string mz1ml3 = "0";
string mz2ml1 = "0"; //煤量2
string mz2ml2 = "0";
string mz2ml3 = "0";
string val = "";
if (repType == "值报")
{
string sql = "select * from 入炉煤质分析表 where 日期='" + qsrq + "'";
DataTable dtmt = dl.RunDataTable(sql, out errMsg);
if (dtmt.Rows.Count > 0)
{
if (dtmt.Rows.Count == 1)
{
mz1ml1 = dtmt.Rows[0]["煤量1"].ToString();
mz2ml1 = dtmt.Rows[0]["煤量2"].ToString();
dwfrl1 = dtmt.Rows[0]["低位发热量"].ToString();
}
else if (dtmt.Rows.Count == 2)
{
mz1ml1 = dtmt.Rows[0]["煤量1"].ToString();
mz1ml2 = dtmt.Rows[1]["煤量1"].ToString();
mz2ml1 = dtmt.Rows[0]["煤量2"].ToString();
mz2ml2 = dtmt.Rows[1]["煤量2"].ToString();
dwfrl1 = dtmt.Rows[0]["低位发热量"].ToString();
dwfrl2 = dtmt.Rows[1]["低位发热量"].ToString();
}
else if (dtmt.Rows.Count == 3)
{
mz1ml1 = dtmt.Rows[0]["煤量1"].ToString();
mz1ml2 = dtmt.Rows[1]["煤量1"].ToString();
mz1ml3 = dtmt.Rows[2]["煤量1"].ToString();
mz2ml1 = dtmt.Rows[0]["煤量2"].ToString();
mz2ml2 = dtmt.Rows[1]["煤量2"].ToString();
mz2ml3 = dtmt.Rows[2]["煤量2"].ToString();
dwfrl1 = dtmt.Rows[0]["低位发热量"].ToString();
dwfrl2 = dtmt.Rows[1]["低位发热量"].ToString();
dwfrl3 = dtmt.Rows[2]["低位发热量"].ToString();
}
}
}
else if (repType == "日报")
{
string sqlCmd = "SELECT 低位热值 FROM 入炉煤质日数据表 where 日期='" + Convert.ToDateTime(qsrq).ToShortDateString() + "'";
object objrlm = DBsql.RunSingle(sqlCmd, out errMsg);
if (objrlm == null)
{
string sql = "select * from 入炉煤质分析表 where 日期='" + qsrq + "'";
DataTable dtmt = DBsql.RunDataTable(sql, out errMsg);
#region
if (dtmt.Rows.Count > 0)
{
if (dtmt.Rows.Count == 1)
{
mz1ml1 = dtmt.Rows[0]["煤量1"].ToString();
mz2ml1 = dtmt.Rows[0]["煤量2"].ToString();
dwfrl1 = dtmt.Rows[0]["低位发热量"].ToString();
}
else if (dtmt.Rows.Count == 2)
{
mz1ml1 = dtmt.Rows[0]["煤量1"].ToString();
mz1ml2 = dtmt.Rows[1]["煤量1"].ToString();
mz2ml1 = dtmt.Rows[0]["煤量2"].ToString();
mz2ml2 = dtmt.Rows[1]["煤量2"].ToString();
dwfrl1 = dtmt.Rows[0]["低位发热量"].ToString();
dwfrl2 = dtmt.Rows[1]["低位发热量"].ToString();
}
else if (dtmt.Rows.Count == 3)
{
mz1ml1 = dtmt.Rows[0]["煤量1"].ToString();
mz1ml2 = dtmt.Rows[1]["煤量1"].ToString();
mz1ml3 = dtmt.Rows[2]["煤量1"].ToString();
mz2ml1 = dtmt.Rows[0]["煤量2"].ToString();
mz2ml2 = dtmt.Rows[1]["煤量2"].ToString();
mz2ml3 = dtmt.Rows[2]["煤量2"].ToString();
dwfrl1 = dtmt.Rows[0]["低位发热量"].ToString();
dwfrl2 = dtmt.Rows[1]["低位发热量"].ToString();
dwfrl3 = dtmt.Rows[2]["低位发热量"].ToString();
}
}
#endregion
try
{
mon = "((" + dwfrl1 + "*((" + mz1ml1 + ")+(" + mz2ml1 + ")))+(" + dwfrl2 + "*((" + mz1ml2 + ")+(" + mz2ml2 + ")))+(" + dwfrl3 + "*((" + mz1ml3 + ")+(" + mz2ml3 + "))))/((" + mz1ml1 + ") + (" + mz1ml2 + ") + (" + mz1ml3 + ")+(" + mz2ml1 + ") + (" + mz2ml2 + ") + (" + mz2ml3 + "))";
re = StrHelper.Cale(mon);
re = StrHelper.checkCatch(re);
res = double.Parse(re.ToString());
}
catch
{ res = 0; }
}
else
{
res = double.Parse(objrlm.ToString());
}
}
else if (repType == "月报" || repType == "年报")
{
string[] date = sh.DateDiff(DateTime.Parse(qsrq), DateTime.Parse(jsrq));
for (int i = 0; i < date.Length - 1; i++)
{
string sql = "SELECT SUM(低位热值) FROM 入炉煤质日数据表 where 日期>='" + DateTime.Parse(date[i]).ToString("yyyy-MM-dd 0:00:00") + "' and 日期<'" + DateTime.Parse(date[i]).ToString("yyyy-MM-dd 23:59:59") + "'";
object objrlm = dl.RunSingle(sql, out errMsg);
if (objrlm == null || objrlm.ToString() == "")
{
sql = "select * from 入炉煤质分析表 where 日期='" + DateTime.Parse(date[i]).ToString("yyyy-MM-dd 0:00:00") + "'";
DataTable dtmt = dl.RunDataTable(sql, out errMsg);
#region
if (dtmt.Rows.Count > 0)
{
if (dtmt.Rows.Count == 1)
{
mz1ml1 = dtmt.Rows[0]["煤量1"].ToString();
mz2ml1 = dtmt.Rows[0]["煤量2"].ToString();
dwfrl1 = dtmt.Rows[0]["低位发热量"].ToString();
}
else if (dtmt.Rows.Count == 2)
{
mz1ml1 = dtmt.Rows[0]["煤量1"].ToString();
mz1ml2 = dtmt.Rows[1]["煤量1"].ToString();
mz2ml1 = dtmt.Rows[0]["煤量2"].ToString();
mz2ml2 = dtmt.Rows[1]["煤量2"].ToString();
dwfrl1 = dtmt.Rows[0]["低位发热量"].ToString();
dwfrl2 = dtmt.Rows[1]["低位发热量"].ToString();
}
else if (dtmt.Rows.Count == 3)
{
mz1ml1 = dtmt.Rows[0]["煤量1"].ToString();
mz1ml2 = dtmt.Rows[1]["煤量1"].ToString();
mz1ml3 = dtmt.Rows[2]["煤量1"].ToString();
mz2ml1 = dtmt.Rows[0]["煤量2"].ToString();
mz2ml2 = dtmt.Rows[1]["煤量2"].ToString();
mz2ml3 = dtmt.Rows[2]["煤量2"].ToString();
dwfrl1 = dtmt.Rows[0]["低位发热量"].ToString();
dwfrl2 = dtmt.Rows[1]["低位发热量"].ToString();
dwfrl3 = dtmt.Rows[2]["低位发热量"].ToString();
}
}
#endregion
try
{
mon = "((" + dwfrl1 + "*((" + mz1ml1 + ")+(" + mz2ml1 + ")))+(" + dwfrl2 + "*((" + mz1ml2 + ")+(" + mz2ml2 + ")))+(" + dwfrl3 + "*((" + mz1ml3 + ")+(" + mz2ml3 + "))))/((" + mz1ml1 + ") + (" + mz1ml2 + ") + (" + mz1ml3 + ")+(" + mz2ml1 + ") + (" + mz2ml2 + ") + (" + mz2ml3 + "))";
re = StrHelper.Cale(mon);
re = StrHelper.checkCatch(re);
}
catch
{ re = "0"; }
string re1 = "";
try
{
mon = "((" + mz1ml1 + ") + (" + mz1ml2 + ") + (" + mz1ml3 + ")+(" + mz2ml1 + ") + (" + mz2ml2 + ") + (" + mz2ml3 + "))";
re1 = StrHelper.Cale(mon);
re1 = StrHelper.checkCatch(re1);
}
catch
{ re1 = "0"; }
val1 += "(" + re + "*" + re1 + ")+";
val2 += "(" + re1 + ")+";
}
else
{
sql = "select sum(煤量1)+sum(煤量2) from 入炉煤质分析表 where 日期='" + DateTime.Parse(date[i]).ToShortDateString() + "'";
objML1 = dl.RunSingle(sql, out errMsg);
val1 += "(" + objrlm.ToString() + "*" + objML1.ToString() + ")+";
val2 += "(" + objML1.ToString() + ")+";
}
}
val = "(" + val1.TrimEnd('+') + ")/(" + val2.TrimEnd('+') + ")";
try
{
re = StrHelper.Cale(val);
re = StrHelper.checkCatch(re);
}
catch { re = "0"; }
res = double.Parse(re);
}
return(res.ToString());
}
public staffDAL()
{
conn = DBsql.OpenConnection();
}
public bool EditMemberInfo(string userIDO, string userID, string userName, string pwd, byte[] img, string treeNodeId)
{
string rlDBType = dl.init();
string sql = "";
string errMsg = "";
bool result = false;
if (rlDBType == "SQL")
{
try
{
if (img != null)
{
SqlConnection sqlconn = SAC.DBOperations.DBsql.GetConnection();
if (userIDO == userID)
{
sql += "update T_SYS_MEMBERINFO set T_USERNAME=@T_USERNAME,T_PASSWD=@T_PASSWD,B_ATTACHMENT=@B_ATTACHMENT where T_USERID='" + userIDO + "'";
SqlCommand sqlcmd = new SqlCommand(sql, sqlconn);
sqlcmd.Parameters.Add("@T_USERNAME", userName);
sqlcmd.Parameters.Add("@T_PASSWD", pwd);
sqlcmd.Parameters.Add("@B_ATTACHMENT", img);
if (sqlcmd.ExecuteNonQuery() > 0)
{
result = true;
}
}
else
{
sql += "update T_SYS_MEMBERINFO set T_USERID=@T_USERID,T_USERNAME=@T_USERNAME,T_PASSWD=@T_PASSWD,B_ATTACHMENT=@B_ATTACHMENT where T_USERID='" + userIDO + "'";
SqlCommand sqlcmd = new SqlCommand(sql, sqlconn);
sqlcmd.Parameters.Add("@T_USERID", userID);
sqlcmd.Parameters.Add("@T_USERNAME", userName);
sqlcmd.Parameters.Add("@T_PASSWD", pwd);
sqlcmd.Parameters.Add("@B_ATTACHMENT", img);
result = DBsql.RunNonQuery("update T_SYS_MEMBERGRP set T_USERID='" + userID + "' where T_USERID='" + userIDO + "';", out errMsg);
if (sqlcmd.ExecuteNonQuery() > 0 && result == true)
{
result = true;
}
}
sqlconn.Close();
}
else
{
if (userIDO == userID)
{
sql += "update T_SYS_MEMBERINFO set T_USERNAME='******',T_PASSWD='" + pwd + "' where T_USERID='" + userIDO + "';";
}
else
{
sql += "update T_SYS_MEMBERINFO set T_USERID='" + userID + "',T_USERNAME='******',T_PASSWD='" + pwd + "' where T_USERID='" + userIDO + "';update T_SYS_MEMBERGRP set T_USERID='" + userID + "' where T_USERID='" + userIDO + "';";
}
result = dl.RunNonQuery(sql, out errMsg);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
}
else if (rlDBType == "DB2")
{
try
{
if (img != null)
{
OleDbConnection con = new OleDbConnection(DBdb2.SetConString());
con.Open();
if (userIDO == userID)
{
sql += "update T_SYS_MEMBERINFO set T_USERNAME=?,T_PASSWD=?,B_ATTACHMENT=? where T_USERID='" + userIDO + "'";
OleDbCommand oledbcom = new OleDbCommand(sql, con);
oledbcom.Parameters.Add("?", userName);
oledbcom.Parameters.Add("?", pwd);
oledbcom.Parameters.Add("?", img);
if (oledbcom.ExecuteNonQuery() > 0)
{
result = true;
}
}
else
{
sql += "update T_SYS_MEMBERINFO set T_USERID=?,T_USERNAME=?,T_PASSWD=?,B_ATTACHMENT=? where T_USERID='" + userIDO + "'";
OleDbCommand oledbcom = new OleDbCommand(sql, con);
oledbcom.Parameters.Add("?", userID);
oledbcom.Parameters.Add("?", userName);
oledbcom.Parameters.Add("?", pwd);
oledbcom.Parameters.Add("?", img);
result = DBdb2.RunNonQuery("update T_SYS_MEMBERGRP set T_USERID='" + userID + "' where T_USERID='" + userIDO + "';", out errMsg);
if (oledbcom.ExecuteNonQuery() > 0 && result == true)
{
result = true;
}
}
con.Close();
}
else
{
if (userIDO == userID)
{
sql += "update T_SYS_MEMBERINFO set T_USERNAME='******',T_PASSWD='" + pwd + "' where T_USERID='" + userIDO + "';";
}
else
{
sql += "update T_SYS_MEMBERINFO set T_USERID='" + userID + "',T_USERNAME='******',T_PASSWD='" + pwd + "' where T_USERID='" + userIDO + "';update T_SYS_MEMBERGRP set T_USERID='" + userID + "' where T_USERID='" + userIDO + "';";
}
result = dl.RunNonQuery(sql, out errMsg);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
}
else if (rlDBType == "ORACLE")
{
try
{
if (img != null)
{
OracleConnection con = new OracleConnection(SAC.DBOperations.OracleHelper.retStr());
con.Open();
if (userIDO == userID)
{
sql += "update T_SYS_MEMBERINFO set T_USERNAME=:blobtodb,T_PASSWD=:blobtodb,B_ATTACHMENT=:blobtodb where T_USERID='" + userIDO + "'";
OracleCommand orlcmd = new OracleCommand(sql, con);
orlcmd.Parameters.Add("blobtodb", userName);
orlcmd.Parameters.Add("blobtodb", pwd);
orlcmd.Parameters.Add("blobtodb", img);
if (orlcmd.ExecuteNonQuery() > 0)
{
result = true;
}
}
else
{
sql += "update T_SYS_MEMBERINFO set T_USERID=:blobtodb,T_USERNAME=:blobtodb,T_PASSWD=:blobtodb,B_ATTACHMENT=:blobtodb where T_USERID='" + userIDO + "'";
OracleCommand orlcmd = new OracleCommand(sql, con);
orlcmd.Parameters.Add("blobtodb", userID);
orlcmd.Parameters.Add("blobtodb", userName);
orlcmd.Parameters.Add("blobtodb", pwd);
orlcmd.Parameters.Add("blobtodb", img);
result = SAC.DBOperations.DBoracle.RunNonQuery("update T_SYS_MEMBERGRP set T_USERID='" + userID + "' where T_USERID='" + userIDO + "';", out errMsg);
if (orlcmd.ExecuteNonQuery() > 0 && result == true)
{
result = true;
}
}
con.Close();
}
else
{
if (userIDO == userID)
{
sql += "update T_SYS_MEMBERINFO set T_USERNAME='******',T_PASSWD='" + pwd + "' where T_USERID='" + userIDO + "';";
}
else
{
sql += "update T_SYS_MEMBERINFO set T_USERID='" + userID + "',T_USERNAME='******',T_PASSWD='" + pwd + "' where T_USERID='" + userIDO + "';update T_SYS_MEMBERGRP set T_USERID='" + userID + "' where T_USERID='" + userIDO + "';";
}
result = dl.RunNonQuery(sql, out errMsg);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
}
return(result);
}
public ItemDAL()
{
conn = DBsql.OpenConnection();
}
