目錄

摘要: <?xml version="1.0" encoding="utf-8" ?><siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" enableLocalization="true"> <siteMapNode roles="經理,經理助理,副理,襄理,課長,資深工程師,工程師,助理工程師" url="Logon.aspx" title="首頁&quo 阅读全文
posted @ 2011-04-07 16:53 pramezh 阅读(152) 评论(0) 推荐(0) 编辑

登陸驗證

摘要: <authentication mode="Forms"><forms loginUrl="Logon.aspx"></forms></authentication> <authorization> <deny users="?"/> <allow users="*"/> </authorization> 阅读全文
posted @ 2011-04-07 16:50 pramezh 阅读(88) 评论(0) 推荐(0) 编辑

MemberShip驗證

摘要: 登陸頁面的設計 <asp:Login ID="Login1" runat="server" DestinationPageUrl="~/Bulletin.aspx" PasswordRecoveryText="忘記密碼?" PasswordRecoveryUrl="PasswordRecovery.aspx"> <LayoutTemplate> <table border="0" cellpadding="1" cellsp 阅读全文
posted @ 2011-04-07 16:48 pramezh 阅读(111) 评论(0) 推荐(0) 编辑

SQL中的操作

摘要: public void Update(string modifyBy) { string strInsert = "update PcrChangeType set ChgType_Desc=@ChgTypeDesc,Modify_Id=@modifyBy,Modify_Date=(select CONVERT(varchar(12) , getdate(), 111 )+' '+CONVERT(varchar(12),getdate(), 108 )) where Customer_ID=@customer and ChgType_Id=@ChgTypeNo&quo 阅读全文
posted @ 2011-04-07 16:36 pramezh 阅读(101) 评论(0) 推荐(0) 编辑

遮罩層_ModalPopupExtender

摘要: <cc2:ModalPopupExtender ID="MPE" runat="server" TargetControlID="BtnSearch2" BackgroundCssClass="modalBackground" PopupControlID="Panel3"> </cc2:ModalPopupExtender><asp:Panel ID="Panel3" runat="server" style="d 阅读全文
posted @ 2011-04-07 16:10 pramezh 阅读(203) 评论(0) 推荐(0) 编辑

Email的發送

摘要: #region 發送郵件 /// <summary> /// 發送郵件 /// </summary> /// <param name="bodyfile"></param> /// <param name="Subject"></param> /// <param name="MailTitle"></param> /// <param name="attachmentfilelist"></param 阅读全文
posted @ 2011-04-04 10:18 pramezh 阅读(137) 评论(0) 推荐(0) 编辑

密碼的生成

摘要: public static string CreatePassword() { string numberChars = "0123456789"; string lowerChars = "abcdefghijklmnopqrstuvwxyz"; string upperChars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"; string fullPassword = numberChars + lowerChars + upperChars; int[] tempr = new int[8]; string r 阅读全文
posted @ 2011-04-04 10:17 pramezh 阅读(119) 评论(0) 推荐(0) 编辑

共有變量定義

摘要: public string Name { get { if (ViewState["Name"] != null) { return ViewState["Name"].ToString(); } else return ""; } set { ViewState["Name"] = value; } }//共有變量的定義//共有數組 的定義string[] role = Roles.GetRolesForUser(name);ViewState["roles"] = role;//在所需要的地 阅读全文
posted @ 2011-04-04 10:16 pramezh 阅读(151) 评论(0) 推荐(0) 编辑

觸發器定義

摘要: if object_id('Tri_Test')is not null drop trigger Tri_Testgo create trigger Tri_Test on REQ_HEAD for insert,updateasif not exists(select 1 from deleted) insert REQ_HEAD_Log select Pkey, REFNO,CUST,RMANO,PURPOSE,QTY,REQDAT,REFFileName,CUST2,REGION,Plant,'insert',getdate()from insertede 阅读全文
posted @ 2011-04-04 10:14 pramezh 阅读(178) 评论(0) 推荐(0) 编辑

導出Excel

摘要: GridView2.Columns[4].Visible=false; GridView2.Columns[5].Visible = false; Response.Clear(); Response.Charset = "GB2312"; Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls"); //如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码!!! Response.Con 阅读全文
posted @ 2011-04-04 10:13 pramezh 阅读(98) 评论(0) 推荐(0) 编辑