puzzledalien / weeklyreport Goto Github PK
View Code? Open in Web Editor NEWThis project forked from run2948/weeklyreport
一个比较简单但是实用的周报系统
This project forked from run2948/weeklyreport
一个比较简单但是实用的周报系统
现在编译和调试运行都可以了(.net core版本),数据库的连接串如下(在Enterprise.Web.dll.config文件中),数据库已经配置为SQL授权访问,且启用了sa账户,并设置了密码。
<connectionStrings>
<add name="DefaultConnection" connectionString="Data Source=.;Initial Catalog=Enterprise;User Id =sa;Password=MY_PASSWD;" providerName="System.Data.SqlClient" />
</connectionStrings>
进入登录界面后,
估计还有什么地方没设置对?
admin账户是不是在数据库端创建的?
“注册”对应的代码是不是有什么特殊处理?
切换到.NET Framework 4.8后,
出现异常的代码如下:
public bool Insert(object obj)
{
if (obj == null)
return false;
SqlExpressionArgs args = new SqlExpressionArgs();
args.Type = SqlExpressionType.Insert;
**SqlExpression sqlExpression = RelationalMappingUnity.GetSqlExpression(obj, args);** //【异常语句】
return ExcuteSqlExpression(sqlExpression) == 1;
}
Thanks.
登录界面后,我注册了一个个人账号,在试验各种功能的过程中,记录了如下问题:
点击“周报”里面的“填写”里面的“项目名称”和“子项目”名称以及“完成情况”都是乱的,看样子是直接的编码数字,但是查询里面这些列名对应的内容是正常显示的,比较怪异!
有空请帮忙看下吧(.net core版本的,后面我就不再关注.net framework 4.8的了)。
dotnet publish后的独立程序localhost:5000/Home/Login可以访问,但IPAddress:5000/Home/Login不能访问,且对launchSettings.json做了如下改动。Publish到win-x64如此,Publish到linux-x64也是一样的效果,localhost字串好使,IP地址不好使。
"Enterprise.Web": {
"commandName": "Project",
"launchBrowser": true,
"applicationUrl": "http://0.0.0.0:5000;http://localhost:5000;",
"environmentVariables": {
"ASPNETCORE_ENVIRONMENT": "Development"
}
“设置”中的“人员”和“周报”中的“统计”下面的人员不一致,在“设置”中的“人员”删除后,并没有同步到“周报”中的“统计”下面的人员中。
dotnet publish到linux-x64上之后,出现如下问题:
说明:
程序虽然发布到了linux,但是数据库我还是连接的原来Windows上的,用了IP地址,做了协议设置。
输出为Excel时能否按照指定的人员顺序进行输出?有此需求的原因是:一个主管下面两个员工和主管做的差不多,最好能放在一起看得比较明白。
In the WeeklyReport/Sheng.Enterprise.Core/WeeklyReportManager.cs, there may be a possible bug in the function WeeklyReport GetWeeklyReport(...) .
As the data grows, the time connecting to the server is becoming longer. And it is not reliable to throw exception according to the following count value. We've encountered this issue this morning after the WeeklyReport system has been peacefully running several month.
public WeeklyReport GetWeeklyReport(Guid userId, int year, int weekOfYear)
{
int count = 0;
this._dataBase.ExecuteScalar<int>("SELECT COUNT(1) FROM [WeeklyReport]", delegate(int scalarValue)
{
count = scalarValue;
});
if (count >= 500)
{
throw new Exception("在建立与服务器的连接时出错,错误代码:5392");
}
At present, we've just changed the 500 value to 10000, and the issue has been solved. However, in the long run, there may be a better way to cope with this issue.
Huskier
您好!.net core的版本除了在集成环境中调试,可否简单地部署到Linux服务器啊?
或者,能否用docker部署?
或者,有没有部署相关的比较简单的教程什么的?
多谢!
huskier
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.