protected void DropBtn_Click(object sender, EventArgs e) { ArrayList caseList = new ArrayList(); int i; foreach (RepeaterItem repeaterItem in CaseGrid.Items) { //if (((CheckBox)CaseGrid.Rows[i].FindControl("DropCheckBox")).Checked) if (((CheckBox)repeaterItem.FindControl("DropCheckBox")).Checked) { Case obj = getCase(int.Parse(((CheckBox)repeaterItem.FindControl("DropCheckBox")).ToolTip)); //Case obj = mgr.getCase(int.Parse(((CheckBox)repeaterItem.FindControl("DropCheckBox")).ToolTip)); obj.Isdeleted = true; caseList.Add(obj); String sqlDel = "Delete from ReuseCase where Id=@Id"; OleDbCommand cmdDel = new OleDbCommand(sqlDel); cmdDel.Parameters.Add("@Id", OleDbType.Integer).Value = int.Parse(((CheckBox)repeaterItem.FindControl("DropCheckBox")).ToolTip); SQLUtil.ExecuteSql(cmdDel); } } //mgr.Delete(caseList); BindGrid(); MultiView1.ActiveViewIndex = 0; }
protected void SaveBtn2_Click(object sender, EventArgs e) { //TechInfo obj = mgr.getTechInfo(int.Parse(Request.QueryString["id2"].ToString())); //for (int i = 0; i < TechData.Items.Count; i++) //{ // obj.Techadv = ((TextBox)TechData.Items[i].FindControl("TechAdv2")).Text; // obj.Techdesc = ((TextBox)TechData.Items[i].FindControl("TechDesc2")).Text; //} //mgr.Save(obj); string strTechadv = ""; string strTechdesc = ""; for (int i = 0; i < TechData.Items.Count; i++) { strTechadv = ((TextBox)TechData.Items[i].FindControl("TechAdv2")).Text; strTechdesc = ((TextBox)TechData.Items[i].FindControl("TechDesc2")).Text; } String sqlRT = ""; sqlRT = sqlRT + " update TechInfo "; sqlRT = sqlRT + " set Techadv=@Techadv, "; sqlRT = sqlRT + " Techdesc=@Techdesc "; sqlRT = sqlRT + " where id=@id "; OleDbCommand cmdRT = new OleDbCommand(sqlRT); cmdRT.Parameters.Add("@Techadv", OleDbType.VarChar).Value = strTechadv; cmdRT.Parameters.Add("@Techdesc", OleDbType.VarChar).Value = strTechdesc; cmdRT.Parameters.Add("@id", OleDbType.Integer).Value = int.Parse(Request.QueryString["id2"].ToString()); SQLUtil.ExecuteSql(cmdRT); Response.Write("<script language='javascript'> { window.close();}</script>"); }
/// <summary> /// 刪除Specialty全部資料 /// <summary> public bool DelAllSpecialty() { SqlCommand cmd = new SqlCommand("Delete from [TB_MemberPSpecialty] "); cmd.CommandType = CommandType.Text; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 刪除Receipt全部資料 /// <summary> public bool DelAll() { SqlCommand cmd = new SqlCommand("Delete from [TB_Receipt] "); cmd.CommandType = CommandType.Text; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 刪除PaperDomainSeq全部資料 /// <summary> public bool DelPaperDomainSeqAll() { SqlCommand cmd = new SqlCommand("Delete from [TB_PaperDomainSeq]"); cmd.CommandType = CommandType.Text; return(SQLUtil.ExecuteSql(cmd) > 0); }
protected void DropBtn2_Command(object sender, CommandEventArgs e) { string Username = e.CommandArgument.ToString(); bool Deleted = Membership.DeleteUser(Username, true); if (Deleted) { String strDelReuseTech = "delete from ReuseTech where UserName = @username"; OleDbCommand cmdDelReuseTech = new OleDbCommand(strDelReuseTech); cmdDelReuseTech.Parameters.Add("@username", OleDbType.VarChar).Value = Username; cmdDelReuseTech.CommandType = CommandType.Text; SQLUtil.ExecuteSql(cmdDelReuseTech); String strDelUserProfile = "delete from UserProfiles where UserName = @username"; OleDbCommand cmdDelUserProfile = new OleDbCommand(strDelUserProfile); cmdDelUserProfile.Parameters.Add("@username", OleDbType.VarChar).Value = Username; cmdDelUserProfile.CommandType = CommandType.Text; SQLUtil.ExecuteSql(cmdDelUserProfile); //IList lists = mgrRes.getReuseTechListAll(Username); ///* UserProfiles */ //UserProfiles up = mgrUp.getUserProfiles(Username); //mgrRes.DeleteAll(lists, up); } BindGrid("A"); }
/// <summary> /// 重置並取得EDM名單 /// <summary> public bool ReSet() { SqlCommand cmd = new SqlCommand("STP_EDMReSet"); cmd.CommandType = CommandType.StoredProcedure; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 刪除年會報到全部資料 /// <summary> public bool DelAll() { SqlCommand cmd = new SqlCommand("Delete from [TB_OnSiteRegistration] "); cmd.CommandType = CommandType.Text; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 刪除Business全部資料 /// <summary> public bool DelAllBusiness() { SqlCommand cmd = new SqlCommand("Delete from [TB_MemberGBusiness] "); cmd.CommandType = CommandType.Text; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 修改資料 /// <summary> public bool Edit(Models.MMemberG mod) { SqlCommand cmd = new SqlCommand("STP_MemberGEdit"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MemberGID", SqlDbType.NVarChar).Value = mod.MemberGID; cmd.Parameters.Add("@MemberGassword", SqlDbType.NVarChar).Value = mod.MemberGassword; cmd.Parameters.Add("@NameC", SqlDbType.NVarChar).Value = mod.NameC; cmd.Parameters.Add("@MemberClass", SqlDbType.NVarChar).Value = mod.MemberClass; cmd.Parameters.Add("@TEL", SqlDbType.NVarChar).Value = mod.TEL; cmd.Parameters.Add("@FAX", SqlDbType.NVarChar).Value = mod.FAX; cmd.Parameters.Add("@RegisterDate", SqlDbType.DateTime).Value = mod.RegisterDate; cmd.Parameters.Add("@ZipCode", SqlDbType.NVarChar).Value = mod.ZipCode; cmd.Parameters.Add("@City", SqlDbType.NVarChar).Value = mod.City; cmd.Parameters.Add("@Area", SqlDbType.NVarChar).Value = mod.Area; cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = mod.Address; cmd.Parameters.Add("@ContactName", SqlDbType.NVarChar).Value = mod.ContactName; cmd.Parameters.Add("@ContactTitle", SqlDbType.NVarChar).Value = mod.ContactTitle; cmd.Parameters.Add("@ContactTEL", SqlDbType.NVarChar).Value = mod.ContactTEL; cmd.Parameters.Add("@ContactMobile", SqlDbType.NVarChar).Value = mod.ContactMobile; cmd.Parameters.Add("@ContactEmail", SqlDbType.NVarChar).Value = mod.ContactEmail; cmd.Parameters.Add("@AgentName", SqlDbType.NVarChar).Value = mod.AgentName; cmd.Parameters.Add("@AgentTitle", SqlDbType.NVarChar).Value = mod.AgentTitle; cmd.Parameters.Add("@AgentTEL", SqlDbType.NVarChar).Value = mod.AgentTEL; cmd.Parameters.Add("@AgentMobile", SqlDbType.NVarChar).Value = mod.AgentMobile; cmd.Parameters.Add("@AgentEmail", SqlDbType.NVarChar).Value = mod.AgentEmail; cmd.Parameters.Add("@Memo", SqlDbType.NVarChar).Value = mod.Memo; cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = mod.Status; cmd.Parameters.Add("@EDM", SqlDbType.Bit).Value = mod.EDM; cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser; cmd.Parameters.Add("@UpdateUser", SqlDbType.NVarChar).Value = mod.UpdateUser; cmd.Parameters.Add("@JobContent", SqlDbType.NVarChar).Value = mod.JobContent; cmd.Parameters.Add("@CompanyID", SqlDbType.NVarChar).Value = mod.CompanyID; return(SQLUtil.ExecuteSql(cmd) > 0); }
protected void AppendBtn_Click(object sender, EventArgs e) { Case obj = new Case(); obj.Name = Name1.Text; obj.Techitem = TechItem1.SelectedValue; obj.Techname = TechName1.Text; if (!TechItem1.SelectedValue.Equals("V")) { obj.Techother = TechItem1.SelectedItem.Text; } else { obj.Techother = TechOther1.Text; } obj.Wasteitem = WasteItem1.SelectedValue; obj.Wastename = WasteName1.Text; if (!WasteItem1.SelectedValue.Equals("U")) { obj.Wasteother = WasteItem1.SelectedItem.Text; } else { obj.Wasteother = WasteOther1.Text; } obj.Type = Type1.SelectedValue; obj.Casedesc = CaseDesc1.Text; obj.Helpdesc = HelpDesc1.Text; obj.Createdate = DateTime.Now; obj.Isdeleted = false; obj.Datasource = Datasource1.Text; String sqlRT = ""; sqlRT = sqlRT + " insert into ReuseCase (casedesc,createdate,helpdesc,isdeleted,name ,techitem ,techname ,techother ,type ,wasteitem ,wastename ,wasteother ,datasource) "; sqlRT = sqlRT + " values (@casedesc,@createdate,@helpdesc,@isdeleted,@name ,@techitem ,@techname ,@techother ,@type ,@wasteitem ,@wastename ,@wasteother ,@datasource)"; OleDbCommand cmdRT = new OleDbCommand(sqlRT); cmdRT.Parameters.Add("@casedesc", OleDbType.VarChar).Value = obj.Casedesc; cmdRT.Parameters.Add("@createdate", OleDbType.Date).Value = obj.Createdate; cmdRT.Parameters.Add("@helpdesc", OleDbType.VarChar).Value = obj.Helpdesc; cmdRT.Parameters.Add("@isdeleted", OleDbType.Boolean).Value = obj.Isdeleted; cmdRT.Parameters.Add("@name", OleDbType.VarChar).Value = obj.Name; cmdRT.Parameters.Add("@techitem", OleDbType.VarChar).Value = obj.Techitem; cmdRT.Parameters.Add("@techname", OleDbType.VarChar).Value = obj.Techname; cmdRT.Parameters.Add("@techother", OleDbType.VarChar).Value = obj.Techother; cmdRT.Parameters.Add("@type", OleDbType.VarChar).Value = obj.Type; cmdRT.Parameters.Add("@wasteitem", OleDbType.VarChar).Value = obj.Wasteitem; cmdRT.Parameters.Add("@wastename", OleDbType.VarChar).Value = obj.Wastename; cmdRT.Parameters.Add("@wasteother", OleDbType.VarChar).Value = obj.Wasteother; cmdRT.Parameters.Add("@datasource", OleDbType.VarChar).Value = obj.Datasource; SQLUtil.ExecuteSql(cmdRT); //mgr.Save(obj); BindGrid(); MultiView1.ActiveViewIndex = 0; }
/// <summary> /// 以PaperID刪除資料 /// </summary> public bool DelByPaperID(int intPaperID) { SqlCommand cmd = new SqlCommand("STP_PaperSuggestionDelByPaperID"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@PaperID", SqlDbType.Int).Value = intPaperID; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 刪除資料 /// <summary> public bool Del(int intTWYear) { SqlCommand cmd = new SqlCommand("STP_TWYearDel"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = intTWYear; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 刪除資料 /// <summary> public bool Del(int intVoteID) { SqlCommand cmd = new SqlCommand("STP_VoteDel"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@VoteID", SqlDbType.Int).Value = intVoteID; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 刪除資料 /// <summary> public bool Del(int intOnSiteRegistrationID) { SqlCommand cmd = new SqlCommand("STP_OnSiteRegistrationDel"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@OnSiteRegistrationID", SqlDbType.Int).Value = intOnSiteRegistrationID; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 刪除資料 /// <summary> public bool Del(string strMemberGID) { SqlCommand cmd = new SqlCommand("STP_MemberGDel"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MemberGID", SqlDbType.NVarChar).Value = strMemberGID; return(SQLUtil.ExecuteSql(cmd) > 0); }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { //ReuseTech obj = mgr.getReuseTech(int.Parse(((HiddenField)DetailsView1.FindControl("Id")).Value)); ReuseTech obj = GetReuseTech(int.Parse(((HiddenField)DetailsView1.FindControl("Id")).Value)); String sqlReuseTechDel = " delete from ReuseTech where Id =@id "; OleDbCommand cmdReuseTechDel = new OleDbCommand(sqlReuseTechDel); cmdReuseTechDel.Parameters.Add("@id", OleDbType.Integer).Value = (int.Parse(((HiddenField)DetailsView1.FindControl("Id")).Value)); SQLUtil.ExecuteSql(cmdReuseTechDel); //at = SpringUtil.at(); String sql = "SELECT * FROM MatchList WHERE Rid1=@param1 "; //IDbParameters parameters = at.CreateDbParameters(); //parameters.Add("param1", OleDbType.Integer).Value = obj.Id; //DataSet ds = new DataSet(); //at.DataSetFillWithParameters(ds, CommandType.Text, sql, parameters); OleDbCommand cmd = new OleDbCommand(sql); cmd.Parameters.Add("@param1", OleDbType.Integer).Value = obj.Id; cmd.CommandType = CommandType.Text; DataSet ds = SQLUtil.QueryDS(cmd); ArrayList matchList = null; if (ds.Tables[0].Rows.Count > 0) { matchList = new ArrayList(); foreach (DataRow dRow in ds.Tables[0].Rows) { //Match match = mgrMatch.getMatch((int)dRow["Id"]); //match.Isdeleted = true; //match.Isdeleted1 = true; //match.Deletedate1 = DateTime.Now; //matchList.Add(match); String sqlMatchUp = " Update MatchList "; sqlMatchUp = sqlMatchUp + " Set Isdeleted=@Isdeleted,"; sqlMatchUp = sqlMatchUp + " Isdeleted1=@Isdeleted1, "; sqlMatchUp = sqlMatchUp + " Deletedate1=@Deletedate1 "; sqlMatchUp = sqlMatchUp + " where id=@id "; OleDbCommand cmdMatchDel = new OleDbCommand(sqlMatchUp); cmdMatchDel.Parameters.Add("@Deletedate1", OleDbType.Date).Value = DateTime.Now; cmdMatchDel.Parameters.Add("@Isdeleted", OleDbType.Boolean).Value = true; cmdMatchDel.Parameters.Add("@Isdeleted1", OleDbType.Boolean).Value = true; cmdMatchDel.Parameters.Add("@id", OleDbType.Integer).Value = (int)dRow["Id"]; SQLUtil.ExecuteSql(cmdMatchDel); } } //private IReuseTechService mgr = (IReuseTechService)BaseAction.Context.GetObject("ReuseTechService"); //mgr.Delete(obj, null, matchList); BindGrid(); MultiView1.ActiveViewIndex = 0; }
/// <summary> /// 新增資料 /// </summary> public int Add(Models.MPaperDomainSeq mod) { SqlCommand cmd = new SqlCommand("STP_PaperDomainSeqAdd"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@PaperID", SqlDbType.Int).Value = mod.PaperID; cmd.Parameters.Add("@PaperDomainID", SqlDbType.NVarChar).Value = mod.PaperDomainID; cmd.Parameters.Add("@Seq", SqlDbType.Int).Value = mod.Seq; return(SQLUtil.ExecuteSql(cmd)); }
/// <summary> /// 修改資料 /// <summary> public bool Edit(Models.MPaperSuggestion mod) { SqlCommand cmd = new SqlCommand("STP_PaperSuggestionEdit"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@PaperSuggestionID", SqlDbType.Int).Value = mod.PaperSuggestionID; cmd.Parameters.Add("@PaperID", SqlDbType.Int).Value = mod.PaperID; cmd.Parameters.Add("@PaperSuggestion", SqlDbType.NVarChar).Value = mod.PaperSuggestion; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 修改資料 /// <summary> public bool Edit(Models.MEDM mod) { SqlCommand cmd = new SqlCommand("STP_EDMEdit"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = mod.MemberID; cmd.Parameters.Add("@NameC", SqlDbType.NVarChar).Value = mod.NameC; cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = mod.Email; cmd.Parameters.Add("@IsSend", SqlDbType.Bit).Value = mod.IsSend; return(SQLUtil.ExecuteSql(cmd) > 0); }
///// <summary> ///// 取得local mdb所有EMAIL名單資料 ///// </summary> //public DataSet GeVWNameList() //{ // string strTSQL = "select * from VW_EDM"; // OleDbCommand cmd = new OleDbCommand(strTSQL); // cmd.CommandType = CommandType.Text; // DataSet ds = SQLOle.QueryDS(cmd); // return ds; //} /// <summary> /// 刪除所有資料 /// <summary> public bool DelAll() { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; StringBuilder sbTSQL = new StringBuilder(); sbTSQL.Append(" Delete from TB_EDM"); cmd.CommandText = sbTSQL.ToString(); return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 修改資料 /// <summary> public bool Edit(Models.MUser mod) { SqlCommand cmd = new SqlCommand("STP_UserEdit"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UserID", SqlDbType.NVarChar).Value = mod.UserID; cmd.Parameters.Add("@UserPassword", SqlDbType.NVarChar).Value = Security.Encrypt(mod.UserPassword); cmd.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = mod.UserName; cmd.Parameters.Add("@Actived", SqlDbType.Bit).Value = mod.Actived; cmd.Parameters.Add("@UpdateUser", SqlDbType.NVarChar).Value = mod.UpdateUser; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 修改資料 /// <summary> public bool Edit(Models.MVote mod) { SqlCommand cmd = new SqlCommand("STP_VoteEdit"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@VoteID", SqlDbType.Int).Value = mod.VoteID; cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = mod.TWYear; cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = mod.MemberID; cmd.Parameters.Add("@AgentMemberID", SqlDbType.NVarChar).Value = mod.AgentMemberID; cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser; return(SQLUtil.ExecuteSql(cmd) > 0); }
/// <summary> /// 以id修改為已寄出資料 /// <summary> public bool EditByID(string strMemberID) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; StringBuilder sbTSQL = new StringBuilder(); sbTSQL.Append(" update [TB_EDM] set "); sbTSQL.Append(" [IsSend]=1 "); sbTSQL.Append(" where [MemberID]=" + "'" + strMemberID + "'"); cmd.CommandText = sbTSQL.ToString(); return(SQLUtil.ExecuteSql(cmd) > 0); }
public void EditReuseTech(ReuseTech obj) { #region Edit if (obj != null) { String sqlRT = ""; sqlRT = sqlRT + " update ReuseTech "; sqlRT = sqlRT + " set isapproved=@isapproved, "; sqlRT = sqlRT + " patent=@patent, "; sqlRT = sqlRT + " researchitem=@researchitem, "; sqlRT = sqlRT + " reusename=@reusename, "; sqlRT = sqlRT + " techadv=@techadv, "; sqlRT = sqlRT + " techdesc=@techdesc, "; sqlRT = sqlRT + " techitem=@techitem, "; sqlRT = sqlRT + " techname=@techname, "; sqlRT = sqlRT + " techother=@techother, "; sqlRT = sqlRT + " type=@type, "; sqlRT = sqlRT + " username=@username, "; sqlRT = sqlRT + " wasteitem=@wasteitem, "; sqlRT = sqlRT + " wastename=@wastename, "; sqlRT = sqlRT + " wasteother=@wasteother, "; sqlRT = sqlRT + " createdate=@createdate "; sqlRT = sqlRT + " where id=@id "; OleDbCommand cmdRT = new OleDbCommand(sqlRT); cmdRT.Parameters.Add("@isapproved", OleDbType.Boolean).Value = obj.Isapproved; cmdRT.Parameters.Add("@patent", OleDbType.VarChar).Value = obj.Patent; cmdRT.Parameters.Add("@researchitem", OleDbType.VarChar).Value = obj.Researchitem; cmdRT.Parameters.Add("@reusename", OleDbType.VarChar).Value = obj.Reusename; cmdRT.Parameters.Add("@techadv", OleDbType.VarChar).Value = obj.Techadv; cmdRT.Parameters.Add("@techdesc", OleDbType.VarChar).Value = obj.Techdesc; cmdRT.Parameters.Add("@techitem", OleDbType.VarChar).Value = obj.Techitem; cmdRT.Parameters.Add("@techname", OleDbType.VarChar).Value = obj.Techname; cmdRT.Parameters.Add("@techother", OleDbType.VarChar).Value = obj.Techother; cmdRT.Parameters.Add("@type", OleDbType.VarChar).Value = obj.Type; cmdRT.Parameters.Add("@username", OleDbType.VarChar).Value = obj.Username; cmdRT.Parameters.Add("@wasteitem", OleDbType.VarChar).Value = obj.Wasteitem; cmdRT.Parameters.Add("@wastename", OleDbType.VarChar).Value = obj.Wastename; cmdRT.Parameters.Add("@wasteother", OleDbType.VarChar).Value = obj.Wasteother; cmdRT.Parameters.Add("@createdate", OleDbType.Date).Value = obj.Createdate; cmdRT.Parameters.Add("@id", OleDbType.Integer).Value = obj.Id; SQLUtil.ExecuteSql(cmdRT); //HibernateTemplate.SaveOrUpdate(obj); } #endregion }
protected void BtnUpdate2_Click(object sender, EventArgs e) { //IAspnetUsersService mgrUser = (IAspnetUsersService)BaseAction.Context.GetObject("AspnetUsersService"); //IMembershipService mgrMember = (IMembershipService)BaseAction.Context.GetObject("MembershipService"); String sql = "SELECT * from aspnet_Users where UserName=@UserName "; OleDbCommand cmd = new OleDbCommand(sql); cmd.Parameters.Add("@UserName", OleDbType.Char).Value = User.Identity.Name; cmd.CommandType = CommandType.Text; DataSet ds = SQLUtil.QueryDS(cmd); string strUserID = ""; foreach (DataRow dr in ds.Tables[0].Rows) { strUserID = dr["UserId"].ToString(); } string strMemberShipSql = "update aspnet_Membership set Email=@Email where UserId=@UserId"; OleDbCommand cmdMemberShip = new OleDbCommand(strMemberShipSql); cmdMemberShip.Parameters.Add("@Email", OleDbType.Char).Value = Email.Text; cmdMemberShip.Parameters.Add("@UserId", OleDbType.Char).Value = strUserID; cmdMemberShip.CommandType = CommandType.Text; SQLUtil.ExecuteSql(cmdMemberShip); //AspnetUsers aspnetUsers = mgrUser.FindByProperty(User.Identity.Name); //AspnetMembership aspnetMembership = mgrMember.FindById(aspnetUsers.UserId); //aspnetMembership.Email = Email.Text; //mgrMember.Update(aspnetMembership); p = Profile.GetProfile(User.Identity.Name); p.UserProfile.Owner = Name.Text; p.UserProfile.Name = Name.Text; p.UserProfile.Tel = Tel.Text; p.UserProfile.Corp = Corp.Text; p.UserProfile.City = cityList.SelectedValue; p.UserProfile.Postcode = zipList.SelectedValue; p.UserProfile.Address = Address.Text; p.UserProfile.Fax = Fax.Text; p.UserProfile.Kind = Kind.SelectedValue; //p.UserProfile.Type = "1"; p.UserProfile.Zipcht = zipList.SelectedValue + cityList.SelectedItem.Text + zipList.SelectedItem.Text; p.Save(); BindProfileView(); MultiView1.ActiveViewIndex = 0; }
/// <summary> /// 新增資料 /// </summary> public string Add(Models.MMemberP mod) { SqlCommand cmd = new SqlCommand("STP_MemberPAdd"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MemberPID", SqlDbType.NVarChar).Value = mod.MemberPID; cmd.Parameters.Add("@MemberPassword", SqlDbType.NVarChar).Value = mod.MemberPassword; cmd.Parameters.Add("@NameC", SqlDbType.NVarChar).Value = mod.NameC; cmd.Parameters.Add("@NameE", SqlDbType.NVarChar).Value = mod.NameE; cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = mod.Email; cmd.Parameters.Add("@PID", SqlDbType.NVarChar).Value = mod.PID; cmd.Parameters.Add("@Birthday", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.Birthday); cmd.Parameters.Add("@RegisterDate", SqlDbType.DateTime).Value = mod.RegisterDate; cmd.Parameters.Add("@Sex", SqlDbType.NVarChar).Value = mod.Sex; cmd.Parameters.Add("@Native", SqlDbType.NVarChar).Value = mod.Native; cmd.Parameters.Add("@MemberClass", SqlDbType.NVarChar).Value = mod.MemberClass; cmd.Parameters.Add("@SchoolConsent", SqlDbType.NVarChar).Value = mod.SchoolConsent; cmd.Parameters.Add("@StudentIDCard", SqlDbType.NVarChar).Value = mod.StudentIDCard; cmd.Parameters.Add("@StudentIDCardFileType", SqlDbType.NVarChar).Value = mod.StudentIDCardFileType; cmd.Parameters.Add("@School", SqlDbType.NVarChar).Value = mod.School; cmd.Parameters.Add("@CollegeDepartment", SqlDbType.NVarChar).Value = mod.CollegeDepartment; cmd.Parameters.Add("@Education", SqlDbType.NVarChar).Value = mod.Education; cmd.Parameters.Add("@Job", SqlDbType.NVarChar).Value = mod.Job; cmd.Parameters.Add("@JobTitle", SqlDbType.NVarChar).Value = mod.JobTitle; cmd.Parameters.Add("@Student", SqlDbType.Bit).Value = mod.Student; cmd.Parameters.Add("@Mobile", SqlDbType.NVarChar).Value = mod.Mobile; cmd.Parameters.Add("@TEL", SqlDbType.NVarChar).Value = mod.TEL; cmd.Parameters.Add("@FAX", SqlDbType.NVarChar).Value = mod.FAX; cmd.Parameters.Add("@ZipCodeH", SqlDbType.NVarChar).Value = mod.ZipCodeH; cmd.Parameters.Add("@CityH", SqlDbType.NVarChar).Value = mod.CityH; cmd.Parameters.Add("@AreaH", SqlDbType.NVarChar).Value = mod.AreaH; cmd.Parameters.Add("@AddressH", SqlDbType.NVarChar).Value = mod.AddressH; cmd.Parameters.Add("@ZipCode", SqlDbType.NVarChar).Value = mod.ZipCode; cmd.Parameters.Add("@City", SqlDbType.NVarChar).Value = mod.City; cmd.Parameters.Add("@Area", SqlDbType.NVarChar).Value = mod.Area; cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = mod.Address; cmd.Parameters.Add("@Memo", SqlDbType.NVarChar).Value = mod.Memo; cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = mod.Status; cmd.Parameters.Add("@EDM", SqlDbType.Bit).Value = mod.EDM; cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser; cmd.Parameters.Add("@UpdateUser", SqlDbType.NVarChar).Value = mod.UpdateUser; if (SQLUtil.ExecuteSql(cmd) > 0) { return(mod.MemberPID); } else { return(null); } }
/// <summary> /// 修改資料 /// <summary> public bool Edit(Models.MTWYear mod) { SqlCommand cmd = new SqlCommand("STP_TWYearEdit"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = mod.TWYear; cmd.Parameters.Add("@PeriodID", SqlDbType.Int).Value = mod.PeriodID; cmd.Parameters.Add("@PaperDateBegin", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.PaperDateBegin); cmd.Parameters.Add("@PaperDateEnd", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.PaperDateEnd); cmd.Parameters.Add("@RegisterDateBegin", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.RegisterDateBegin); cmd.Parameters.Add("@RegisterDateEnd", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.RegisterDateEnd); cmd.Parameters.Add("@PayDateBegin", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.PayDateBegin); cmd.Parameters.Add("@PayDateEnd", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.PayDateEnd); return(SQLUtil.ExecuteSql(cmd) > 0); }
protected void ModifyBtn_Click(object sender, EventArgs e) { News obj = GetNewsByID(int.Parse(Id.Value)); //News obj = mgr.getNews(int.Parse(Id.Value)); obj.Title = Title2.Text; obj.Showdate = DateTime.ParseExact(Showdate2.Text, "yyyy/M/d", null); obj.Createdate = DateTime.Now; obj.Summary = Summary2.Text; obj.Link = Link2.Text; obj.Isonline = IsOnLine2.SelectedValue; if (IsShow2.SelectedValue.Equals("Y")) { obj.Isshow = true; } else { obj.Isshow = false; } /*Edit*/ String sqlM = ""; sqlM = sqlM + " update News"; sqlM = sqlM + " set [Createdate]=@Createdate, "; sqlM = sqlM + " [Isonline]=@Isonline, "; sqlM = sqlM + " [Isshow]=@Isshow,"; sqlM = sqlM + " [Link]=@Link,"; sqlM = sqlM + " [Showdate]=@Showdate, "; sqlM = sqlM + " [Summary]=@Summary,"; sqlM = sqlM + " [Title]=@Title"; sqlM = sqlM + " where id=@id "; OleDbCommand cmdM = new OleDbCommand(sqlM); cmdM.Parameters.Add("@Createdate", OleDbType.Date).Value = obj.Createdate; cmdM.Parameters.Add("@Isonline", OleDbType.VarChar).Value = obj.Isonline; cmdM.Parameters.Add("@Isshow", OleDbType.Boolean).Value = obj.Isshow; cmdM.Parameters.Add("@Link", OleDbType.VarChar).Value = obj.Link; cmdM.Parameters.Add("@Showdate", OleDbType.Date).Value = obj.Showdate; cmdM.Parameters.Add("@Summary", OleDbType.VarChar).Value = obj.Summary; cmdM.Parameters.Add("@Title", OleDbType.VarChar).Value = obj.Title; cmdM.Parameters.Add("@id", OleDbType.Integer).Value = obj.Id; SQLUtil.ExecuteSql(cmdM); //mgr.Save(obj); BindGrid(); MultiView1.ActiveViewIndex = 0; }
/// <summary> /// 修改資料 /// <summary> public bool Edit(Models.MAwardWinner mod) { SqlCommand cmd = new SqlCommand("STP_AwardWinnerEdit"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AwardWinnerID", SqlDbType.Int).Value = mod.AwardWinnerID; cmd.Parameters.Add("@AwardID", SqlDbType.Int).Value = mod.AwardID; cmd.Parameters.Add("@AwardTypeID", SqlDbType.Int).Value = SQLUtil.CheckDBValue(mod.AwardTypeID); cmd.Parameters.Add("@Year", SqlDbType.Int).Value = mod.Year; cmd.Parameters.Add("@Works", SqlDbType.NVarChar).Value = mod.Works; cmd.Parameters.Add("@WinnerName", SqlDbType.NVarChar).Value = mod.WinnerName; cmd.Parameters.Add("@Photo", SqlDbType.Image).Value = SQLUtil.CheckDBValue(mod.Photo); cmd.Parameters.Add("@Contents", SqlDbType.NVarChar).Value = mod.Contents; cmd.Parameters.Add("@LastUpdateUser", SqlDbType.NVarChar).Value = mod.LastUpdateUser; return(SQLUtil.ExecuteSql(cmd) > 0); }