/// <summary> /// /// </summary> /// <param name="UserName"> </param> /// <param name="PassWord"> </param> /// <param name="IsStop"> </param> /// <returns></returns> public static string Login(string UserName, string PassWord) { string iReturn = ""; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@UserName", DBTypeConverter.ConvertCsTypeToOriginDBType(UserName.GetType().ToString()), UserName, 50), dbFactory.MakeInParam("@PassWord", DBTypeConverter.ConvertCsTypeToOriginDBType(PassWord.GetType().ToString()), PassWord, 50) }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_User_Login", prams); if (dataReader.Read()) { iReturn = dataReader["GUID"].ToString(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdateFinalWasteLog(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("@LogID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.LogID.GetType().ToString()), entity.LogID, 32), dbFactory.MakeInParam("@DateTime", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DateTime.GetType().ToString()), entity.DateTime, 0), dbFactory.MakeInParam("@UserID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UserID.GetType().ToString()), entity.UserID, 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) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_FinalWasteLog_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdateProductDetail(Entity.ProductDetail 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("@DetailID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DetailID.GetType().ToString()), entity.DetailID, 32), dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ItemCode.GetType().ToString()), entity.ItemCode, 20), dbFactory.MakeInParam("@PondID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PondID.GetType().ToString()), entity.PondID, 32), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32), dbFactory.MakeInParam("@Amount", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Amount.GetType().ToString()), entity.Amount, 10) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_ProductDetail_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdatePond(Entity.Pond 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("@PondID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PondID.GetType().ToString()), entity.PondID, 32), dbFactory.MakeInParam("@Name", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Name.GetType().ToString()), entity.Name, 20), dbFactory.MakeInParam("@Capacity", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Capacity.GetType().ToString()), entity.Capacity, 10), dbFactory.MakeInParam("@Stores", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Stores.GetType().ToString()), entity.Stores, 20), dbFactory.MakeInParam("@Number", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Number.GetType().ToString()), entity.Number, 32), //dbFactory.MakeInParam("@Remain", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Remain.GetType().ToString()),entity.Remain,10), dbFactory.MakeInParam("@IsDelete", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.IsDelete.GetType().ToString()), entity.IsDelete, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Pond_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdateMenu(Entity.Menu 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("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ID.GetType().ToString()), entity.ID, 32), dbFactory.MakeInParam("@FatherID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.FatherID.GetType().ToString()), entity.FatherID, 32), dbFactory.MakeInParam("@MenuName", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MenuName.GetType().ToString()), entity.MenuName, 50), dbFactory.MakeInParam("@ImageUrl", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ImageUrl.GetType().ToString()), entity.ImageUrl, 0), dbFactory.MakeInParam("@MenuUrl", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MenuUrl.GetType().ToString()), entity.MenuUrl, 50), dbFactory.MakeInParam("@MenuOrder", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MenuOrder.GetType().ToString()), entity.MenuOrder, 32), dbFactory.MakeInParam("@MenuFile", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MenuFile.GetType().ToString()), entity.MenuFile, 50) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Menu_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
public static int AddWaste(Entity.Waste 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("@WasteCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.WasteCode.GetType().ToString()), entity.WasteCode, 20), dbFactory.MakeInParam("@WasteName", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.WasteName.GetType().ToString()), entity.WasteName, 50), dbFactory.MakeInParam("@List", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.List.GetType().ToString()), entity.List, 50), dbFactory.MakeInParam("@Type", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Type.GetType().ToString()), entity.Type, 32), dbFactory.MakeInParam("@Unit", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Unit.GetType().ToString()), entity.Unit, 20), dbFactory.MakeInParam("@OrderID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.OrderID.GetType().ToString()), entity.OrderID, 32), dbFactory.MakeInParam("@IsShow", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.IsShow.GetType().ToString()), entity.IsShow, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Waste_Add", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="OutID"> </param> /// <param name="Status"> </param> /// <returns></returns> public static int UpdateProductOutStatus(int OutID, int Status) { 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("@OutID", DBTypeConverter.ConvertCsTypeToOriginDBType(OutID.GetType().ToString()), OutID, 32), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(Status.GetType().ToString()), Status, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_ProductOut_UpdateStatus", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// 删除用户-ID /// </summary> /// <param name="ID"></param> /// <returns>int</returns> public int DeleteUsers(int ID) { 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(ID.GetType().ToString()), ID, 0) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_User_Delete", prams); db.ExecuteNonQueryTrans(trans, CommandType.Text, "delete from t_R_UserArea where UserID='" + ID + "'", prams); thelper.CommitTransaction(trans); } catch (Exception ex) { iReturn = 0; thelper.RollTransaction(trans); Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// 刷新用户登录信息 /// </summary> /// <param name="users"></param> /// <returns></returns> public int RefreshUsers(string cName, DateTime dActivityLastTime, string cActivityIP, DateTime dUpdateDate, string cUpdateUser) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { //@cActivityIP,@dActivityLastTime,@dUpdateDate,@cUpdateUser,@cName IDbDataParameter[] prams = { dbFactory.MakeInParam("@cName", DBTypeConverter.ConvertCsTypeToOriginDBType(cName.GetType().ToString()), cName, 50), dbFactory.MakeInParam("@dActivityLastTime", DBTypeConverter.ConvertCsTypeToOriginDBType(dActivityLastTime.GetType().ToString()), dActivityLastTime, 0), dbFactory.MakeInParam("@cActivityIP", DBTypeConverter.ConvertCsTypeToOriginDBType(cActivityIP.GetType().ToString()), cActivityIP, 50), dbFactory.MakeInParam("@dUpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(dUpdateDate.GetType().ToString()), dUpdateDate, 0), dbFactory.MakeInParam("@cUpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(cUpdateUser.GetType().ToString()), cUpdateUser, 50) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.constr), true, CommandType.StoredProcedure, "proc_User_Refresh", prams); } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdateDriver(Entity.Driver 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("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ID.GetType().ToString()), entity.ID, 32), dbFactory.MakeInParam("@RealName", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.RealName.GetType().ToString()), entity.RealName, 20), dbFactory.MakeInParam("@CarNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CarNumber.GetType().ToString()), entity.CarNumber, 20), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()), entity.UpdateUser, 50), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()), entity.UpdateDate, 0), dbFactory.MakeInParam("@IsStop", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.IsStop.GetType().ToString()), entity.IsStop, 4) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Driver_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="cName"></param> /// <returns></returns> public bool IsExistsUsers(string cName) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@cName", DBTypeConverter.ConvertCsTypeToOriginDBType(cName.GetType().ToString()), cName, 50) }; IDataReader dataReader = db.ExecuteReader(Config.constr, CommandType.StoredProcedure, "proc_User_IsExists", prams); if (dataReader.Read()) { iReturn = 1; } } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(iReturn == 1 ? true : false); }
/// <summary> /// /// </summary> /// <param name="PassWord"> </param> /// <param name="GUID"> </param> /// <param name="PwdChgDate"> </param> /// <param name="UpdateUser"> </param> /// <param name="UpdateDate"> </param> /// <returns></returns> public static int UpdateUserPw(string PassWord, string GUID, DateTime PwdChgDate, string UpdateUser, DateTime UpdateDate) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@PassWord", DBTypeConverter.ConvertCsTypeToOriginDBType(PassWord.GetType().ToString()), PassWord, 50), dbFactory.MakeInParam("@GUID", DBTypeConverter.ConvertCsTypeToOriginDBType(GUID.GetType().ToString()), GUID, 100), dbFactory.MakeInParam("@PwdChgDate", DBTypeConverter.ConvertCsTypeToOriginDBType(PwdChgDate.GetType().ToString()), PwdChgDate, 0), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(UpdateUser.GetType().ToString()), UpdateUser, 50), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(UpdateDate.GetType().ToString()), UpdateDate, 0) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.con), true, CommandType.StoredProcedure, "proc_User_UpdatePw", prams); } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="UserName"> </param> /// <param name="GUID"> </param> /// <param name="AreaCode"> </param> /// <param name="AreaInCharge"> </param> /// <param name="RealName"> </param> /// <param name="UpdateUser"> </param> /// <param name="UpdateDate"> </param> /// <param name="IsStop"> </param> /// <returns></returns> public static int UpdateUser(string UserName, string GUID, string AreaCode, string AreaInCharge, string RealName, string UpdateUser, DateTime UpdateDate, bool IsStop) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@UserName", DBTypeConverter.ConvertCsTypeToOriginDBType(UserName.GetType().ToString()), UserName, 50), dbFactory.MakeInParam("@GUID", DBTypeConverter.ConvertCsTypeToOriginDBType(GUID.GetType().ToString()), GUID, 100), dbFactory.MakeInParam("@AreaCode", DBTypeConverter.ConvertCsTypeToOriginDBType(AreaCode.GetType().ToString()), AreaCode, 20), dbFactory.MakeInParam("@AreaInCharge", DBTypeConverter.ConvertCsTypeToOriginDBType(AreaInCharge.GetType().ToString()), AreaInCharge, 100), dbFactory.MakeInParam("@RealName", DBTypeConverter.ConvertCsTypeToOriginDBType(RealName.GetType().ToString()), RealName, 20), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(UpdateUser.GetType().ToString()), UpdateUser, 50), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(UpdateDate.GetType().ToString()), UpdateDate, 0), dbFactory.MakeInParam("@IsStop", DBTypeConverter.ConvertCsTypeToOriginDBType(IsStop.GetType().ToString()), IsStop, 4) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.con), true, CommandType.StoredProcedure, "proc_User_Update", prams); } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="ID"> </param> /// <returns></returns> public static DataTable GetMenuEx(string GUID) { DataTable list = new DataTable(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@GUID", DBTypeConverter.ConvertCsTypeToOriginDBType(GUID.GetType().ToString()), GUID, 100) }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_User_GetMenu", prams); if (dataReader.Read()) { list = dataReader.GetSchemaTable(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
public static int AddFinalWaste(Entity.FinalWaste 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("@LogID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.LogID.GetType().ToString()), entity.LogID, 32), dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ItemCode.GetType().ToString()), entity.ItemCode, 20), dbFactory.MakeInParam("@Result", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Result.GetType().ToString()), entity.Result, 10), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32), dbFactory.MakeOutReturnParam() }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_FinalWaste_Add", prams); iReturn = int.Parse(prams[4].Value.ToString()); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// 停用或启用用户 /// </summary> /// <param name="ID">用户ID</param> /// <param name="BStop">是否停用</param> /// <returns></returns> public int StopUsers(int ID, bool bStop) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(ID.GetType().ToString()), ID, 0), dbFactory.MakeInParam("@bStop", DBTypeConverter.ConvertCsTypeToOriginDBType(bStop.GetType().ToString()), bStop, 1), dbFactory.MakeOutReturnParam() }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.constr), true, CommandType.StoredProcedure, "proc_User_Stop", prams); iReturn = int.Parse(prams[2].Value.ToString()); } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(iReturn); }
public static int AddPondLog(Entity.PondLog entity, decimal U1, decimal R1, decimal U2, decimal R2) { 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("@SourceID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.SourceID.GetType().ToString()), entity.SourceID, 32), dbFactory.MakeInParam("@ToID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ToID.GetType().ToString()), entity.ToID, 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("@Amount", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Amount.GetType().ToString()), entity.Amount, 10) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_PondLog_Add", prams); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [Pond] set Used='"+ U1 + "',Remain='" + R1 + "' where PondID='" + entity.SourceID + "'", null); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [Pond] set Used='"+ U2 + "',Remain='" + R2 + "' where PondID='" + entity.ToID + "'", null); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="RoleID"> </param> /// <returns></returns> public static Entity.Role GetRole(int RoleID) { Entity.Role entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@RoleID", DBTypeConverter.ConvertCsTypeToOriginDBType(RoleID.GetType().ToString()), RoleID, 32) }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_Role_Get", prams); while (dataReader.Read()) { entity = new Entity.Role(); //entity.RoleID = DataHelper.ParseToInt(dataReader["RoleID"].ToString()); entity.RoleName = dataReader["RoleName"].ToString(); //entity.RoleDescription = dataReader["RoleDescription"].ToString(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
internal List <Habitacion> HabitacionesReservadasDisponiblesPorCambioDeFecha(Hotel hotel, DateTime desdeFecha, DateTime hastaFecha, Reserva reserva) { var query = String.Format(@"SELECT * FROM GD2C2014.LA_REVANCHA.HABITACION " + "WHERE HAB_CODIGO IN (SELECT HABRES_COD_HABITACION " + "FROM GD2C2014.LA_REVANCHA.HABITACION_RESERVA WHERE " + "HABRES_COD_RESERVA IN (SELECT RES_CODIGO FROM " + "GD2C2014.LA_REVANCHA.RESERVA WHERE RES_CODIGO <> '{0}' " + "AND RES_HOTREG_HOTEL = '{1}' AND " + "(CAST(RES_FECHA_DESDE AS DATE) BETWEEN " + "CAST('{2}' AS DATE) AND CAST('{3}' AS DATE) OR " + "CAST(RES_FECHA_HASTA AS DATE) BETWEEN CAST('{2}' AS DATE) " + "AND CAST('{3}' AS DATE)))) AND HAB_COD_HOTEL = '{1}'", reserva.identificador, hotel.identificador, DBTypeConverter.ToSQLDateTime(desdeFecha), DBTypeConverter.ToSQLDateTime(hastaFecha)); DataRowCollection dataRows = SQLUtils.EjecutarConsultaSimple(query, "GD2C2014.LA_REVANCHA.HABITACION"); if (dataRows.Count > 0) { return(dataRows.ToList <Habitacion>(this.DataRowToHab)); } else { return(new List <Habitacion>()); } }
/// <summary> /// /// </summary> /// <param name="RoleID"> </param> /// <param name="RoleName"> </param> /// <param name="RoleDescription"> </param> /// <returns></returns> public static int UpdateRole(int RoleID, string RoleName, string RoleDescription) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@RoleID", DBTypeConverter.ConvertCsTypeToOriginDBType(RoleID.GetType().ToString()), RoleID, 32), dbFactory.MakeInParam("@RoleName", DBTypeConverter.ConvertCsTypeToOriginDBType(RoleName.GetType().ToString()), RoleName, 50), dbFactory.MakeInParam("@RoleDescription", DBTypeConverter.ConvertCsTypeToOriginDBType(RoleDescription.GetType().ToString()), RoleDescription, 100) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.con), true, CommandType.StoredProcedure, "proc_Role_Update", prams); } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="OutID"> </param> /// <param name="Status"> </param> /// <returns></returns> public static int PassProductOut(Entity.ProductOut entity, decimal Used) { 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("@OutID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.OutID.GetType().ToString()), entity.OutID, 32), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_ProductOut_UpdateStatus", prams); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Insert into [PondUsed]([PondID],[Used],[SourceType],[TypeName],[CreateUser],[CreateDate]) values ('" + entity.PondID + "','" + Used + "','4','成品出库','" + entity.CreateUser + "','" + entity.CreateDate + "')", null); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [Pond] set Used='"+ Used + "'where PondID='" + entity.PondID + "'", null); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
public void CompletarFactura(Decimal codigo, Decimal cod_pago, Decimal monto) { var query = String.Format(@"UPDATE LA_REVANCHA.FACTURA SET FAC_COD_FORMA_PAGO = '{0}', FAC_TOTAL = '{1}', FAC_FECHA = '{2}' WHERE FAC_CODIGO = '{3}'", cod_pago, Math.Truncate(monto), DBTypeConverter.ToSQLDateTime(DateTime.Now), codigo); SQLUtils.EjecutarConsultaConEfectoDeLado(query); }
/// <summary> /// /// </summary> /// <param name="MenuID"> </param> /// <returns></returns> public static List <Entity.Menu> GetMenuByUser(int UserID) { List <Entity.Menu> list = new List <Entity.Menu>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@UserID", DBTypeConverter.ConvertCsTypeToOriginDBType(UserID.GetType().ToString()), UserID, 32) }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_Menu_GetByUser", prams); while (dataReader.Read()) { Entity.Menu entity = new Entity.Menu(); //entity.MenuID = DataHelper.ParseToInt(dataReader["MenuID"].ToString()); entity.MenuName = dataReader["MenuName"].ToString(); entity.MenuUrl = dataReader["MenuUrl"].ToString(); //entity.MenuDescription = dataReader["MenuDescription"].ToString(); //entity.ParentID = DataHelper.ParseToInt(dataReader["ParentID"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
public int DeleteUserPower(int iMenuId, string cUserName) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@iMenuId", DBTypeConverter.ConvertCsTypeToOriginDBType(iMenuId.GetType().ToString()), iMenuId, 0), dbFactory.MakeInParam("@cUserName", DBTypeConverter.ConvertCsTypeToOriginDBType(cUserName.GetType().ToString()), cUserName, 50) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.constr), true, CommandType.StoredProcedure, "proc_UserPower_Delete", prams); } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="MenuName"> </param> /// <param name="MenuUrl"> </param> /// <param name="MenuDescription"> </param> /// <param name="ParentID"> </param> /// <returns></returns> public static int AddMenu(string MenuName, string MenuUrl, string MenuDescription, int ParentID) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@MenuName", DBTypeConverter.ConvertCsTypeToOriginDBType(MenuName.GetType().ToString()), MenuName, 50), dbFactory.MakeInParam("@MenuUrl", DBTypeConverter.ConvertCsTypeToOriginDBType(MenuUrl.GetType().ToString()), MenuUrl, 0), dbFactory.MakeInParam("@MenuDescription", DBTypeConverter.ConvertCsTypeToOriginDBType(MenuDescription.GetType().ToString()), MenuDescription, 50), dbFactory.MakeInParam("@ParentID", DBTypeConverter.ConvertCsTypeToOriginDBType(ParentID.GetType().ToString()), ParentID, 32), dbFactory.MakeOutReturnParam() }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.con), true, CommandType.StoredProcedure, "proc_Menu_Add", prams); iReturn = int.Parse(prams[4].Value.ToString()); } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
public int UpdateUserPower(string cUserName, int iMenuId, bool bLuRu, bool bCheck, bool bUp, DateTime dUpdateDate, string cUpdateUser) { int iReturn = 0; 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), dbFactory.MakeInParam("@bLuRu", DBTypeConverter.ConvertCsTypeToOriginDBType(bLuRu.GetType().ToString()), bLuRu, 1), dbFactory.MakeInParam("@bCheck", DBTypeConverter.ConvertCsTypeToOriginDBType(bCheck.GetType().ToString()), bCheck, 1), dbFactory.MakeInParam("@bUp", DBTypeConverter.ConvertCsTypeToOriginDBType(bUp.GetType().ToString()), bUp, 1), dbFactory.MakeInParam("@dUpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(dUpdateDate.GetType().ToString()), dUpdateDate, 0), dbFactory.MakeInParam("@cUpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(cUpdateUser.GetType().ToString()), cUpdateUser, 50) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.constr), true, CommandType.StoredProcedure, "proc_UserPower_Update", prams); } catch (Exception ex) { Comm.EsbLogger.Log(ex.GetType().ToString(), ex.Message.ToString(), 0, ErrorLevel.Fatal); } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdateArea(Entity.Area 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("@ID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ID.GetType().ToString()), entity.ID, 32), dbFactory.MakeInParam("@AreaCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.AreaCode.GetType().ToString()), entity.AreaCode, 32), dbFactory.MakeInParam("@FullName", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.FullName.GetType().ToString()), entity.FullName, 20), dbFactory.MakeInParam("@LetterCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.LetterCode.GetType().ToString()), entity.LetterCode, 10), dbFactory.MakeInParam("@ShortName", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ShortName.GetType().ToString()), entity.ShortName, 20), dbFactory.MakeInParam("@IsDelete", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.IsDelete.GetType().ToString()), entity.IsDelete, 32), dbFactory.MakeInParam("@OrderID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.OrderID.GetType().ToString()), entity.OrderID, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Area_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
public static int UpdateAnalysisResult(Entity.AnalysisResult 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("@ResultID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ResultID.GetType().ToString()), entity.ResultID, 32), dbFactory.MakeInParam("@BillNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.BillNumber.GetType().ToString()), entity.BillNumber, 20), dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ItemCode.GetType().ToString()), entity.ItemCode, 20), dbFactory.MakeInParam("@Result", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Result.GetType().ToString()), entity.Result, 10) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_AnalysisResult_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="ResultID"> </param> /// <returns></returns> public static int DeleteMonitorResult(int ResultID) { 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("@ResultID", DBTypeConverter.ConvertCsTypeToOriginDBType(ResultID.GetType().ToString()), ResultID, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_MonitorResult_Delete", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// Returns folders information by Select query ignoring user rights. /// </summary> /// <param name="folderSchemaName">Folder table name.</param> /// <param name="folderIds">Unique identifiers of the folders.</param> /// <param name="userConnection">User connection.</param> /// <returns>Collection of folder information containers.</returns> public virtual List <FolderInfoModel> GetFoldersInfo(string folderSchemaName, List <Guid> folderIds, UserConnection userConnection) { List <FolderInfoModel> foldersInfo = new List <FolderInfoModel>(); Select selectQuery = new Select(userConnection) .Column("Id") .Column("Name") .Column("SearchData") .Column("FolderTypeId") .From(folderSchemaName) .Where("Id") .In(Column.Parameters(folderIds)) as Select; DBTypeConverter dbTypeConverter = userConnection.DBTypeConverter; using (DBExecutor dbExecutor = userConnection.EnsureDBConnection()) { using (IDataReader reader = selectQuery.ExecuteReader(dbExecutor)) { var nameColumnIndex = reader.GetOrdinal("Name"); var searchDataColumnIndex = reader.GetOrdinal("SearchData"); while (reader.Read()) { Guid folderId = dbTypeConverter.DBValueToGuid(reader["Id"]); string displayValue = reader.GetString(nameColumnIndex); Guid typeId = dbTypeConverter.DBValueToGuid(reader["FolderTypeId"]); byte[] searchData = reader.GetValue(searchDataColumnIndex) as byte[]; var folderInfo = new FolderInfoModel { Id = folderId, DisplayValue = displayValue, SearchDataBin = searchData, TypeId = typeId }; foldersInfo.Add(folderInfo); } } } return(foldersInfo); }