private List <DATA_APP_ESIGN> GetFileListApp(string appno)
{
DBConnectData cn = new DBConnectData();
object[] sqlParams =
{
new SqlParameter("@APPNO", appno),
};
var res = cn.Database.SqlQuery <DATA_APP_ESIGN>("SP_getfile_app @APPNO", sqlParams).ToList();
return(res);
}
public CreateDatabaseWindow(DBConnectData dbConnectData)
{
InitializeComponent();
enlargementStoryboard = (Storyboard)Resources["EnlargementStoryBoard"];
enlargementAnimation = (DoubleAnimation)enlargementStoryboard.Children[0];
this.dbConnectData = dbConnectData;
DBFormatEdit.ItemsSource = EnumTitlesKeeper <DBFormat> .GetItemsList <EnumItem>();
DBFormatEdit.SetBinding(ListBoxEdit.EditValueProperty, new Binding("DBFormat")
{
Source = dbConnectData, Mode = BindingMode.TwoWay
});
SqlServerEdit.SetBinding(TextEdit.TextProperty, new Binding("Server")
{
Source = dbConnectData, Mode = BindingMode.TwoWay
});
SqlDatabaseEdit.SetBinding(TextEdit.TextProperty, new Binding("SqlDBName")
{
Source = dbConnectData
});
MdbDatabaseEdit.SetBinding(TextEdit.TextProperty, new Binding("MdbPath")
{
Source = dbConnectData
});
LoginEdit.SetBinding(TextEdit.TextProperty, new Binding("Login")
{
Source = dbConnectData, Mode = BindingMode.TwoWay
});
PasswordEdit.SetBinding(TextEdit.TextProperty, new Binding("Password")
{
Source = dbConnectData, Mode = BindingMode.TwoWay
});
AuthenticationTypeEdit.ItemsSource = EnumTitlesKeeper <SqlAuthenticationType> .GetItemsList <EnumItem>();
AuthenticationTypeEdit.SetBinding(ListBoxEdit.EditValueProperty, new Binding("SqlAuthenticationType")
{
Source = dbConnectData, Mode = BindingMode.TwoWay
});
}
public void Show(DBConnectData dbConnectData)
{
wnd = new CreateDatabaseWindow(dbConnectData);
}
public AccountDao()
{
db = new DBConnectData();
}
public static OleDbConnection opentwo()
{
return(DBConnectData.getConnecion2(_PATH));
}
public CodeDao()
{
db = new DBConnectData();
}
