自定义博客皮肤VIP专享

*博客头图：

点击选择上传的图片

格式为PNG、JPG，宽度*高度大于1920*100像素，不超过2MB，主视觉建议放在右侧，请参照线上博客头图

请上传大于1920*100像素的图片！

博客底图：

点击选择上传的图片

图片格式为PNG、JPG，不超过1MB，可上下左右平铺至整个背景

栏目图：

点击选择上传的图片

图片格式为PNG、JPG，图片宽度*高度为300*38像素，不超过0.5MB

主标题颜色：

RGB颜色，例如：#AFAFAF

Hover：

RGB颜色，例如：#AFAFAF

副标题颜色：

RGB颜色，例如：#AFAFAF

预览取消提交

自定义博客皮肤

-+

上一步保存

chengxu1020的专栏

原创一劳永逸让VB自动改变控件大小

当窗体大小改变时，如何动态的改变控件的大小是许多VB 程序员头痛的事。有的人设置窗体Resizable 但却不改变控件的大小；有的人则根据控件的绝对位置与窗口大小相加减的办法来重新定位控件与改变大小，这种办法比较繁琐，且不可重用；当然也有人则限定窗口干脆不让改变。有没有一种简便易行的办法？答案是肯定的，下面给出一个一劳永逸的办法，源程序如下: Option ExplicitPrivate Form

2009-10-13 14:47:00 507

原创 SY_split_KitPO中涉及到的几张表！

1.SY_ORDER_FILE 2.PriceMaster 3.KitMaster 在执行了SY_split_KitPO这个存储过程中的INSERT INTO #tmpKitPO这个过程后，#tmpKitPO这个表里的数据应该为：然后继续执行SY_split_KitPO这个存储过程中

2009-02-17 10:35:00 417 4

原创第二个：SY_create_order_Kit

