在下面的Windowscode中如何将3tire体系结构转换为asp.net.

问题描述

 Sqlstr = " 选择sal_det_id，comp_id，sal_id，sal_isdeduct，sal_det_desc，sal_det_hrs ，sal_det_amt作为sal_det_amt，sal_det_cpf来自" +
       "  salal_details其中sal_det_deleted = 0"  +
      "  and sal_isdeduct = 1和sal_id IN("  +
      " 从salary_master中选择sal_id，其中sal_deleted = 0"  +
      " 和sal_Year ="  + lngPreviousYear + " 和comp_id =" + strCompanyid +
      " 和emp_code ='"  + Txt_Employee.Text + " '";
       如果(vpcn.gbHalfSalary ==  true )
           Sqlstr + = "  and sal_type ="  2Half " ;
       Sqlstr + =")"  ;

                 如果(cn.State！= ConnectionState.Open)
                   cn.Open();
               cmdTemp.Connection = cn;
               cmdTemp.CommandText = strSql;
               drTemp = cmdTemp.ExecuteReader();
               而(drTemp.Read())
               {
                   dblTempVal = 0;
                   if(drTemp [" sal_det_amt "  ].ToString()！= string.Empty& cfs .IsNumeric(drTemp [" sal_det_amt "  ].ToString()))
                       dblTempVal = Convert.ToDouble(drTemp [" sal_det_amt "  ].ToString());

                   if(drTemp [" sal_det_desc "  ].ToString()==" Employee CPF " )
                   {
                       dblTempCPF = dblTempCPF + dblTempVal;
                   }
                   否则，如果(drTemp [" sal_det_desc "  ].ToString()== vpcn.cMBMF)
                   {
                       dblTempMBF = dblTempMBF + dblTempVal;
                   }
                   否则，如果(drTemp [" sal_det_desc "  ].ToString()==" SINDA "  || drTemp ["  sal_det_desc " ].ToString()== vpcn.cECF || drTemp [" sal_det_desc "  ].ToString()== vpcn.cCDAC)
                   {
                       dblTempFund = dblTempFund + dblTempVal;
                   }

               } drTemp.Close();  

解决方案

这篇关于在下面的Windowscode中如何将3tire体系结构转换为asp.net.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！