ijСÐÍÒ½ÔºÐÅÏ¢¹ÜÀíϵͳµÄÉè¼ÆÓ뿪·¢ - ͼÎÄ(4)

2019-04-02 13:49

ÖÐ×ó±ßÏÔʾÊý¾ÝµÄ²¿·Ö¼ÈΪ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 Ò³


ijСÐÍÒ½ÔºÐÅÏ¢¹ÜÀíϵͳµÄÉè¼ÆÓ뿪·¢ - ͼÎÄ(4).doc ½«±¾ÎĵÄWordÎĵµÏÂÔØµ½µçÄÔ ÏÂÔØÊ§°Ü»òÕßÎĵµ²»ÍêÕû£¬ÇëÁªÏµ¿Í·þÈËÔ±½â¾ö£¡

ÏÂһƪ£ºÎÄÑÔÎÄȤ¶Á

Ïà¹ØÔĶÁ
±¾ÀàÅÅÐÐ
¡Á ×¢²á»áÔ±Ãâ·ÑÏÂÔØ£¨ÏÂÔØºó¿ÉÒÔ×ÔÓɸ´ÖƺÍÅŰ棩

ÂíÉÏ×¢²á»áÔ±

×¢£ºÏÂÔØÎĵµÓпÉÄÜ¡°Ö»ÓÐĿ¼»òÕßÄÚÈݲ»È«¡±µÈÇé¿ö£¬ÇëÏÂÔØÖ®Ç°×¢Òâ±æ±ð£¬Èç¹ûÄúÒѸ¶·ÑÇÒÎÞ·¨ÏÂÔØ»òÄÚÈÝÓÐÎÊÌ⣬ÇëÁªÏµÎÒÃÇЭÖúÄã´¦Àí¡£
΢ÐÅ£º QQ£º