简单版上下游供应链 CEM维护列表


================================================================================================================================================================================================


1. 系统管理         /OA/admin_index.aspx     admin/123

	系统参数设置，	/OA/Config/Admin_config.aspx

	质检报告上传， 	/OA/pihaoImage/List.aspx            （ZJDSC， BestSoft_GetRecord）
                    /OA/pihaoImage/Edit.aspx

	管理员管理，	/OA/Manage/List.aspx
			        /OA/Manage/Edit.aspx

	客商资料管理，	/OA/Mchk/List.aspx  (添加用户）
			        /OA/Users/List.aspx

	业务员管理	    /OA/Users/YWY_List.aspx
			        /OA/Users/Edit.aspx

================================================================================================================================================================================================


2. 供应商协同管理 	/OA/supplier_index.aspx        supplier/123456    表 b_users  

	流向查询，	    /OA/SpaceTime/Supplier_LuXiang.aspx
                        BestSoft_GetRecord, LX

			liuxiang 视图：

			SELECT    b.plh, b.rq, d.dwbh AS xwdwbh, d.dwmch, a.spbh, a.oldcode, a.spmch, a.shpgg, a.shpchd, a.shengccj, a.dw, b.chkshl, i.hshj, i.hsje, i.je, b.hwjcsh, j.kcshl, b.pihao, f.sxrq, d.pslx, i.ml, e.huowname, 
                      b.djbh, b.zhy, a.jixing, a.leibie, a.shangplx, h.dwbh AS ghdwbh, h.dwmch AS ghdw, b.pici, a.ckbs, b.ywy, a.shlv, d.fukuanfs, d.kemuhao, ISNULL(k.danwbh, d.danwbh) AS danwbhxs, ISNULL(k.dwmch, 
                      d.dwmch) AS dwmchxs, a.tongym, a.zjm, a.spid
			FROM      dbo.spkfk AS a WITH (nolock) INNER JOIN
                      dbo.splsk AS b WITH (nolock) LEFT OUTER JOIN
                      dbo.mchk AS d WITH (nolock) ON b.dwbh = d.dwbh LEFT OUTER JOIN
                      dbo.huoweizl AS e WITH (nolock) ON b.hw = e.hw LEFT OUTER JOIN
                      dbo.jtmchk AS k WITH (nolock) ON d.zdwbh = k.zdwbh ON a.spid = b.spid INNER JOIN
                      dbo.pici AS f WITH (nolock) ON b.pici = f.pici AND b.hw = f.hw INNER JOIN
                      dbo.mchk AS h WITH (nolock) ON f.dwbh = h.dwbh INNER JOIN
                      dbo.ywmxk AS i WITH (nolock) ON b.djbh = i.djbh AND b.dj_sn = i.dj_sn INNER JOIN
                      dbo.spkfjc AS j WITH (nolock) ON a.spid = j.spid
			WHERE     (b.djbh LIKE 'XS[ACB]%')


	库存查询，    /OA/SpaceTime/Supplier_sskc.aspx
                  BestSoft_ShopGetSpkfk ， @leixing = 4


	对账单，      /OA/SpaceTime/Supplier_statement.aspx
                  BestSoft_GetRecord  



================================================================================================================================================================================================



3. 客户在线协同  /OA/CustomerLogin.aspx
	
	网上订单，   /OA/SpaceTime/Customer_shop.aspx
			     BestSoft_ShopGetSpkfk， (@leixing = 1)
			     添加到购物车（Session["Cart"]）

	购物车，	 /OA/SpaceTime/Customer_ShopCart.aspx
			     BestSoft_ywyqh_ADD， 插入表ywyqh

	我的订单，	 /OA/SpaceTime/Customer_Dingdan.aspx

	质检报告下载，	/OA/SpaceTime/Zhijiandan.aspx
			下载对应的质检单。

	对账单，	/OA/SpaceTime/Customer_Statement.aspx


================================================================================================================================================================================================
			

4. 业务员在线协同 	/OA/PersonLogin.aspx (业务员）

	
	网上订单，		/OA/SpaceTime/PersonShop.aspx (

	我的订单，		/OA/SpaceTime/Dingdan.aspx

	流向查询，		/OA/SpaceTime/LuXiang.aspx

	库存查询，		/OA/SpaceTime/sskc.aspx

 	质检报告下载，	/OA/SpaceTime/Person_Zhijiandan.aspx

	对账单，		/OA/SpaceTime/Person_Statement.aspx


================================================================================================================================================================================================


add key="SqlProvider" value="server=jsnjbs.gnway.org,2433;database=ksoa;uid=sa;pwd=dg8fv"


================================================================================================================================================================================================