有关sql server和c#的简单问题

本文介绍了有关sql server和c#的简单问题的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

大家好. 我不知道该怎么做.我们有使用我们的运输服务的客户.我构造了名称为Debt的sql server表，该表与传输ID和客户端ID相关联.客户总是在月底付款.我该如何使用c#或sql server对从月初到月末的所有条目进行计数? 对不起，我的英语不好. 我希望我的问题是可以理解的. 请给我一些建议...

Hi everybody. I cant ponder how to do that. We have clients who use our transportation service. I constructed sql server table with name Debt its relationed with transportation ID and client ID. Clients always pay money at end of month. How can i do with c# or sql server that count all entries from month begining to end of month ? Sorry for my bad English. I hope that my question is understandable. Please Advice me something...

推荐答案

据我所知， As i understand ur question, Select count(*) from tablename where paidDate >= ''01/11/2010'' and paidDate <= ''30/11/2010''

首先，设计数据花瓶表，以便可以捕获所有数据. 现在，假设transporationID与ClientID相关，则使用整个月.它会给出类似该transportID * 30天的运输费用！ 因此，一般来说，您需要用成本捕获所有使用的天数，然后最后为该客户编写查询并获取所有数据. Well, first of all design the datavase tables such that you can capture all data. For now, assuming once a transporationID is related to a ClientID, whole month is used. It would give something like, transportation cost of that transportationID * 30 days! Thus, to be generic, you need to capture all the used days with cost and then at the end write a query for that client and get all data.

首先，您获得上个月的金额并将其保留在一个变量中， First u get the last month amount and keep it in one variable, Select Sum(amount) from tablename where paidDate >= ''01/11/2010'' and paidDate <= ''30/11/2010''

然后，

then,

insert into tablename(remain_amount) values(last_amount - 1000)

1000是当前输入的金额.

1000 is the currenty entered amount.