internal void GetSongsFromTableTestOfRetrieval([PexAssumeUnderTest] DatabaseConn target)
{
target.GetSongsFromTable();
// TODO: add assertions to method DatabaseConnTestOfDatabases.GetSongsFromTableTestOfRetrieval(DatabaseConn)
}
public List <Publication> loadPublicationsFor(Researher r)
{
//loading pulication controller with publication detail for researcher
publication = DatabaseConn.fetchFullPublicationDetail(r.id).OrderByDescending(o => o.Year).ToList();;
//sending publication details of a researcher
return(publicat);
}
/// <summary>
/// 通过协同userid，systemkey=1来转化成 单点登入统一唯一标识；
/// </summary>
/// <param name="erp_userid">协同userid</param>
/// <param name="systemkey">协同系统标识，暂为1</param>
/// <returns>返回单点登录的唯一用户表示</returns>
private static string getUserKey(string erp_userid, string systemkey)
{
object userKey;
SqlConnection sqlConnection = (SqlConnection)DatabaseConn.Connection("wechat");
using (LiLanzDALForXLM dal = new LiLanzDALForXLM(sqlConnection.ConnectionString))
{
sqlConnection.Close(); sqlConnection.Dispose();
string str_sql = @"select a.userid
from wx_t_appauthorized a
where a.systemid=@systemkey and a.systemkey=@userid";
List <SqlParameter> para = new List <SqlParameter>();
para.Add(new SqlParameter("@userid", erp_userid));
para.Add(new SqlParameter("@systemkey", systemkey));
if (dal.ExecuteQueryFastSecurity(str_sql, para, out userKey) == "")
{
return(userKey.ToString());
}
else
{
return("");
}
}
}
public static bool IsExists(DatabaseConn dbconn, string sqlstring, SqlParameter[] param)
{
bool flag = false;
if (Convert.ToInt32(ExecScalar(dbconn, sqlstring, param)) > 0)
{
flag = true;
}
return(flag);
}
public static object ExecScalar(DatabaseConn dbconn, string sqlstring, SqlParameter[] param)
{
SqlCommand cmd = new SqlCommand();
using (SqlConnection connection = GetConnection(dbconn))
{
PreparedCommand(cmd, connection, CommandType.Text, sqlstring, param);
return(cmd.ExecuteScalar());
}
}
public static int ExecNonQuery(DatabaseConn dbconn, string sqlstring, SqlParameter[] param)
{
int num;
using (SqlConnection connection = GetConnection(dbconn))
{
using (SqlCommand command = new SqlCommand())
{
PreparedCommand(command, connection, CommandType.Text, sqlstring, param);
num = command.ExecuteNonQuery();
}
}
return(num);
}
public static DataTable ExecSql(DatabaseConn dbconn, string sqlstring, SqlParameter[] param)
{
DataTable dataTable = new DataTable();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter adapter = new SqlDataAdapter();
using (SqlConnection connection = GetConnection(dbconn))
{
PreparedCommand(cmd, connection, CommandType.Text, sqlstring, param);
adapter.SelectCommand = cmd;
adapter.Fill(dataTable);
}
return(dataTable);
}
public static DataTable ExecSql(DatabaseConn dbconn, string sqlstring)
{
DataTable dataTable = new DataTable();
using (SqlConnection connection = GetConnection(dbconn))
{
using (SqlDataAdapter adapter = new SqlDataAdapter(sqlstring, connection))
{
connection.Open();
adapter.Fill(dataTable);
}
}
return(dataTable);
}
public static DataTable ExePro(DatabaseConn dbconn, string procedure, SqlParameter[] param)
{
DataTable dataTable = new DataTable();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter adapter = new SqlDataAdapter();
using (SqlConnection connection = GetConnection(dbconn))
{
PreparedCommand(cmd, connection, CommandType.StoredProcedure, procedure, param);
cmd.CommandTimeout = 120;
adapter.SelectCommand = cmd;
adapter.Fill(dataTable);
}
return(dataTable);
}
public static int ExecNonQuery(DatabaseConn dbconn, string sqlstring, SqlParameter param)
{
int num;
using (SqlConnection connection = GetConnection(dbconn))
{
using (SqlCommand command = new SqlCommand(sqlstring, connection))
{
connection.Open();
command.Parameters.Add(param);
num = command.ExecuteNonQuery();
}
}
return(num);
}
public static object ExecScalar(DatabaseConn dbconn, string sqlstring, SqlParameter param)
{
object obj2;
using (SqlConnection connection = GetConnection(dbconn))
{
using (SqlCommand command = new SqlCommand(sqlstring, connection))
{
connection.Open();
command.Parameters.Add(param);
obj2 = command.ExecuteScalar();
}
}
return(obj2);
}
public static DataTable ExecSql(DatabaseConn dbconn, string sqlstring, SqlParameter param)
{
DataTable dataTable = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter();
using (SqlConnection connection = GetConnection(dbconn))
{
using (SqlCommand command = new SqlCommand(sqlstring, connection))
{
command.Parameters.Add(param);
adapter.SelectCommand = command;
adapter.Fill(dataTable);
}
}
return(dataTable);
}
public ResearcherController()
{
researchers = DatabaseConn.fetchFullResearcherDetail().OrderBy(o => o.GivenName).ToList();
viewableresearchers = new ObservableCollection <Researher>(researchers); //this list we will modify later
foreach (Researher e in researchers)
{
PublicationController p = new PublicationController();
e.publish = p.loadPublicationsFor(e);
e.position = DatabaseConn.loadPositionFor(e.id);
if (e.types == type.Staff)
{
e.sup_student = DatabaseConn.fetchSupervision(e.id);
e.calculateStaff(e.publish);
}
e.previousJobDetail();
}
}
public static SqlDataReader ExecDataReader(DatabaseConn dbconn, string sqlstring, SqlParameter param)
{
SqlDataReader reader;
SqlConnection connection = GetConnection(dbconn);
try
{
connection.Open();
SqlCommand command = new SqlCommand(sqlstring, connection);
command.Parameters.Add(param);
reader = command.ExecuteReader();
}
catch (SqlException exception)
{
throw exception;
}
return(reader);
}
public CoursesController(DatabaseConn context)
{
_context = context;
}
public EmployeesController(DatabaseConn context)
{
_context = context;
}
public StudentsController(DatabaseConn context)
{
_context = context;
}
public HomeController(ILogger <HomeController> logger, DatabaseConn db, Istudent rep)
{
_logger = logger;
Db = db;
this.rep = rep;
}
private static SqlConnection GetConnection(DatabaseConn dbconn)
{
return(new SqlConnection(ConfigurationManager.ConnectionStrings[dbconn.ToString()].ConnectionString));
}
