为什么把
strUpdateSQL = "UPDATE E_NtnLoan SET FromDate='" + agreementDate.ToString() + "', AgreementId='" + schId + year + "'+(SELECT IdCardNum FROM StuInfo,E_NtnLoan WHERE StuInfo.Id=E_NtnLoan.StuInfoId AND Eid=" + arrIds[i] + ") WHERE Eid=" + arrIds[i] + "";
UpdateDb();
语句放在程序段里面和其他的程序一起执行时候
sb.Append(" update debtmoney ");
sb.Append(" set govrate=case ");
sb.Append(" when cast('" + de.ToShortDateString() + "' as smalldatetime ) < cast((CAST(EduYear + JionYear + ExtYear AS varchar) + '-' + CAST(ExtMonth + 8 AS varchar) + '-' + cast(ExtDay + 1 AS varchar)) as smalldatetime ) then govrate +" + ntnloan_lendmoney + "*" + rate + " "); sb.Append(" else govrate ");
sb.Append(" end , ");
sb.Append(" shouldrate=case ");
sb.Append(" when cast('" + de.ToShortDateString() + "' as smalldatetime ) >= cast((CAST(EduYear + JionYear + ExtYear AS varchar) + '-' + CAST(ExtMonth + 8 AS varchar) + '-' + cast(ExtDay + 1 AS varchar)) as smalldatetime ) then shouldrate+" + ntnloan_lendmoney + "*" + rate + " "); sb.Append(" else shouldrate ");
sb.Append(" end ");
sb.Append(" from debtmoney inner join stuinfo on debtmoney.stuinfoid=stuinfo.Id where debtmoney.stuinfoid="+stuinfoid+" ");
dp.CommandText = sb.ToString();
dp.ExecuteNonQuery();
这个语句产生的结果就不对 当把这个语句去掉以后就正确啊 为什么恩啊
而且把这个语句放在前面和后面
sb.Append(" update debtmoney ");
sb.Append(" set govrate=case ");
sb.Append(" when cast('" + de.ToShortDateString() + "' as smalldatetime ) < cast((CAST(EduYear + JionYear + ExtYear AS varchar) + '-' + CAST(ExtMonth + 8 AS varchar) + '-' + cast(ExtDay + 1 AS varchar)) as smalldatetime ) then govrate +" + ntnloan_lendmoney + "*" + rate + " "); sb.Append(" else govrate ");
sb.Append(" end , ");
sb.Append(" shouldrate=case ");
sb.Append(" when cast('" + de.ToShortDateString() + "' as smalldatetime ) >= cast((CAST(EduYear + JionYear + ExtYear AS varchar) + '-' + CAST(ExtMonth + 8 AS varchar) + '-' + cast(ExtDay + 1 AS varchar)) as smalldatetime ) then shouldrate+" + ntnloan_lendmoney + "*" + rate + " "); sb.Append(" else shouldrate ");
sb.Append(" end ");
sb.Append(" from debtmoney inner join stuinfo on debtmoney.stuinfoid=stuinfo.Id where debtmoney.stuinfoid="+stuinfoid+" ");
dp.CommandText = sb.ToString();
dp.ExecuteNonQuery();
这部分执行的结果不一样
govrate 总是为0 啊 而且
sb.Append(" update debtmoney ");
sb.Append(" set govrate=case ");
sb.Append(" when cast('" + de.ToShortDateString() + "' as smalldatetime ) < cast((CAST(EduYear + JionYear + ExtYear AS varchar) + '-' + CAST(ExtMonth + 8 AS varchar) + '-' + cast(ExtDay + 1 AS varchar)) as smalldatetime ) then govrate +" + ntnloan_lendmoney + "*" + rate + " "); sb.Append(" else govrate ");
sb.Append(" end , ");
sb.Append(" shouldrate=case ");
sb.Append(" when cast('" + de.ToShortDateString() + "' as smalldatetime ) >= cast((CAST(EduYear + JionYear + ExtYear AS varchar) + '-' + CAST(ExtMonth + 8 AS varchar) + '-' + cast(ExtDay + 1 AS varchar)) as smalldatetime ) then shouldrate+" + ntnloan_lendmoney + "*" + rate + " "); sb.Append(" else shouldrate ");
sb.Append(" end ");
sb.Append(" from debtmoney inner join stuinfo on debtmoney.stuinfoid=stuinfo.Id where debtmoney.stuinfoid="+stuinfoid+" ");
dp.CommandText = sb.ToString();
dp.ExecuteNonQuery();
在这里 后半个语句就可以正常执行 前半个就不能正常执行啊
而且在查询分析器上我写的流就能正常执行啊
strUpdateSQL = "UPDATE E_NtnLoan SET FromDate='" + agreementDate.ToString() + "', AgreementId='" + schId + year + "'+(SELECT IdCardNum FROM StuInfo,E_NtnLoan WHERE StuInfo.Id=E_NtnLoan.StuInfoId AND Eid=" + arrIds[i] + ") WHERE Eid=" + arrIds[i] + "";
UpdateDb();
语句放在程序段里面和其他的程序一起执行时候
sb.Append(" update debtmoney ");
sb.Append(" set govrate=case ");
sb.Append(" when cast('" + de.ToShortDateString() + "' as smalldatetime ) < cast((CAST(EduYear + JionYear + ExtYear AS varchar) + '-' + CAST(ExtMonth + 8 AS varchar) + '-' + cast(ExtDay + 1 AS varchar)) as smalldatetime ) then govrate +" + ntnloan_lendmoney + "*" + rate + " "); sb.Append(" else govrate ");
sb.Append(" end , ");
sb.Append(" shouldrate=case ");
sb.Append(" when cast('" + de.ToShortDateString() + "' as smalldatetime ) >= cast((CAST(EduYear + JionYear + ExtYear AS varchar) + '-' + CAST(ExtMonth + 8 AS varchar) + '-' + cast(ExtDay + 1 AS varchar)) as smalldatetime ) then shouldrate+" + ntnloan_lendmoney + "*" + rate + " "); sb.Append(" else shouldrate ");
sb.Append(" end ");
sb.Append(" from debtmoney inner join stuinfo on debtmoney.stuinfoid=stuinfo.Id where debtmoney.stuinfoid="+stuinfoid+" ");
dp.CommandText = sb.ToString();
dp.ExecuteNonQuery();
这个语句产生的结果就不对 当把这个语句去掉以后就正确啊 为什么恩啊
而且把这个语句放在前面和后面
sb.Append(" update debtmoney ");
sb.Append(" set govrate=case ");
sb.Append(" when cast('" + de.ToShortDateString() + "' as smalldatetime ) < cast((CAST(EduYear + JionYear + ExtYear AS varchar) + '-' + CAST(ExtMonth + 8 AS varchar) + '-' + cast(ExtDay + 1 AS varchar)) as smalldatetime ) then govrate +" + ntnloan_lendmoney + "*" + rate + " "); sb.Append(" else govrate ");
sb.Append(" end , ");
sb.Append(" shouldrate=case ");
sb.Append(" when cast('" + de.ToShortDateString() + "' as smalldatetime ) >= cast((CAST(EduYear + JionYear + ExtYear AS varchar) + '-' + CAST(ExtMonth + 8 AS varchar) + '-' + cast(ExtDay + 1 AS varchar)) as smalldatetime ) then shouldrate+" + ntnloan_lendmoney + "*" + rate + " "); sb.Append(" else shouldrate ");
sb.Append(" end ");
sb.Append(" from debtmoney inner join stuinfo on debtmoney.stuinfoid=stuinfo.Id where debtmoney.stuinfoid="+stuinfoid+" ");
dp.CommandText = sb.ToString();
dp.ExecuteNonQuery();
这部分执行的结果不一样
govrate 总是为0 啊 而且
sb.Append(" update debtmoney ");
sb.Append(" set govrate=case ");
sb.Append(" when cast('" + de.ToShortDateString() + "' as smalldatetime ) < cast((CAST(EduYear + JionYear + ExtYear AS varchar) + '-' + CAST(ExtMonth + 8 AS varchar) + '-' + cast(ExtDay + 1 AS varchar)) as smalldatetime ) then govrate +" + ntnloan_lendmoney + "*" + rate + " "); sb.Append(" else govrate ");
sb.Append(" end , ");
sb.Append(" shouldrate=case ");
sb.Append(" when cast('" + de.ToShortDateString() + "' as smalldatetime ) >= cast((CAST(EduYear + JionYear + ExtYear AS varchar) + '-' + CAST(ExtMonth + 8 AS varchar) + '-' + cast(ExtDay + 1 AS varchar)) as smalldatetime ) then shouldrate+" + ntnloan_lendmoney + "*" + rate + " "); sb.Append(" else shouldrate ");
sb.Append(" end ");
sb.Append(" from debtmoney inner join stuinfo on debtmoney.stuinfoid=stuinfo.Id where debtmoney.stuinfoid="+stuinfoid+" ");
dp.CommandText = sb.ToString();
dp.ExecuteNonQuery();
在这里 后半个语句就可以正常执行 前半个就不能正常执行啊
而且在查询分析器上我写的流就能正常执行啊
解决方案 »
- System.Web.UI.WebControlS 命名空间问题求解
- 获取Mp3文件信息
- aspnet中如何用 变量 获得有返回值的javascript 方法
- formview datalist repeater 控件使用区别是什么?
- 求一个正则表达式,谢谢!顶者有分!!
- XML属性中如何禁止特殊字符?!!
- SQL报错:键列信息不足或不正确,更新影响到多行,是什么错?
- 大家帮忙解决一个问题,对我来说简直是“致命问题”
- 关于DataGrid的Attributes属性
- 请问用lotus notes 和 vs.net开发一个公司的OA系统分别需要多少钱(包括软件开发和硬件)
- 制作网站奇怪的问题
- 关于javascritp的疑问
select columnA,columnB
from aa
在查询分析器中可以执行,但是在拼字符串中,你拼成的字符串就成了select columnA,columnBfrom aa. 少了一个空格.还查询分析器支持的,.net的那玩意未必能支持.比如说GO,其它的有待探索...