ÖÐ×ó±ßÏÔʾÊý¾ÝµÄ²¿·Ö¼ÈΪGrid·ç¸ñµÄÊý¾Ý´°¿Ú¡£±¾ÏµÍ³Öл¹Óõ½Group·ç¸ñµÄÀ´ÖÆ×÷±¨±í£¬½«ÔÚͼ9³öÏÖ¡£
ͼ9 ¹ÒºÅ´òÓ¡½çÃæ
ÈçÉÏͼËùʾ£¬ÔÚµ¥»÷ÁËͼ7ͼÖеġ°´òÓ¡¡±Ö®ºó£¬ÏµÍ³»á×Ô¶¯°´ÕÕ³ÌÐòÖеĴúÂëµÄÒªÇó½«×Ô¶¯Á÷Ë®ºÅ´«µÝµ½±¨±í´°¿Ú£¬ÆäÖеġ°Ô¤¸¶¿î£¨¹ÒºÅ£©µ¥¾Ý¡±ËùÔÚµÄÊý¾Ý´°¿Ú¼´ÎªGroup´°¿ÚÓ¦ÓÃÓÚÊý¾Ý±¨±íµÄµäÐÍ¡£
ÔڹҺŹý³ÌÖУ¬³ýÁË»áΪ²¡È˵ķÖÅä´Ë´ÎµÄ×Ô¶¯Á÷Ë®ºÅÖ®Í⣬Ҳ»áҪΪ²¡ÈË·ÖÅäÒ»¸ö²¡ÀúºÅ£¬ÓÉÄê·Ý£¨4룩£«ÐòÁкţ¨4룩¹¹³É¡£Ã¿µ½ÐµÄÒ»Ä꣬ÐòÁкŶ¼ÊÇ´Ó0001¿ªÊ¼£»Èç¹û²»ÊÇÔÚеÄÒ»Ä꣬ÔòÐòÁкÅÊÇÒѾÔÚÒ½Ôº¾ÍÕïµÄ²¡È˵ÄÈËÊý¼ÓÉÏ1¹¹³É¡£Îª´Ë£¬Ã¿´Î·ÖÅ䲡ÀúºÅʱ£¬´ÓÊý¾Ý¿âÖйҺűíÖÐÌáÈ¡×î´óµÄ²¡ÀúºÅ£¬½«ÆäÖеÄÄê·ÝÓ뵱ǰ¼ÆËã»úÉϵÄÄê·ÝÏà±È½Ï£¬Èç¹ûÏàµÈ£¬Ôò½«ºó4λµÄÐòÁкżÓ1,Èç¹ûÊÇеÄÒ»ÄêÔòÖ±½ÓÈÃÐòÁкÅλ0001¡£¾ßÌåʵÏÖÊÇÔÚ´°¿ÚÖж¨Ò壬´úÂëÈçÏ£º
//·ÖÅ䲡ÀúºÅ
string a,b,d,c,n
SELECT max(ghb.blh) into :a FROM ghb;
b=left(a,4) d=string(year(today())) c=right(a,4) if b>d then
messagebox('³ö´í','µ±Ç°ÏµÍ³Ê±¼äÓÐÎó,ÇëÏȵ÷Õûϵͳʱ¼ä',stopsign!,OK!) else
if b=d then
c=string(integer(c)+1)
µÚ 13 Ò³ ¹² 30 Ò³
n=fill('0',4 - len(c)) c=n+c else
c='0001' end if a=d+c blh1=a end if
·ÖÅ䲡ÈË×Ô¶¯Á÷Ë®ºÅ£¬²¡ÀúºÅµÄͬʱ£¬Ò²ÊÇҪͬʱÔÚ²¡ÈË»ù±¾ÐÅÏ¢±íµ±ÖвåÈëÐÅÏ¢£¬Ê×ÏÈÒ²ÊÇÏÈΪ±íµÄÖ÷Âë¡°¾ÍÕïºÅ¡±·ÖÅäºÅÂë¡£²ÉÓÃ×Ô¶¨ÒåµÄº¯Êýjzh():
string a,b,c,d,e,f,g,h,i SELECT max(jzid) INTO :a FROM ghdj;
b=string(year(today())) //µ±Ç°ÏµÍ³ÈÕÆÚÖÐÄê·ÝµÄºóÁ½Î» c=string(month(today())) //µ±Ç°ÏµÍ³ÈÕÆÚÖеÄÔÂ·Ý c=fill('0',2 - len(c))+c
d=string(Day(today())) //µ±Ç°ÏµÍ³ÈÕÆÚÖеÄÈÕÆÚ d=fill('0',2 - len(d))+d
e=left(a,8) //±íÖÐ×î´óIDµÄǰ°Ëλ
f=right(a,6) //±íÖÐ×î´óIDµÄºóÁùλ,±íʾÐòÁкŠg=right(e,4)
h=right(e,2) //±íÖÐ×î´óIDµÄÆß¡¢°Ëλ,±íʾÈÕÆÚ g=left(g,2) //±íÖÐ×î´óIDµÄÎå¡¢Áùλ,±íʾÔÂ·Ý e=left(e,4) //±íÖÐ×î´óIDµÄǰËÄλ,±íʾÄê·Ý if b messagebox(\³ö´í\µ±Ç°ÏµÍ³Ê±¼äÓÐÎó,ÇëÏȵ÷Õûϵͳʱ¼ä\ return elseif b>e then i=b+c+d+'000001' else if c messagebox(\³ö´í\µ±Ç°ÏµÍ³Ê±¼äÓÐÎó,ÇëÏȵ÷Õûϵͳʱ¼ä\ return elseif c>g then i=b+c+d+'000001' else if d messagebox(\³ö´í\µ±Ç°ÏµÍ³Ê±¼äÓÐÎó,ÇëÏȵ÷Õûϵͳʱ¼ä\ return elseif d>h then i=b+c+d+'000001' µÚ 14 Ò³ ¹² 30 Ò³ else f=string(long(f)+1) i=b+c+d+fill('0',6 - len(f))+f end if end if end if st_11.text=i 3.5 ¾ÍÕï¹ÜÀíÄ£¿é ²¡ÈËÔÚ½øÈëËù¹ÒºÅµÄ¿ÆÊÒ½øÐоÍÕïÈë¿ÚµÄ½çÃæÈçͼ10Ëùʾ¡£ ͼ10 ¾ÍÕïÈë¿Ú½çÃæ ÔڸýçÃæÖÐÁ½¸ö°´Å¥¡°¼òÃ÷ÐÅÏ¢Ìîд¡±ºÍ¡°¾ÍÕ°´Å¥ÌṩÁËÇ¿´óµÄ²¡È˾ÍÕïÐÅÏ¢µÄ¼ÈëµÄ¹¦ÄÜ£¬·½±ãÈÕºóÒ½ÉúµÄ¶Ô²¡È˲¡Ê·µÄÕÆÎÕ£¬ÈÕºóµÄÁÙ´²¿ÆÑ§Ñо¿ÒÔ¼°²¡È˶Ô×Ô¼º²¡Ê·µÄÁ˽⡣ÔÚ½çÃæÖе±ÊäÈ벡ÈËID(blh)£¬Ö®ºó°´Ï¡°¼òÃ÷ÐÅÏ¢Ìîд¡±°´Å¥¾Í½øÈ벡ÈË»ù±¾ÐÅÏ¢µÃ¼Èë½çÃæÈçͼ11Ëùʾ¡£ µÚ 15 Ò³ ¹² 30 Ò³ ͼ11 ²¡ÈË»ù±¾ÐÅϢ¼Èë½çÃæ ¸Ã½çÃæÖÐʹÓÃÁË´´½¨ºÃµÄÊý¾Ý´°d_jbxx£¬¾ÍÕïºÅºÍ²¡ÀúºÅÊÇͨ¹ýͼ10½çÃæµÄ¡°¼òÃ÷ÐÅÏ¢Ìîд¡±°´Å¥ÖеÄÏà¹Ø´úÂëʵÏÖ£¨Ö÷ÒªÊÇÀûÓÃÈ«¾Ö±äÁ¿À´´«µÝÖµ£©£º ::g_blh=trim(sle_1.text) jzh() ::g_jzid=trim(st_2.text) opensheet (w_jbxx,w_zhujiemian,8,original!) ͬÀí£¬ÔÚͼ10ÖÐÈç°´Ï¡°¾ÍÕ°´Å¥£¬ÔÚ½øÈëÈçͼ12ËùʾµÄ½çÃæ£¬²¡ÈËIDºÅÒ²½«±»´«µÝ¡£ ½çÃæÖпÉÒÔͨ¹ý¡°±£´æ¡±¡¢¡°ÐÂÔö¡±µÈϵÁа´Å¥Íê³É¶Ô²¡È˴˴ξÍÕïµÄ¼Ç¼¹¤×÷£¬Í¬Ê±Ò½ÉúÒ²¿ÉÒÔͨ¹ý¡°ÉêÇ롱°´Å¥¶ÔÐèÒª½øÐнøÒ»²½Ïêϸ¼ì²éµÄ²¡ÈËÌá³ö¼ì²éÉêÇ룬ÁíÍâ¿ÉÒÔÔÚ¡°´¦·½¼Æ¼Û¡±µ±ÖжԲ¡È˵ÄÒ©·½½øÐмƼۡ£ÔÚÒ½Éú¶Ô²¡È˳ö¾ß²¡Àú´¦·½µÄͬʱ¿ÉÒÔËæÊ±²éÔÄ¡°²¡Àú´¦·½Ä£°å¡±£¬ÒÔ¼°¿ÉÒÔͨ¹ý¡°²é¿´±¨¸æ¡±²é¿´²¡È˵ļÈÍù¼ì²é»¯Ñé¡£ µÚ 16 Ò³ ¹² 30 Ò³ ͼ12 ¾ÍÕï½çÃæ ÉÏÊöµÄ¸Ã¹¦ÄÜÄ£¿éÖеÄÏà¹Ø¹¦Äܶ¼ÊÇ¡°Ò½Éú¡±µÄȨÏÞ·¶Î§£¬ÒÔϽ«µÄ¼ì²é»¯ÑéµÄ±¨¸æ½çÃæ·Ö±ðÊôÓÚ¡°·ÅÉäÔ±¡± ºÍ¡°»¯ÑéÔ±¡±µÄÖ°ÏÞ¡£ ͼ13 ²¡È˼ì²é½á¹û¼Èë½çÃæ ÔÚÕâ¸ö½çÃæÖÐ×îÖ÷ÒªµÄ¾ÍÊÇ¡°Ôö¼Ó¡±¡¢¡°Í˳ö¡±¼¸¸ö°´Å¥ÖеÄÏà¹Ø´úÂëÍê³ÉÁ˶ÔÊý¾ÝµÄ¼Èë±£´æ£º //Åжϴ°Ìå¼Ç¼ÊÇ·ñÐèÒª±£´æ int MCount int updateornot mcount=dw_hyjc_jcbg.modifiedcount() if mcount>0 then updateornot=messagebox(\±£´æÐÞ¸Ä\ÄúÐÞ¸ÄÁËÊý¾Ý´°¿ÚÖеÄÊý¾Ý,ÏÖÔÚÊÇ·ñ±£´æ?\ if updateornot=1 then if update(dw_hyjc_jcbg,true,false)=1 then dw_hyjc_jcbg.resetupdate() µÚ 17 Ò³ ¹² 30 Ò³