摘要:
ALTER PROCEDURE [dbo].[qryAppointmentworkStat]@startFrom smalldatetime,@endTo smalldatetime,@Type intasBEGINdeclare @surefromdate smalldatetimeif @startFrom is nullset @surefromdate=cast(convert(varchar(10),getdate(),120) as datetime)elseset @surefromdate=@startFrom;with cte_stat as(select app.creat 阅读全文
摘要:
前台代码: <asp:GridView ID="GVData" runat="server" OnRowDataBound="GVData_RowDataBound" OnSorting="GVData_Sorting" ShowFooter="true" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False"OnRowCreated="GVD 阅读全文
摘要:
游标-- 声明游标;CURSOR cursor_name IS select_statement--For 循环游标--(1)定义游标--(2)定义游标变量--(3)使用for循环来使用这个游标declare --类型定义 cursor c_job is select empno,ename,job,sal from emp where job='MANAGER'; --定义一个游标变量v_cinfo c_emp%ROWTYPE ,该类型为游标c_emp中的一行数据类型 c_row c_job%ro... 阅读全文
摘要:
ALTER PROCEDURE [dbo].[qryDoctorHours](@DoctorID int,@startFrom smalldatetime,@endTo smalldatetime) ASBEGINdeclare @surefromdate smalldatetimeif @startFrom is nullset @surefromdate=cast(convert(varchar(10),getdate(),120) as datetime)elseset @surefromdate=@startFromselect d.*, u.realName as doctorNam 阅读全文
摘要:
需求调研分析、概要设计、详细设计、编码、测试、软件交付准备、验收编码规范尽量避免重复代码代码性能与安全定义变量名的规范 阅读全文
摘要:
asp.net怎么让Image控件的图片随着FileUpload控件的值改变(当点击浏览按钮时,选择一个图片的路径,然后根据这个路径改变Image的图片,用C#做)方法一: <asp:FileUpload ID="FileUpload1" runat="server" Width="208px" onchange="if( pic_show.style.display == 'none')pic_show.style.display='';pic_show.src = this.valu 阅读全文