public Entity.UserPower GetUserPower(string cUserName, int iMenuID)
{
Entity.UserPower entity = null;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@cUserName", DBTypeConverter.ConvertCsTypeToOriginDBType(cUserName.GetType().ToString()), cUserName, 50),
dbFactory.MakeInParam("@iMenuID", DBTypeConverter.ConvertCsTypeToOriginDBType(iMenuID.GetType().ToString()), iMenuID, 0)
};
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_UserPower_Get", prams);
while (dataReader.Read())
{
entity = new Entity.UserPower();
entity.ID = int.Parse(dataReader["ID"].ToString());
entity.CUserName = dataReader["CUserName"].ToString();
entity.IMenuId = int.Parse(dataReader["IMenuId"].ToString());
entity.BLuRu = bool.Parse(dataReader["BLuRu"].ToString());
entity.BUp = bool.Parse(dataReader["BUp"].ToString());
entity.BCheck = bool.Parse(dataReader["BCheck"].ToString());
entity.DCreateDate = DateTime.Parse(dataReader["dCreateDate"].ToString());
entity.CCreateUser = dataReader["cCreateUser"].ToString();
entity.DUpdateDate = DateTime.Parse(dataReader["dUpdateDate"].ToString());
entity.CUpdateUser = dataReader["CUpdateUser"].ToString();
}
}
catch (Exception ex)
{
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(entity);
}
/// <summary>
///
/// </summary>
/// <param name="DateTime"> </param>
/// <returns></returns>
public static List <Entity.WasteStorage> GetSumWasteStorage()
{
List <Entity.WasteStorage> list = new List <Entity.WasteStorage>();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
string Start = string.Format("{0}-01-01", DateTime.Now.Year);
string End = string.Format("{0}-12-31", DateTime.Now.Year);
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select sum(Amount) as Total,WasteName from vWasteStorage where Status>=2 and DateTime>='" + Start + "' and DateTime<='" + End + "' group by WasteName", null);
while (dataReader.Read())
{
Entity.WasteStorage entity = new Entity.WasteStorage();
//entity.StorageID = DataHelper.ParseToInt(dataReader["StorageID"].ToString());
//entity.PlanID = DataHelper.ParseToInt(dataReader["PlanID"].ToString());
//entity.BillNumber = dataReader["BillNumber"].ToString();
//entity.DateTime = DataHelper.ParseToDate(dataReader["DateTime"].ToString());
//entity.EnterpriseID = DataHelper.ParseToInt(dataReader["EnterpriseID"].ToString());
//entity.WasteCode = dataReader["WasteCode"].ToString();
entity.WasteName = dataReader["WasteName"].ToString();
entity.Amount = decimal.Parse(dataReader["Total"].ToString());
//entity.DriverID = DataHelper.ParseToInt(dataReader["DriverID"].ToString());
//entity.PondID = DataHelper.ParseToInt(dataReader["PondID"].ToString());
//entity.ReceiverID = DataHelper.ParseToInt(dataReader["ReceiverID"].ToString());
//entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString());
//entity.CreateUser = dataReader["CreateUser"].ToString();
//entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString());
//entity.UpdateUser = dataReader["UpdateUser"].ToString();
//entity.Status = DataHelper.ParseToInt(dataReader["Status"].ToString());
list.Add(entity);
}
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(list);
}
public static int UpdateWasteStorage(Entity.WasteStorage entity)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@StorageID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.StorageID.GetType().ToString()), entity.StorageID, 32),
dbFactory.MakeInParam("@PlanID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PlanID.GetType().ToString()), entity.PlanID, 32),
dbFactory.MakeInParam("@BillNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.BillNumber.GetType().ToString()), entity.BillNumber, 20),
dbFactory.MakeInParam("@DateTime", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DateTime.GetType().ToString()), entity.DateTime, 0),
dbFactory.MakeInParam("@EnterpriseID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.EnterpriseID.GetType().ToString()), entity.EnterpriseID, 32),
dbFactory.MakeInParam("@WasteCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.WasteCode.GetType().ToString()), entity.WasteCode, 20),
dbFactory.MakeInParam("@Amount", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Amount.GetType().ToString()), entity.Amount, 10),
dbFactory.MakeInParam("@DriverID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DriverID.GetType().ToString()), entity.DriverID, 32),
dbFactory.MakeInParam("@PondID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PondID.GetType().ToString()), entity.PondID, 32),
dbFactory.MakeInParam("@ReceiverID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ReceiverID.GetType().ToString()), entity.ReceiverID, 32),
dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()), entity.UpdateDate, 0),
dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()), entity.UpdateUser, 50),
dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32),
dbFactory.MakeInParam("@CarID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CarID.GetType().ToString()), entity.CarID, 32)
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_WasteStorage_Update", prams);
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
iReturn = 0;
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
/// <summary>
///
/// </summary>
/// <param name="Name"> </param>
/// <param name="OrganizationCode"> </param>
/// <param name="Type"> </param>
/// <param name="AreaCode"> </param>
/// <returns></returns>
public static DataTable GetAllEnterpriseEx(string LawManCode, string Name, string OrganizationCode, int Type, string AreaCode)
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
StringBuilder sb = new StringBuilder();
sb.Append("Select * from [Enterprise] where 1=1 ");
if (!string.IsNullOrEmpty(LawManCode))
{
sb.Append(" and LawManCode like '%" + LawManCode + "%'");
}
if (!string.IsNullOrEmpty(Name))
{
sb.Append(" and ( Name like '%" + Name + "%' or PastName like '%" + Name + "%')");
}
if (!string.IsNullOrEmpty(OrganizationCode))
{
sb.Append(" and OrganizationCode like '%" + OrganizationCode + "%'");
}
if (Type != -2)
{
sb.Append(" and Type='" + Type + "'");
}
if (AreaCode != "3304")
{
sb.Append(" and AreaCode ='" + AreaCode + "'");
}
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, sb.ToString(), null);
dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(dt);
}
/// <summary>
///更改用户信息
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public int EditUsers(Entity.User.Users users)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(Config.constr);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(users.ID.GetType().ToString()), users.ID, 50),
dbFactory.MakeInParam("@UserID", DBTypeConverter.ConvertCsTypeToOriginDBType(users.UserID.GetType().ToString()), users.UserID, 50),
dbFactory.MakeInParam("@PWD", DBTypeConverter.ConvertCsTypeToOriginDBType(users.PWD.GetType().ToString()), users.PWD, 50),
dbFactory.MakeInParam("@DepartID", DBTypeConverter.ConvertCsTypeToOriginDBType(users.DepartID.GetType().ToString()), users.DepartID, 50),
dbFactory.MakeInParam("@RoleID", DBTypeConverter.ConvertCsTypeToOriginDBType(users.RoleID.GetType().ToString()), users.RoleID, 50),
dbFactory.MakeInParam("@PWDModifyTime", DBTypeConverter.ConvertCsTypeToOriginDBType(users.PWDModifyTime.GetType().ToString()), users.PWDModifyTime, 50),
dbFactory.MakeInParam("@UserName", DBTypeConverter.ConvertCsTypeToOriginDBType(users.Name.GetType().ToString()), users.Name, 50),
dbFactory.MakeInParam("@grouptype", DBTypeConverter.ConvertCsTypeToOriginDBType(users.grouptype.GetType().ToString()), users.grouptype, 50),
dbFactory.MakeOutReturnParam()
};
string strSql = @"update t_R_UserInfo
set UserID='" + users.UserID +
"',DepartID='" + users.DepartID +
"',RoleID='" + users.RoleID +
"',PWD='" + users.PWD +
"',Name='" + users.Name +
"' where id='" + users.ID + "'";
iReturn = db.ExecuteNonQuery(Config.constr, CommandType.Text, strSql, prams);
}
catch (Exception ex)
{
iReturn = 0;
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
public List <string> GetParameters()
{
List <string> Return = new List <string>();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
ConString = Singleton <ConnectionString> .Instance.ToString();
try
{
//IDataReader dataReader = db.ExecuteReader(ConString, CommandType.Text, "SELECT TABLE_CATALOG AS [Database], TABLE_SCHEMA AS Owner, TABLE_NAME AS TableName, COLUMN_NAME AS ColumnName, ORDINAL_POSITION AS OrdinalPosition, COLUMN_DEFAULT AS DefaultSetting, case IS_NULLABLE when 'NO' then 'False' else 'True' END as Is_Nullable,DATA_TYPE AS DataType, CHARACTER_MAXIMUM_LENGTH AS MaxLength, DATETIME_PRECISION AS DatePrecision,COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') as IsIdentity FROM INFORMATION_SCHEMA.COLUMNS WHERE (TABLE_NAME = '" + Singleton<ConnectionString>.Instance.DataTable + "')", null);
IDataReader dataReader = db.ExecuteReader(ConString, CommandType.Text, "SELECT 表名 = case when a.colorder=1 then d.name else '' end,表说明= case when a.colorder=1 then isnull(f.value,'') else '' end,字段序号= a.colorder,字段名= a.name,标识= case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end,主键= case when exists(SELECT 1 FROM sysobjects where xtype='PK' and parent_obj=a.id and name in (SELECT name FROM sysindexes WHERE indid in( SELECT indid FROM sysindexkeys WHERE id = a.id AND colid=a.colid))) then '√' else '' end, 类型= b.name,占用字节数 = a.length,长度= COLUMNPROPERTY(a.id,a.name,'PRECISION'),小数位数= isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0),允许空= case when a.isnullable=1 then '√'else '' end,默认值= isnull(e.text,''),字段说明= isnull(g.[value],'') FROM syscolumns a left join systypes b on a.xusertype=b.xusertype inner join sysobjects d on a.id=d.id and d.xtype='U' and d.name<>'dtproperties' left join syscomments e on a.cdefault=e.id left join sys.extended_properties g on a.id=G.major_id and a.colid=g.minor_id left join sys.extended_properties f on d.id=f.major_id and f.minor_id=0 where d.name='" + Singleton <ConnectionString> .Instance.DataTable + "' order by a.id,a.colorder", null);
while (dataReader.Read())
{
checkedListBox1.Items.Add(String.Format("{0}\t{1}\t{2}\t{3}\t{4}", dataReader["字段名"].ToString(), dataReader["类型"].ToString(), dataReader["长度"].ToString(), dataReader["允许空"].ToString(), dataReader["字段说明"].ToString()));
OriginalParameter op = new OriginalParameter();
op.ColumnName = dataReader["字段名"].ToString();
op.DataType = dataReader["类型"].ToString();
if (dataReader["允许空"].ToString() == "√")
{
op.IsNullable = true;
}
else
{
op.IsNullable = false;
}
op.MaxLength = dataReader["长度"].ToString();
op.Description = dataReader["字段说明"].ToString();
Singleton <Condition> .Instance.ALLParameters.Add(op);
//Singleton<Condition>.Instance.AllParameterNames.Add(string.Format("{0}\t{1}", dataReader["ColumnName"].ToString(), dataReader["DataType"].ToString()));
}
}
catch
{
}
finally
{
db.Conn.Close();
}
return(Return);
}
/// <summary>
///
/// </summary>
/// <param name="FromPondID"> </param>
/// <param name="FromWasteCode"> </param>
/// <param name="Status"> </param>
/// <returns></returns>
public static DataTable GetAllWasteToProduct(int FromPondID, string FromWasteCode, int Status)
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [WasteToProduct] where FromPondID='" + FromPondID + "' and FromWasteCode='" + FromWasteCode + "' and Status='" + Status + "'", null);
dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(dt);
}
/// <summary>
///
/// </summary>
/// <param name="PlanID"> </param>
/// <param name="BillNumber"> </param>
/// <param name="DateTime"> </param>
/// <param name="EnterpriseID"> </param>
/// <param name="WasteCode"> </param>
/// <param name="Status"> </param>
/// <returns></returns>
public static DataTable GetAllWasteStorage(int PlanID, string BillNumber, DateTime DateTime, int EnterpriseID, string WasteCode, int Status)
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [WasteStorage] where PlanID='" + PlanID + "' and BillNumber='" + BillNumber + "' and DateTime='" + DateTime + "' and EnterpriseID='" + EnterpriseID + "' and WasteCode='" + WasteCode + "' and Status='" + Status + "'", null);
dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(dt);
}
/// <summary>
///
/// </summary>
/// <param name="IsStop"> </param>
/// <returns></returns>
public static DataTable GetAllDriver(bool IsStop)
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [Driver] where IsStop='" + IsStop + "'", null);
dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(dt);
}
/// <summary>
///
/// </summary>
/// <param name="ID"> </param>
/// <returns></returns>
public static DataTable GetUserNamesEx2(string RoleIDs)
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select UserID,RealName from [vUserRole] where IsStop=0 and RoleID in (" + RoleIDs + ")", null);
dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(dt);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static DataTable GetUseWaste()
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select distinct Stores,WasteName from [vPond]", null);
dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(dt);
}
/// <summary>
///
/// </summary>
/// <param name="ContractID"> </param>
/// <param name="PlanNumber"> </param>
/// <param name="StartDate"> </param>
/// <param name="EndDate"> </param>
/// <param name="WasteCode"> </param>
/// <param name="StatusID"> </param>
/// <returns></returns>
public static DataTable GetAllTransferPlan(int ContractID, string PlanNumber, DateTime StartDate, DateTime EndDate, string WasteCode, int StatusID)
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [TransferPlan] where ContractID='" + ContractID + "' and PlanNumber='" + PlanNumber + "' and StartDate='" + StartDate + "' and EndDate='" + EndDate + "' and WasteCode='" + WasteCode + "' and StatusID='" + StatusID + "'", null);
dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(dt);
}
/// <summary>
///
/// </summary>
/// <param name="IsDelete"> </param>
/// <returns></returns>
public static DataTable GetAllAreaEx2(int IsDelete)
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select distinct AreaCode,ShortName from [Area] where IsDelete='" + IsDelete + "'", null);
dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(dt);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static DataTable GetAllProductDetail()
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [ProductDetail]", null);
dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(dt);
}
{/// <summary>
///
/// </summary>
/// <param name="BillNumber"> </param>
/// <returns></returns>
public static DataTable GetMonitorResult(int MonitorID)
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vMonitorResult] where MonitorID='" + MonitorID + "'", null);
dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(dt);
}
public static int AddWasteToProduct(Entity.WasteToProduct entity)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@FromPondID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.FromPondID.GetType().ToString()), entity.FromPondID, 32),
dbFactory.MakeInParam("@FromWasteCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.FromWasteCode.GetType().ToString()), entity.FromWasteCode, 20),
dbFactory.MakeInParam("@DateTime", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DateTime.GetType().ToString()), entity.DateTime, 0),
dbFactory.MakeInParam("@FromAmount", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.FromAmount.GetType().ToString()), entity.FromAmount, 10),
dbFactory.MakeInParam("@HanderManID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.HanderManID.GetType().ToString()), entity.HanderManID, 32),
dbFactory.MakeInParam("@ReceiverID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ReceiverID.GetType().ToString()), entity.ReceiverID, 32),
dbFactory.MakeInParam("@CreateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateDate.GetType().ToString()), entity.CreateDate, 0),
dbFactory.MakeInParam("@CreateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateUser.GetType().ToString()), entity.CreateUser, 50),
dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()), entity.UpdateDate, 0),
dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()), entity.UpdateUser, 50),
dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32),
dbFactory.MakeOutReturnParam()
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_WasteToProduct_Add", prams);
iReturn = int.Parse(prams[11].Value.ToString());
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
iReturn = 0;
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
public int save()
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(Config.constr);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "insert into t_Y_BackInfo ([itemid] ,[title] ,[remark],[userid],[createdate]) values('" + FlowItemObj.flowid + "','" + FlowItemObj.title + "','" + FlowItemObj.Remark + "','" + FlowItemObj.UserID + "','" + FlowItemObj.CreateDate + "')", prams);
if (iReturn == 1)
{
thelper.CommitTransaction(trans);
}
else
{
thelper.RollTransaction(trans);
}
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
iReturn = -1;
}
finally
{
if (db.Conn != null)
{
db.Conn.Close();
}
}
return(iReturn);
}
///// <summary>
/////
///// </summary>
///// <param name="DateTime"> </param>
///// <returns></returns>
//public static List<Entity.FinalWasteLog> GetSumFinalWasteLog()
//{
// List<Entity.FinalWasteLog> list = new List<Entity.FinalWasteLog>();
// DBOperatorBase db = new DataBase();
// IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
// try
// {
// string Start = string.Format("{0}-01-01", DateTime.Now.Year);
// string End = string.Format("{0}-12-31", DateTime.Now.Year);
// IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select sum(FromAmount) as Total,WasteName from vFinalWasteLog where Status=2 and DateTime>='" + Start + "' and DateTime<='" + End + "' group by WasteName", null);
// while (dataReader.Read())
// {
// Entity.FinalWasteLog entity = new Entity.FinalWasteLog();
// entity.FromWasteCode = dataReader["WasteName"].ToString();
// entity.FromAmount = decimal.Parse(dataReader["Total"].ToString());
// list.Add(entity);
// }
// }
// catch (Exception ex)
// {
// }
// finally
// {
// db.Conn.Close();
// }
// return list;
//}
///// <summary>
/////
///// </summary>
///// <param name="DateTime"> </param>
///// <returns></returns>
//public static decimal GetPartSumFinalWasteLog(string WasteName)
//{
// decimal sum = 0;
// DBOperatorBase db = new DataBase();
// IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
// try
// {
// string Start = string.Format("{0}-01-01", DateTime.Now.Year);
// string End = string.Format("{0}-12-31", DateTime.Now.Year);
// IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select sum(FromAmount) as Total,WasteName from vFinalWasteLog where Status=2 and DateTime>='" + Start + "' and DateTime<='" + End + "' and WasteName='" + WasteName + "' group by WasteName", null);
// while (dataReader.Read())
// {
// sum = decimal.Parse(dataReader["Total"].ToString());
// }
// }
// catch (Exception ex)
// {
// }
// finally
// {
// db.Conn.Close();
// }
// return sum;
//}
///// <summary>
/////
///// </summary>
///// <param name="PlanID"> </param>
///// <param name="BillNumber"> </param>
///// <param name="DateTime"> </param>
///// <param name="EnterpriseID"> </param>
///// <param name="WasteCode"> </param>
///// <param name="Status"> </param>
///// <returns></returns>
//public static DataTable GetSum(string StartTime, string EndTime)
//{
// DataTable dt = new DataTable();
// DBOperatorBase db = new DataBase();
// IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
// try
// {
// StringBuilder sb = new StringBuilder();
// sb.Append("select sum(FromAmount) as Total,WasteName from vFinalWasteLog where Status=2");
// if (!string.IsNullOrEmpty(StartTime))
// {
// sb.Append(" and DateTime>='" + StartTime + "'");
// }
// if (!string.IsNullOrEmpty(EndTime))
// {
// sb.Append(" and DateTime<='" + EndTime + "'");
// }
// sb.Append(" group by WasteName");
// IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, sb.ToString(), null);
// dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
// }
// catch (Exception ex)
// {
// }
// finally
// {
// db.Conn.Close();
// }
// return dt;
//}
///// <summary>
/////
///// </summary>
///// <param name="PlanID"> </param>
///// <param name="BillNumber"> </param>
///// <param name="DateTime"> </param>
///// <param name="EnterpriseID"> </param>
///// <param name="WasteCode"> </param>
///// <param name="Status"> </param>
///// <returns></returns>
//public static DataTable GetSumEx(string StartTime, string EndTime)
//{
// DataTable dt = new DataTable();
// DBOperatorBase db = new DataBase();
// IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
// try
// {
// StringBuilder sb = new StringBuilder();
// sb.Append("select WasteName 废物名称,sum(FromAmount) as 合计 from vFinalWasteLog where Status=2");
// if (!string.IsNullOrEmpty(StartTime))
// {
// sb.Append(" and DateTime>='" + StartTime + "'");
// }
// if (!string.IsNullOrEmpty(EndTime))
// {
// sb.Append(" and DateTime<='" + EndTime + "'");
// }
// sb.Append(" group by WasteName");
// IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, sb.ToString(), null);
// dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
// }
// catch (Exception ex)
// {
// }
// finally
// {
// db.Conn.Close();
// }
// return dt;
//}
///// <summary>
/////
///// </summary>
///// <param name="DateTime"> </param>
///// <returns></returns>
//public static decimal GetPartSumFinalWasteLogEx(string WasteName)
//{
// decimal sum = 0;
// DBOperatorBase db = new DataBase();
// IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
// try
// {
// IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select sum(FromAmount) as Total,WasteName from vFinalWasteLog where Status=2 and DateTime='" + DateTime.Now.Date + "' and WasteName='" + WasteName + "' group by WasteName", null);
// while (dataReader.Read())
// {
// sum = decimal.Parse(dataReader["Total"].ToString());
// }
// }
// catch (Exception ex)
// {
// }
// finally
// {
// db.Conn.Close();
// }
// return sum;
//}
public static int AddFinalWasteLog(Entity.FinalWasteLog entity)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@LogNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.LogNumber.GetType().ToString()), entity.LogNumber, 32),
dbFactory.MakeInParam("@DateTime", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DateTime.GetType().ToString()), entity.DateTime, 0),
dbFactory.MakeInParam("@IYear", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.IYear.GetType().ToString()), entity.IYear, 32),
dbFactory.MakeInParam("@Number", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Number.GetType().ToString()), entity.Number, 32),
dbFactory.MakeInParam("@UserID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UserID.GetType().ToString()), entity.UserID, 32),
dbFactory.MakeInParam("@CreateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateDate.GetType().ToString()), entity.CreateDate, 0),
dbFactory.MakeInParam("@CreateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateUser.GetType().ToString()), entity.CreateUser, 50),
dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()), entity.UpdateDate, 0),
dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()), entity.UpdateUser, 50),
dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32),
dbFactory.MakeOutReturnParam()
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_FinalWasteLog_Add", prams);
iReturn = int.Parse(prams[10].Value.ToString());
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
iReturn = 0;
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static List <Entity.User> GetAllUser()
{
List <Entity.User> list = new List <Entity.User>();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams =
{
};
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_User_GetAll", prams);
while (dataReader.Read())
{
Entity.User entity = new Entity.User();
entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString());
entity.UserName = dataReader["UserName"].ToString();
entity.PassWord = dataReader["PassWord"].ToString();
entity.GUID = dataReader["GUID"].ToString();
//entity.AreaCode = dataReader["AreaCode"].ToString();
//entity.AreaInCharge = dataReader["AreaInCharge"].ToString();
entity.RealName = dataReader["RealName"].ToString();
entity.PwdChgDate = DataHelper.ParseToDate(dataReader["PwdChgDate"].ToString());
//entity.CreateUser = dataReader["CreateUser"].ToString();
//entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString());
//entity.UpdateUser = dataReader["UpdateUser"].ToString();
//entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString());
entity.IsStop = DataHelper.ParseToBoolean(dataReader["IsStop"].ToString());
list.Add(entity);
}
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(list);
}
/// <summary>
///
/// </summary>
/// <param name="BillNumber"> </param>
/// <param name="DateTime"> </param>
/// <param name="AnalysisManID"> </param>
/// <returns></returns>
public static DataTable GetMonitor(int PositionID, string StartTime, string EndTime, int AnalysisManID)
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
StringBuilder sb = new StringBuilder();
sb.Append("Select * from [vMonitor] where 1=1 ");
if (PositionID != -2)
{
sb.Append(" and PositionID='" + PositionID + "'");
}
if (!string.IsNullOrEmpty(StartTime))
{
sb.Append(" and DateTime>='" + StartTime + "'");
}
if (!string.IsNullOrEmpty(EndTime))
{
sb.Append(" and DateTime<='" + EndTime + "'");
}
if (AnalysisManID != -2)
{
sb.Append(" and AnalysisManID='" + AnalysisManID + "'");
}
//IDataAdapter dataAdapter = new SqlDataAdapter(sb.ToString(),);
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, sb.ToString(), null);
dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(dt);
}
public string RoleListListStr(int flag)
{
string ret = "";
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
string constr = "";
if (flag == 1)
{
constr += " and Analysisflag=" + flag + "";
}
IDbDataParameter[] prams =
{
};
string strSql = "select t_R_Role.RoleID from t_R_Role where 1=1" + constr;
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, strSql, prams);
while (dataReader.Read())
{
ret += dataReader[0].ToString() + ",";
}
if (ret != "")
{
ret = ret.Substring(0, ret.Length - 1);
}
}
catch (Exception ex)
{
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(ret);
}
public Entity.User.UserRole GetUserRole(int UserID)
{
Entity.User.UserRole entity = null;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams =
{
};
string strSql = "select * from Users inner join t_R_Role on t_R_Role.RoleID=Users.iRoleType where Users.ID='" + UserID + "'";;
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, strSql, prams);
while (dataReader.Read())
{
entity = new Entity.User.UserRole();
entity.ID = int.Parse(dataReader["RoleID"].ToString());
entity.CName = dataReader["RoleName"].ToString();
entity.ILevel = int.Parse(dataReader["LevelID"].ToString());
entity.ReadRight = int.Parse(dataReader["ReadRight"].ToString());
entity.WriteRight = int.Parse(dataReader["WriteRight"].ToString());
entity.ImportRight = int.Parse(dataReader["ImportRight"].ToString());
entity.ExportRight = int.Parse(dataReader["ExportRight"].ToString());
entity.UpLoadRight = int.Parse(dataReader["UpLoadRight"].ToString());
entity.CheckRight = int.Parse(dataReader["CheckRight"].ToString());
entity.Admin = int.Parse(dataReader["bAdmin"].ToString());
}
}
catch (Exception ex)
{
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(entity);
}
///// <summary>
///// 查询用户
///// </summary>
///// <returns></returns>
//public List<Entity.User.Users> QueryUsers(string cName, int bStop, string cDepCode, int iRole,int level)
//{
// List<Entity.User.Users> list = new List<Entity.User.Users>();
// DBOperatorBase db = new DataBase();
// IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
// try
// {
// IDbDataParameter[] prams = {
// dbFactory.MakeInParam("@cName", DBTypeConverter.ConvertCsTypeToOriginDBType(cName.GetType().ToString()),cName, 50),
// dbFactory.MakeInParam("@cDepCode", DBTypeConverter.ConvertCsTypeToOriginDBType(cDepCode.GetType().ToString()),cDepCode,50),
// dbFactory.MakeInParam("@bStop", DBTypeConverter.ConvertCsTypeToOriginDBType(bStop.GetType().ToString()),bStop, 50),
// dbFactory.MakeInParam("@level", DBTypeConverter.ConvertCsTypeToOriginDBType(level.GetType().ToString()),level, 0),
// dbFactory.MakeInParam("@iRole", DBTypeConverter.ConvertCsTypeToOriginDBType(iRole.GetType().ToString()),iRole, 0)
// };
// IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_User_QueryCondition", prams);
// while (dataReader.Read())
// {
// Entity.User.Users entity = new Entity.User.Users();
// entity.ID = int.Parse(dataReader["ID"].ToString());
// entity.CName = dataReader["cName"].ToString();
// entity.CMemo = dataReader["cMemo"].ToString();
// entity.Guid = System.Guid.NewGuid().ToString();
// entity.BStop = bool.Parse(dataReader["bStop"].ToString());
// entity.BStopName = dataReader["BStopName"].ToString();
// entity.BAdmin = bool.Parse(dataReader["BAdmin"].ToString());
// entity.BAdminName = dataReader["BAdminName"].ToString();
// entity.CRole = GetName(dataReader["IRoleType"].ToString());
// entity.IRoleType = DataHelper.ParseToInt(dataReader["IRoleType"].ToString());
// entity.CDepCode = dataReader["CDepCode"].ToString();
// //entity.CDepCodeName = GetName(entity.CDepCode, entity.IRoleType);
// entity.CPhone = dataReader["CPhone"].ToString();
// entity.DActivityLastTime = DateTime.Parse(dataReader["dActivityLastTime"].ToString());
// entity.CActivityIP = dataReader["cActivityIP"].ToString();
// entity.DCreateDate = DateTime.Parse(dataReader["dCreateDate"].ToString());
// entity.CCreateUser = dataReader["cCreateUser"].ToString();
// entity.DUpdateDate = DateTime.Parse(dataReader["dUpdateDate"].ToString());
// list.Add(entity);
// }
// }
// catch (Exception ex)
// {
// Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
// }
// finally
// {
// db.Conn.Close();
// }
// return list;
//}
/// <summary>
/// 查询用户
/// </summary>
/// <returns></returns>
public DataTable QueryUsersDT(string cDepCode, string iRole)
{
DataTable dt = null;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams =
{
};
string constr = "";
if (cDepCode != "")
{
constr += "and DepartID in(" + cDepCode + ")";
}
if (iRole != "")
{
constr += " and RoleID in (" + iRole + ")";
}
string str = " select UserID,Name from t_R_UserInfo where flag=0 " + constr;
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, str, prams);
dt = new DataTable();
dt.Load(dataReader);
}
catch (Exception ex)
{
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(dt);
}
public static DataTable QueryTransferPlanAlarm()
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
StringBuilder sb = new StringBuilder();
sb.Append("Select * from [vPlanAmount] where ( EndDate>='" + DateTime.Now.Date + "' and EndDate<='" + DateTime.Now.Date.AddDays(30) + "' ) or Used > 0.9*PlanAmount");
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, sb.ToString(), null);
dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(dt);
}
private void btChoose_Click(object sender, EventArgs e)
{
groupBox4.Controls.Clear();
//Singleton<Condition>.Instance.All.Parameter.Clear();
Parameters pm = new Parameters();
groupBox4.Controls.Add(pm);
#region 得到所有参数
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
IDataReader dataReader = db.ExecuteReader(ConString, CommandType.Text, "SELECT TABLE_CATALOG AS [Database], TABLE_SCHEMA AS Owner, TABLE_NAME AS TableName, COLUMN_NAME AS ColumnName, ORDINAL_POSITION AS OrdinalPosition, COLUMN_DEFAULT AS DefaultSetting, IS_NULLABLE AS IsNullable, DATA_TYPE AS DataType, CHARACTER_MAXIMUM_LENGTH AS MaxLength, DATETIME_PRECISION AS DatePrecision,COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') as IsIdentity FROM INFORMATION_SCHEMA.COLUMNS WHERE (TABLE_NAME = '" + Singleton <ConnectionString> .Instance.DataTable + "')", null);
while (dataReader.Read())
{
//Parameter p = new Parameter();
//p.IsNullable = DealData.GetIsNull(dataReader["IsNullable"].ToString());
//p.Lower = DealData.GetLower(dataReader["ColumnName"].ToString());
//p._Lower = DealData.Get_Lower(dataReader["ColumnName"].ToString());
//p.Upper = DealData.GetUpper(dataReader["ColumnName"].ToString());
//p.Type = DealData.GetType(dataReader["DataType"].ToString());
//p.Length = DealData.GetLength(p.Type, dataReader["MaxLength"].ToString()).ToString();
//p.OriginalName = dataReader["ColumnName"].ToString();
//Singleton<Condition>.Instance.All.Parameter.Add(p);
}
dataReader = db.ExecuteReader(ConString, CommandType.Text, "SELECT TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME='" + Singleton <ConnectionString> .Instance.DataTable + "'", null);
while (dataReader.Read())
{
string Name = dataReader["COLUMN_NAME"].ToString();
Singleton <Condition> .Instance.KeyInfo.Name = Name;
//Parameter p = Singleton<Condition>.Instance.All.Parameter.Find(s => s.OriginalName == Name);
//Singleton<Condition>.Instance.KeyInfo.Lower = p.Lower;
//Singleton<Condition>.Instance.KeyInfo._Lower = p._Lower;
//Singleton<Condition>.Instance.KeyInfo.Upper = p.Upper;
//Singleton<Condition>.Instance.KeyInfo.Type = p.Type;
}
db.Conn.Close();
#endregion
//Conditions con = new Conditions();
//groupBox4.Controls.Add(con);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static DataTable GetAllAnalysis()
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams = {
};
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_Analysis_GetAll", prams);
dt = DAL.DataBase.GetDataTableFromIDataReader(dataReader);
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return dt;
}
/// <summary>
/// 获取企业信息
/// </summary>
/// <param name="ID">企业编号</param>
/// <returns></returns>
public DataTable GetStationByID(string ID)
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(Config.constr);
//IDbTransaction trans = thelper.StartTransaction();
try
{
string Constr = "";
if (ID != "")
{
Constr = " and ID='" + ID + "'";
}
IDbDataParameter[] prams =
{
// dbFactory.MakeInParam("@SampleID", DBTypeConverter.ConvertCsTypeToOriginDBType(sampleid.GetType().ToString()), sampleid, 50)
};
IDataReader idr = db.ExecuteReader(Config.constr, CommandType.Text, "select * from t_企业信息 where 1=1 " + Constr, prams);
dt.Load(idr);
// idr = db.ExecuteReader(Config.constr, CommandType.Text, "select xcflag 现场分析,AIName 分析项目 ,MonitorItem ItemID from t_MonitorItemDetail inner join t_M_AnalysisItemEx on t_M_AnalysisItemEx.id=MonitorItem inner join t_DrawSampleDetail on t_DrawSampleDetail.DrawID=t_MonitorItemDetail.fxDanID and ItemID=MonitorItem where SampleID='" + sampleid + "' and delflag=0", prams);
}
catch (Exception ex)
{
dt = null;
}
finally
{
if (db.Conn != null)
{
db.Conn.Close();
}
}
return(dt);
}
public static int AddPondChange(Entity.PondChange entity, decimal Capacity)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@PondID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PondID.GetType().ToString()), entity.PondID, 32),
dbFactory.MakeInParam("@OldAmount", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.OldAmount.GetType().ToString()), entity.OldAmount, 10),
dbFactory.MakeInParam("@NewAmount", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.NewAmount.GetType().ToString()), entity.NewAmount, 10),
dbFactory.MakeInParam("@Remark", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Remark.GetType().ToString()), entity.Remark, 0),
dbFactory.MakeInParam("@CreateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateDate.GetType().ToString()), entity.CreateDate, 0),
dbFactory.MakeInParam("@CreateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateUser.GetType().ToString()), entity.CreateUser, 50)
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_PondChange_Add", prams);
//
decimal Used = entity.NewAmount;
decimal Remain = Capacity - entity.NewAmount;
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [Pond] set Used='"+ Used + "',Remain='" + Remain + "' where PondID='" + entity.PondID + "'", null);
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
iReturn = 0;
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
/// <summary>
/// 获取样品类型
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataTable GetType(string TypeID)
{
DataTable dt = new DataTable();
DBOperatorBase db = new DataBase();
DataTable dtItem = new DataTable();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(Config.constr);
//IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@Type", DBTypeConverter.ConvertCsTypeToOriginDBType(TypeID.GetType().ToString()), TypeID, 50)
};
string constr = "";
//水t_M_AnalysisMainClassEx增加Class字段，用于水组区分
if (TypeID != "")
{
constr = " and Class='" + TypeID + "'";
}
IDataReader idr = db.ExecuteReader(Config.constr, CommandType.Text, "select ClassID TypeID,ClassName 样品类型 from t_M_AnalysisMainClassEx where 1=1 " + constr, prams);
dt.Load(idr);
}
catch (Exception ex)
{
dt = null;
}
finally
{
if (db.Conn != null)
{
db.Conn.Close();
}
}
return(dt);
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="ID"></param>
/// <returns>Users</returns>
public int CheckUsers(String cName, int userid)
{
int i = 0;
Entity.User.Users entity = null;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams =
{
};
string strSql = "SELECT * FROM [Users] where cName='" + cName + "'";;
if (userid != 0)
{
strSql = "SELECT * FROM [Users] where cName='" + cName + "' and ID!=" + userid + "";;
}
IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.Text, strSql, prams);
while (dataReader.Read())
{
i = 1;
}
}
catch (Exception ex)
{
i = 0;
Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal);
}
finally
{
db.Conn.Close();
}
return(i);
}
