摘要： //导出数据到Excel protected void btn_ToExcel_Click(object sender, EventArgs e) { DataTable dt = bll_orders.Ge... 阅读全文

摘要： create database DBDemouse DBDemocreate VIEW v_GetDate AS SELECT dt=CONVERT(varchar(8),GETDATE(),112) GO --得到新编号的函数 create FUNCTION f_NextBH() RETURNS varchar(12) AS BEGIN DECLARE @dt varchar(8) SELECT @dt=dt FROM v_GetDate RETURN( SELECT @dt+RIGHT(10001+ISNULL... 阅读全文