/// <summary>
/// 初始化
/// </summary>
public BaseDao(int SId, int PId, string cnKey)
{
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, cnKey);
string strSql = string.Format("select * from Sys_TreeList Where SysID = {0} and PermissionID={1}", SId, PId);
Sys.TreeListDao dao = new Sys.TreeListDao();
SysModel = dao.GetModel(SId, PId);
}
//string strTbName
/// <summary>
/// ��l��
/// </summary>
public PermissionDao(string FormID, string cnKey)
{
this.cnKey = cnKey;
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, cnKey);
string strSql = string.Format("select * from Sys_TreeList Where FormID = '{0}'", FormID);
Sys.TreeListDao dao = new Sys.TreeListDao();
SysModel = dao.GetModel(FormID);
}
//string strTbName
/// <summary>
/// 初始化
/// </summary>
public BaseDao(string FormID)
{
this.cnKey = "";
ia = DBAccessLayer.DBFactory.GetDBAccess();
string strSql = string.Format("select * from Sys_TreeList Where FormID = '{0}'", FormID);
Sys.TreeListDao dao = new Sys.TreeListDao();
SysModel = dao.GetModel(FormID);
}
public CheckDao(string FormID,string cnKey)
{
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, "");
ea = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, cnKey);
this.cnKey = cnKey;
Sys.TreeListDao dao = new Sys.TreeListDao();
SysModel = dao.GetModel(FormID);
}
//string strTbName
/// <summary>
/// ��l��
/// </summary>
public RoleDao(string FormID, string cnKey)
{
this.cnKey = cnKey;
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, cnKey);
string strSql = string.Format("select * from Sys_TreeList Where FormID = '{0}'", FormID);
Sys.TreeListDao dao = new Sys.TreeListDao();
SysModel = dao.GetModel(FormID);
tf = new TableFieldInfo(SysModel.TableName, this.cnKey);
}
/// <summary>
/// 開立資料庫
/// </summary>
/// <param name="IP"></param>
/// <param name="strDataBase"></param>
/// <param name="strPath"></param>
public bool CreateDataBase(string IP, string strDataBase, string strPath)
{
string strSysConnection = string.Format("server={0};database={1};integrated security=SSPI", IP, "master");
string strCreateDataBase = "CREATE DATABASE "+strDataBase+
" ON "+
"( NAME = " + strDataBase + "_dat, " +
"FILENAME = 'F:\\Data\\"+strDataBase+".mdf', "+
" SIZE = 10, "+
"MAXSIZE = 50, "+
"FILEGROWTH = 5 ) "+
"LOG ON "+
"( NAME = " + strDataBase + "_log, " +
" FILENAME = 'F:\\Data\\" + strDataBase + ".ldf', " +
" SIZE = 5MB, "+
" MAXSIZE = 25MB, "+
"FILEGROWTH = 5MB )";
ia = DBAccessLayer.DBFactory.GetDBAccess(strSysConnection);
ia.ExecuteNonQuerySql(strCreateDataBase);
if (File.Exists(strPath))
{
string strExcuteSQL =File.ReadAllText(strPath, Encoding.Default);
string[] strSQL = strExcuteSQL.Split(new string[] { "GO" }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < strSQL.Length; i++)
{
string str = " use " + strDataBase + " " + strSQL[i];
ia.ExecuteNonQuerySql(str);
}
return true;
}
else
{
return false;
}
}
/// <summary>
/// 测试连接是否成功
/// </summary>
/// <param name="Server"></param>
/// <param name="DatabasePrefix"></param>
/// <param name="Uid"></param>
/// <param name="Pwd"></param>
/// <param name="DataWind"></param>
/// <returns></returns>
public bool OpenConnection(string connectionString)
{
try
{
ia = DBAccessLayer.DBFactory.GetDBAccess(connectionString);
return ia.OpenConnection();
}
catch (Exception ex)
{
return false;
}
finally
{
ia.CloseConnection();
}
}
public LabelDao()
{
ia = DBAccessLayer.DBFactory.GetDBAccess();
}
public ProductionDao()
{
ia = DBAccessLayer.DBFactory.GetDBAccess();
}
public ParameterDao()
{
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, "");
}
public PermissionDao()
{
ia = DBAccessLayer.DBFactory.GetDBAccess();
}
public TreeListDao()
{
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, "");
}
public TreeListDao(string cnKey)
{
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, cnKey);
}
//string strTbName
/// <summary>
/// 初始化
/// </summary>
public MessageDao(string FormID)
{
this.cnKey = "";
this.FormID = FormID;
ia = DBAccessLayer.DBFactory.GetDBAccess();
}
//string strTbName
/// <summary>
/// 初始化
/// </summary>
public MessageDao(string FormID, string cnKey)
{
this.cnKey = "";
this.FormID = FormID;
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, cnKey);
}
public MessageDao()
{
ia = DBAccessLayer.DBFactory.GetDBAccess();
}
public CompanyDao(string cnKey)
{
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, cnKey);
}
public CompanyDao()
{
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, "");
}
public SysLabelDao()
{
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, "");
iba = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, "");
}
public BaseDao()
{
ia = DBAccessLayer.DBFactory.GetDBAccess();
}
/// <summary>
/// 测试连接是否成功
/// </summary>
/// <param name="Server"></param>
/// <param name="DatabasePrefix"></param>
/// <param name="Uid"></param>
/// <param name="Pwd"></param>
/// <param name="DataWind"></param>
/// <returns></returns>
public string GetConnection(string Server, string Database, string Uid, string Pwd, bool Authentication)
{
string strSysConnection = "";
if (Authentication)
strSysConnection = string.Format("server={0};database={1};integrated security=SSPI", Server, Database);
else
strSysConnection = string.Format("server={0};database={1};uid={2};pwd={3}", Server, Database, Uid, Pwd);
try
{
ia = DBAccessLayer.DBFactory.GetDBAccess(strSysConnection);
if (ia.OpenConnection())
return strSysConnection;
else
return "";
}
catch (Exception ex)
{
return "";
}
finally
{
ia.CloseConnection();
}
}
public EnterpriseDao()
{
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, "");
}
public ParameterDao(string cnKey)
{
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, cnKey);
}
public OrderDao()
{
ia = DBAccessLayer.DBFactory.GetDBAccess();
}
//string strTbName
/// <summary>
/// 初始化
/// </summary>
public OrderDao(string FormID)
{
this.cnKey = "";
ia = DBAccessLayer.DBFactory.GetDBAccess();
}
public CheckDao()
{
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, "");
ea = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, "");
this.cnKey = "";
}
//string strTbName
/// <summary>
/// 初始化
/// </summary>
public LabelDao(string cnKey)
{
this.cnKey = cnKey;
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, cnKey);
}
public CheckDao(string cnKey)
{
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, "");
ea = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, cnKey);
this.cnKey = cnKey;
}
//string strTbName
/// <summary>
/// 初始化
/// </summary>
public ProductionDao(string FormID, string cnKey)
{
this.cnKey = cnKey;
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, cnKey);
}
public EnterpriseDao(string cnKey)
{
ia = DBAccessLayer.DBFactory.GetDBAccess(DBAccessLayer.DBAccessType.SQL, cnKey);
}
