中层副层以下的有C6人员必须在报销时关联出差记录对比。

最新推荐文章于 2012-10-22 14:10:30 发布

tzjly

最新推荐文章于 2012-10-22 14:10:30 发布

阅读量1.5k

点赞数

分类专栏：金和C6 文章标签： dataset c string function sql

本文链接：https://blog.csdn.net/tzjly/article/details/7886611

版权

金和C6 专栏收录该内容

44 篇文章 1 订阅

订阅专栏

//由原功能关联后对应报销，改为仅显示对比。

function checkhaveC6()
{
	var S11 = txtBaoXiaoRen.value;
               S11=S11.substr(8);
           var sql = "select count(*) as icount from  users where username='"+ S11 +"' ";
	var icount = SqlToField(sql);
          //alert(icount);
	if (icount ==0 )
	{
	//alert("无C6账户");
           labelC6.value=0;
         //  SetRead();

	}

             if (icount ==1 )
               {   
          //  alert("有C6账户");
            labelC6.value=1;
         // SetRead();

              }
	
}

          if((dataset4.RecordCount==1)&&(dataset4.Fields.Field['a'].Value=="")&&(labelC6.value=='1')&&(txtzhibie.value!='中层副级')&&(txtzhibie.value!='中层正级')&&(txtzhibie.value!='高管副级')&&(txtzhibie.value!='高管正级'))
           {
           return "请点击“调用报销人出差记录”，选择本次报销相关的记录并确定！";
             }

//附出差查询表单的函数
var leixing="";
function PageInt()
{
    var baoxiaoren =parent.Request.QueryString('baoxiaoren').toString();
    leixing =parent.Request.QueryString('leixing').toString();
    baoxiaoren=baoxiaoren.substr(8);
   //alert(baoxiaoren);
   //var sql="select com_dep,reg_name,atte_begintime,atte_limit,atte_reason from JHHR_Attendance_EvectionDetail where reg_name like '%"+baoxiaoren+"'";
    var sql="select com_dep,reg_name,atte_begintime,atte_begintime+atte_limit as Endtime ,atte_limit,atte_reason from JHHR_Attendance_EvectionDetail where reg_name like '%"+baoxiaoren+"'";

    sql+=" order by atte_begintime desc";
    dataset1.Open(sql);
}

function Confirm()
{
     var string="";
     var len=dataset1.RecordCount;
     dataset1.MoveFirst();
     for(var i=0;i<len;i++)
     {
          if(dataset1.Fields.Field['a'].Value=="是")
          {
	     var atte_begintime = dataset1.Fields.Field['atte_begintime'].Value;
	     var atte_limit = dataset1.Fields.Field['atte_limit'].Value;
                var Endtime = dataset1.Fields.Field['Endtime'].Value;
                var  atte_reason = dataset1.Fields.Field['atte_reason'].Value;


	//     string+=atte_begintime.split(' ')[0] +"|"+ atte_limit+"#";
          //       string+=atte_begintime.split(' ')[0] +"|"+ atte_limit+"|"+Endtime.split(' ')[0]+"#";   
                   string+=atte_begintime.split(' ')[0] +"|"+ atte_limit+"|"+atte_reason.split(' ')[0]+"#";   

         }
         
         dataset1.MoveNext();
    }

    string=string.substr(0,string.length-1);
    window.returnValue=string;
    CloseBill();
}

function Close()
{
	window.returnValue ="";
	CloseBill();	
}