ALTER PROCEDURE [dbo].[SY_create_order_Kit] @ComputerName varchar(20), @TransactionType varchar(2) AS ---- Insert new Kit PO Information into Order_Kit table.INSERT INTO Order_Kit(PONo,PartNo,PartQTY

2009-02-16 11:05:00 353

原创第一个：SY_split_KitPO

USE [panda]GO/****** Object: StoredProcedure [dbo].[SY_split_KitPO] Script Date: 02/16/2009 14:19:03 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[SY_split_KitPO]@Comp

2009-02-16 10:52:00 455

VB.NET案例源码

从基础到高级的都有，很不错，希望大家下载学习！

2008-09-12

0VB常用内部函数

0VB常用内部函数。。。

2007-07-29

VB入门课件

讲解详细，从基础到高层。适合初学者。

2007-07-29

JAVA设计模式.影印版

此书适合高级编程人员阅读

2007-07-29

Java.Bug模式详解

高清PDF格式，全面详细讲解。

2007-07-29

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

chengxu1020 CSDN认证博客专家 CSDN认证企业博客

码龄17年

IP 属地：陕西省

IP属地以运营商信息为准，境内显示到省（区、市），境外显示到国家（地区）

4: 原创

155万+: 周排名

161万+: 总排名

1731: 访问

: 等级

70: 积分

10: 粉丝

0: 获赞

4: 评论

1: 收藏

私信

关注

热门文章

最新评论

SY_split_KitPO中涉及到的几张表！
chengxu1020: sy_split_KitPO测试中发现的问题： 1.collation冲突。 2.运行未达到预期的结果。更正后的sy_split_KitPO仍然是在原文章中进行了修改。
SY_split_KitPO中涉及到的几张表！
ljhcy99: SELECT SY_ORDER_FILE.Line_No, SY_ORDER_FILE.PONo AS KitPONO, SY_ORDER_FILE.PartNo AS KitNo, SY_ORDER_FILE.QTY AS KitQTY, PriceMaster.KitID, SY_ORDER_FILE.PONo AS PartPONo, KitMaster.PartNo, SY_ORDER_FILE.QTY * KitMaster.QTY AS partQTY, SY_ORDER_FILE.FOBDate, MAX(SY_ORDER_FILE.Line_No) AS MaxLine_No FROM SY_ORDER_FILE,PriceMaster,KitMaster WHERE (SY_ORDER_FILE.ComputerName = 'chengxu_pc' ) AND (SY_ORDER_FILE.Transactiontype = 'SF') AND (PriceMaster.KitID IS NOT NULL) and (PriceMaster.KitID = KitMaster.KitID ) and SY_ORDER_FILE.PartNo = PriceMaster.PartNo AND SY_ORDER_FILE.Customer = PriceMaster.Seller AND CAST(SY_ORDER_FILE.FOBDate as datetime)BETWEEN cast(PriceMaster.CutIn_From as datetime) AND cast(PriceMaster.CutIn_To as datetime) GROUP BY SY_ORDER_FILE.Line_No, SY_ORDER_FILE.PONo, SY_ORDER_FILE.QTY, PriceMaster.KitID, KitMaster.PartNo, SY_ORDER_FILE.FOBDate, SY_ORDER_FILE.PartNo, SY_ORDER_FILE.QTY * KitMaster.QTY
SY_split_KitPO中涉及到的几张表！
ljhcy99: SELECT SY_ORDER_FILE.Line_No, SY_ORDER_FILE.PONo AS KitPONO, SY_ORDER_FILE.PartNo AS KitNo, SY_ORDER_FILE.QTY AS KitQTY, PriceMaster.KitID, SY_ORDER_FILE.PONo AS PartPONo, KitMaster.PartNo, SY_ORDER_FILE.QTY * KitMaster.QTY AS partQTY, SY_ORDER_FILE.FOBDate, MAX(SY_ORDER_FILE.Line_No) AS MaxLine_No FROM SY_ORDER_FILE,PriceMaster,KitMaster WHERE (SY_ORDER_FILE.ComputerName = 'chengxu_pc' ) AND (SY_ORDER_FILE.Transactiontype = 'SF') AND (PriceMaster.KitID IS NOT NULL) and (PriceMaster.KitID = KitMaster.KitID ) and SY_ORDER_FILE.PartNo = PriceMaster.PartNo AND SY_ORDER_FILE.Customer = PriceMaster.Seller AND CAST(SY_ORDER_FILE.FOBDate as datetime)BETWEEN cast(PriceMaster.CutIn_From as datetime) AND cast(PriceMaster.CutIn_To as datetime) GROUP BY SY_ORDER_FILE.Line_No, SY_ORDER_FILE.PONo, SY_ORDER_FILE.QTY, PriceMaster.KitID, KitMaster.PartNo, SY_ORDER_FILE.FOBDate, SY_ORDER_FILE.PartNo, SY_ORDER_FILE.QTY * KitMaster.QTY
SY_split_KitPO中涉及到的几张表！
ljhcy99: SELECT SY_ORDER_FILE.Line_No, SY_ORDER_FILE.PONo AS KitPONO, SY_ORDER_FILE.PartNo AS KitNo, SY_ORDER_FILE.QTY AS KitQTY, PriceMaster.KitID, SY_ORDER_FILE.PONo AS PartPONo, KitMaster.PartNo, SY_ORDER_FILE.QTY * KitMaster.QTY AS partQTY, SY_ORDER_FILE.FOBDate, MAX(SY_ORDER_FILE.Line_No) AS MaxLine_No FROM SY_ORDER_FILE,PriceMaster,KitMaster WHERE (SY_ORDER_FILE.ComputerName = 'chengxu_pc' ) AND (SY_ORDER_FILE.Transactiontype = 'SF') AND (PriceMaster.KitID IS NOT NULL) and (PriceMaster.KitID = KitMaster.KitID ) and SY_ORDER_FILE.PartNo = PriceMaster.PartNo AND SY_ORDER_FILE.Customer = PriceMaster.Seller AND CAST(SY_ORDER_FILE.FOBDate as datetime)BETWEEN cast(PriceMaster.CutIn_From as datetime) AND cast(PriceMaster.CutIn_To as datetime) GROUP BY SY_ORDER_FILE.Line_No, SY_ORDER_FILE.PONo, SY_ORDER_FILE.QTY, PriceMaster.KitID, KitMaster.PartNo, SY_ORDER_FILE.FOBDate, SY_ORDER_FILE.PartNo, SY_ORDER_FILE.QTY * KitMaster.QTY

最新文章

提示

确定要删除当前文章？

取消删除