问题描述
@后面没有字下面是代码请问什么问题很简单的代码我怎么都找不出问题前端页面TongjiBLLTongjiBLL=newTongjiBLL();Model.TongjiTongji=newModel.Tongji();Tongji.t_date=System.DateTime.Now.ToString();Tongji.t_liuchu=0;Tongji.t_liuru=M;Tongji.t_rzhuce=0;Tongji.t_tzhuce=0;Tongji.t_shenqinge=0;Tongji.t_chengjiaoe=0;if(TouziBLL.Chongzhi(Touzi)==true&&TongjiBLL.CreateWorks(Tongji)==true)Response.Write("<script>alert('充值成功！');location='Login.aspx'</script>");elseClientScript.RegisterClientScriptBlock(this.GetType(),"ErrorModify",@"<script>alert(""充值失败！"")</script>");BLL代码：publicboolCreateWorks(TongjiTongji){return_TongjiDAL.InsertOneRecord(Tongji);}DAL代码：publicboolInsertOneRecord(TongjiTongji){if(IsExist(Tongji.t_id)==false){stringsqlStr="insertintoWorks(t_chengjiaoe,t_date,t_liuchu,t_liuru,.t_rzhuce,t_shenqinge,t_tzhuce)"+"values(@t_chengjiaoe,@t_date,@t_liuchu,@t_liuru,@.t_rzhuce,@t_shenqinge,@t_tzhuce)";//设置Sql参数数组,SqlParameter[]SqlParam=newSqlParameter[7];SqlParam[0]=newSqlParameter("@t_chengjiaoe",Tongji.t_chengjiaoe);SqlParam[1]=newSqlParameter("@t_date",Tongji.t_date);SqlParam[2]=newSqlParameter("@t_liuchu",Tongji.t_liuchu);SqlParam[3]=newSqlParameter("@t_liuru",Tongji.t_liuru);SqlParam[4]=newSqlParameter("@t_rzhuce",Tongji.t_rzhuce);SqlParam[5]=newSqlParameter("@t_shenqinge",Tongji.t_shenqinge);SqlParam[6]=newSqlParameter("@t_tzhuce",Tongji.t_tzhuce);//执行Sql语句，并返回受影响的记录行数intresult=ExecuteNonQuery(sqlStr,SqlParam);//成功返回true，失败返回falseif(result==1)returntrue;elsereturnfalse;}elsereturnfalse;}Model代码：#region类字段privateint_t_id;privateint_t_liuru;privateint_t_liuchu;privateint_t_tzhuce;privateint_t_rzhuce;privateint_t_chengjiaoe;privateint_t_shenqinge;privatestring_t_date;#endregion#region类属性publicintt_id//电话{set{_t_id=value;}get{return_t_id;}}publicintt_liuru//电话{set{_t_liuru=value;}get{return_t_liuru;}}publicintt_liuchu//电话{set{_t_liuchu=value;}get{return_t_liuchu;}}publicintt_tzhuce//电话{set{_t_tzhuce=value;}get{return_t_tzhuce;}}publicintt_rzhuce//电话{set{_t_rzhuce=value;}get{return_t_rzhuce;}}publicintt_chengjiaoe//电话{set{_t_chengjiaoe=value;}get{return_t_chengjiaoe;}}publicintt_shenqinge//电话{set{_t_shenqinge=value;}get{return_t_shenqinge;}}publicstringt_date//电话{set{_t_date=value;}get{return_t_date;}}#endregion
解决方案
解决方案二：
@.t_rzhuce多了一个句点
解决方案三：
哈哈，楼上正解呀，太粗心了
解决方案四：
.t_rzhuce
解决方案五：
设定了参数变量,值却没配上.if(IsExist(Tongji.t_id)==false){stringsqlStr="insertintoWorks(t_chengjiaoe,t_date,t_liuchu,t_liuru,.t_rzhuce,t_shenqinge,t_tzhuce)"+"values(@t_chengjiaoe,@t_date,@t_liuchu,@t_liuru,@.t_rzhuce,@t_shenqinge,@t_tzhuce)"