public void Init(string ClientCode, string DbName)
{
Data.DBConnection dbConn = Data.DBConfig.GetDBConnection(ClientCode, DbName);
CurrentClient.Disconnected += CurrentClient_Disconnected;
DataAdapterClient adaClient = new DataAdapterClient(CurrentClient);
dictClient[CurrentClient.ClientId] = adaClient;
}
/// <summary>
/// 执行查询SQL语句，返回第一行第一列值
/// </summary>
/// <param name="ClientCode">客户端代码</param>
/// <param name="DbName">数据库名称</param>
/// <param name="TransID">事务ID</param>
/// <param name="SqlText">Sql 文本</param>
/// <param name="SqlParams">Sql 参数，参数值所在位置必须与参数名一致</param>
/// <returns>返回字符串</returns>
public string QueryScalar(string ClientCode, string DbName, string TransID, string SqlText, object[] SqlParams)
{
Data.DBConnection dbConn = Data.DBConfig.GetDBConnection(ClientCode, DbName);
LogClientTransaction(TransID);
IDataClient idc = GetDataClient(dbConn.DBType);
return(idc.QueryScalar(TransID, dbConn.ConnectionString, SqlText, SqlParams));
}
public void UpdateTenantExitDate(Tenant _tenant)
{
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "TenantID", value: _tenant.TenantID)
, new SqlParameter(parameterName: "DateofExit", value: _tenant.DOE) };
dbCon.ExecuteReader("BE_Update_TenantExitDatebyID", sqlParams);
}
}
/// <summary>
/// 执行分页存储过程
/// </summary>
/// <param name="ClientCode">客户端代码</param>
/// <param name="DbName">数据库名称</param>
/// <param name="TransID">事务ID</param>
/// <param name="ProcedureName">存储过程名</param>
/// <param name="Params">参数列表</param>
/// <returns>返回数据集</returns>
public int QueryProcedurePaging(string ClientCode, string DbName, string TransID, string ProcedureName, Dictionary <string, object> Params)
{
Data.DBConnection dbConn = Data.DBConfig.GetDBConnection(ClientCode, DbName);
LogClientTransaction(TransID);
IDataClient idc = GetDataClient(dbConn.DBType);
DbDataReader reader = idc.QueryProcedurePaging(TransID, dbConn.ConnectionString, ProcedureName, Params);
pagingDic.Add(++nowPageingId, reader);
return(nowPageingId);
}
public void UpdateEmployeeDetails(Employee _employee)
{
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "EmployeeID", value: _employee.EmployeeID)
, new SqlParameter(parameterName: "EmployeeName", value: _employee.EmployeeName)
, new SqlParameter(parameterName: "EmployeeEmail", value: _employee.EmployeeEmail)
, new SqlParameter(parameterName: "EmployeePhoneNumber", value: _employee.EmployeePhoneNumber)
, new SqlParameter(parameterName: "LoginPassword", value: _employee.LoginPassword) };
dbCon.ExecuteReader("BE_Update_EmployeeDetailsbyID", sqlParams);
}
}
public void UpdateTenantDetails(Tenant _tenant)
{
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "TenantID", value: _tenant.TenantID)
, new SqlParameter(parameterName: "TenantName", value: _tenant.Name)
, new SqlParameter(parameterName: "TenantEmail", value: _tenant.Email)
, new SqlParameter(parameterName: "TenantPhoneNumber", value: _tenant.PhoneNo)
, new SqlParameter(parameterName: "LoginPassword", value: _tenant.LoginPassword) };
dbCon.ExecuteReader("BE_Update_TenantDetailsbyID", sqlParams);
}
}
public Tenant GetTenantDetails(int TenantID)
{
Tenant _tenantDetails = null;
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "TenantID", value: TenantID) };
DataSet dsTenantDetails = dbCon.ExecuteReader("BE_Get_TenantDetailsbyID", sqlParams);
if (dsTenantDetails != null && dsTenantDetails.Tables.Count > 0 && dsTenantDetails.Tables[0].Rows.Count > 0)
{
_tenantDetails = new Tenant();
_tenantDetails.TenantID = Convert.ToInt32(dsTenantDetails.Tables[0].Rows[0]["TenantID"]);
_tenantDetails.TenantName = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["TenantName"]);
_tenantDetails.BranchDetails.BranchID = Convert.ToInt32(dsTenantDetails.Tables[0].Rows[0]["BranchID"]);
_tenantDetails.BranchDetails.City = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["City"]);
_tenantDetails.BranchDetails.BranchName = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["BranchName"]);
_tenantDetails.BranchDetails.BranchAddress = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["BranchAddress"]);
_tenantDetails.BranchDetails.PhoneNumber = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["PhoneNumber"]);
_tenantDetails.BranchDetails.EmailAddress = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["EmailAddress"]);
_tenantDetails.BranchDetails.Gender = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["Gender"]);
_tenantDetails.BranchDetails.BranchStatus = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["BranchStatus"]);
_tenantDetails.RoomNumber = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["RoomNo"]);
if (dsTenantDetails.Tables[0].Rows[0]["TenantDOB"] != DBNull.Value)
{
_tenantDetails.DOB = Convert.ToDateTime(dsTenantDetails.Tables[0].Rows[0]["TenantDOB"]);
}
if (dsTenantDetails.Tables[0].Rows[0]["DateofJoin"] != DBNull.Value)
{
_tenantDetails.DOJ = Convert.ToDateTime(dsTenantDetails.Tables[0].Rows[0]["DateofJoin"]);
}
if (dsTenantDetails.Tables[0].Rows[0]["DateofExit"] != DBNull.Value)
{
_tenantDetails.DOE = Convert.ToDateTime(dsTenantDetails.Tables[0].Rows[0]["DateofExit"]).ToString("yyyy-MM-dd");
}
_tenantDetails.PaymentDate = Convert.ToDateTime(dsTenantDetails.Tables[0].Rows[0]["PaymentDate"]);
_tenantDetails.MonthofPayment = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["PaymentMonth"]);
_tenantDetails.MonthlyRent = Convert.ToDouble(dsTenantDetails.Tables[0].Rows[0]["Rent"]);
_tenantDetails.Name = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["TenantName"]);
_tenantDetails.LoginPassword = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["LoginPassword"]);
_tenantDetails.Email = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["TenantEmail"]);
_tenantDetails.PhoneNo = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["TenantPhoneNumber"]);
}
}
return(_tenantDetails);
}
public IEnumerable <MenuItem> GetMenuByDesignation(int designationID)
{
List <MenuItem> _menuItems = null;
using (DBConnection dbcon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "DesignationID"
, value: designationID) };
DataSet dsMenuDetails = dbcon.ExecuteReader("BE_Get_MenuAccessByDesignation", sqlParams);
if (dsMenuDetails != null && dsMenuDetails.Tables.Count > 0 && dsMenuDetails.Tables[0].Rows.Count > 0)
{
_menuItems = (from row in dsMenuDetails.Tables[0].AsEnumerable()
select new MenuItem
{
MenuID = row.Field <int>("MenuID"),
MenuName = row.Field <string>("MenuName"),
MenuImage = row.Field <string>("MenuImage"),
MenuStatus = row.Field <string>("MenuStatus"),
URL = row.Field <string>("URL"),
}).ToList();
}
}
return(_menuItems);
}
public User GetUserDetails(string userName, string password)
{
User _userDetails = null;
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "UserName", value: userName),
//new SqlParameter(parameterName:"Password",value:Encrypt.DecryptString(password)) };
new SqlParameter(parameterName: "Password", value: password) };
DataSet dsUserDetails = dbCon.ExecuteReader("BE_Get_LoginUserDetails", sqlParams);
if (dsUserDetails != null && dsUserDetails.Tables.Count > 0 && dsUserDetails.Tables[0].Rows.Count > 0)
{
_userDetails = new User();
_userDetails.ID = Convert.ToInt32(dsUserDetails.Tables[0].Rows[0]["ID"]);
_userDetails.LoginName = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["LoginName"]);
_userDetails.TenantID = Convert.ToInt32(dsUserDetails.Tables[0].Rows[0]["TenantID"]);
_userDetails.EmployeeID = Convert.ToInt32(dsUserDetails.Tables[0].Rows[0]["EmployeeID"]);
_userDetails.DesignationID = Convert.ToInt32(dsUserDetails.Tables[0].Rows[0]["DesignationID"]);
_userDetails.Designation = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["DesignationName"]);
}
}
return(_userDetails);
}
