同步，报告，字体等. [英] Sync, Reports, Fonts etc..

问题描述

大家好，只是想知道我在这里真的很新，并且我正与LS一起工作几周，所以请让我回答下一个问题，例如您正在向爷爷解释一些事情:)

-是否有可能(以及如何?)同步两个lightswitch应用程序数据库，一个在Web上同步，另一个在桌面本地客户端上同步? (当然它们具有相同的表和列)

-有什么方法可以在LightSwitch中创建报告?当然，我不是在谈论DevExpress，Office集成和SQL报表.我需要一些便宜和好的解决方案，为我的客户.为什么?他们不愿意支付Office许可证，我负担不起 对于DevExpress，价格为1.800美元，我发现用SQL报告创建报告并不是一件容易的事.

-当我尝试部署(发布)我的应用程序时，如何使它可以在安装了任何dekstop PC的计算机上工作?向客户端安装应用程序时，是否每次都要进行不同的设置?

-如何更改字母字体?我希望应用中的所有字母都大20％，因为当它在大屏幕上显示时，每个人都看不到写的内容那么容易.

-如何使同一屏幕上的两个字段都可编辑，但它们来自不同的表?

相信我，还会有更多问题，因为现在我急需这两个问题的答案.

提前谢谢您

尼古拉

解决方案

alo Nidzo！

-我想可以将代码编写为同步两个数据库，但是这实际上取决于数据库(和项目)的结构，如果已经存在(外部数据源)，则可以导入两个相同"的数据库.数据源(并选择使用 只是其中之一，其他仅用于同步)，在部署时，您可以更改配置文件中的连接字符串(您将获得2)，一个指向本地数据库，另一个指向网络上同步..如果你工作 使用内部数据源，那么我想它在wcf ria服务中是可行的，但是可能还有更多工作要做.

-不确定v12，但devexpress报告的v11中的lightswitch价格为100

.也许其他方法是使用silverlight打印功能并创建自己的打印表单，但是数量所需的工作量将xtrareports的价格提高了100

价格(至少 对我来说，也许对你来说是小菜一碟..

-部署2层应用程序时，可以选择将随应用程序一起准备/安装哪些先决条件.

-在VS gallery中，您可以使用免费的扩展程序来执行某些屏幕控件所需的操作(即pixata)，但是如果您想更改应用程序的整体外观，则可以使用可扩展性工具包来创建主题扩展程序，不是很难，但可能会很长 过程.

-不确定我是否理解正确，但是您可以在屏幕上添加新的数据项(查询)并与它们一起使用，例如，使用客户查询创建可编辑的网格屏幕，然后可以将屏幕布局更改为选项卡，然后将客户纳入 第一个标签页，然后添加另一个标签页，然后在国家/地区屏幕中添加另一个数据项(查询)并将其放在第二个标签页中，因此现在您的屏幕上有两个表，每个表都是可编辑的，并且在保存更改时将其保存对于两个表.

hth ..

Kivito

Hi to everybody, just to know I`m realy new here and I`m working with LS just few weeks, so please make me answers on next questions like you`re explaining something to your grandpa :)

- Is it possible, somehow (and how?), to synchronize two lightswitch app databases one on web another one on desktop local client? (Ofcourse they have same tables and columns)

- Is there ANY way for creating reports in LightSwitch? Ofcourse, I`m not talking about DevExpress, Office integration and SQL Reports. I need some CHEAP and good solution for my client. Why? They are not willing to pay for Office license, I can`t afford 1.800$ for DevExpress, and I found not really easy creating reports with SQL reports.

- When I`m trying to deploy(publish) my application, HOW can I make it to work on ANY dekstop PC where is installed? Do I have to make different setup everytime when I`m instaling app to clients or?

- How to change letter fonts? I want all letter in app to be bigger for 20%, because when it`s showing on large screen it`s not that much easy for everyone to see what`s writen.

-How to make both fields on the same screen editable but they are from different tables?

There will be more questions, believe me, for now I urgently need answers on these two.

THank you in advance,

Nikola

解决方案

alo Nidzo!

- i guess it's possible to write code to synchronize two databases, but it really depends on structure of your database (and project), if it's already there (external data source), you can import two "same" datasources (and choose to work with just one of them, other will serve just to synchronizing purpose), when you deploy you can change connection strings in config file (you'll have them 2) for one to point on local database, and other to point on web for synchronization.. if you work with intrinsic datasource, then i guess it's doable across wcf ria service, but there could be more of work to do.. 

- not sure for v12, but v11 of devexpress reports for lightswitch price was 100

.. maybe other way is to use silverlight printing capabilities and create your own printing forms, but amount of work needed for that extends 100

price for xtrareports (at least for me, maybe for you is piece of cake).. 

- when you deploy 2 tier app, you can choose which prerequisites will be prepared/installed with your app..

- in VS gallery you have free extensions which can do what you need (ie pixata) for some screen controls, but if you want to change overall look of your app, you can create theme extension with extensibility toolkit, it's not that hard, but can be lengthy process.. 

- not sure if i understand last correctly, but you can add new data item (query) to screen and work with them both, for example you create editable grid screen with customers query, then you can change your screen layout to tabs, and put customers grid in first tab, then add another tab, after that add another data item (query) to screen like countries and put it in second tab, so now you have screen with two tables, each one is editable, and when you save changes, it's saved for both tables..

hth..

Kivito

这篇关于同步，报告，字体等.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！