/// <summary> /// 新增資料 /// </summary> public int Add(Models.MVote mod) { SqlCommand cmd = new SqlCommand(); StringBuilder sbTSQL = new StringBuilder(); sbTSQL.AppendLine("insert into [TB_Vote] ([TWYear],[MemberID],[AgentMemberID],[CreateDate],[CreateUser])"); sbTSQL.AppendLine("values (@TWYear,@MemberID,@AgentMemberID,@CreateDate,@CreateUser)"); sbTSQL.AppendLine(";select @@identity;"); cmd.CommandType = CommandType.Text; 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("@CreateDate", SqlDbType.DateTime).Value = mod.CreateDate; cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser; cmd.CommandText = sbTSQL.ToString(); object obj = SQLUtil.ExecuteScalar(cmd); int intID = 0; if (obj != null && int.TryParse(obj.ToString(), out intID)) { mod.VoteID = intID; } return(intID); }
/// <summary> /// 新增資料 /// </summary> public int Add(Models.MReceipt mod) { SqlCommand cmd = new SqlCommand(); StringBuilder sbTSQL = new StringBuilder(); sbTSQL.AppendLine("insert into [TB_Receipt] ([TWYear],[MemberID],[MemberType],[ReceiptType]"); sbTSQL.AppendLine(",[Fee],[ReceivedFromAppend],[Remark],[CreateUser],[CreateDate],[CancelUser]"); sbTSQL.AppendLine(",[CancelDate],[Enable])"); sbTSQL.AppendLine("values (@TWYear,@MemberID,@MemberType,@ReceiptType"); sbTSQL.AppendLine(",@Fee,@ReceivedFromAppend,@Remark,@CreateUser,@CreateDate,@CancelUser"); sbTSQL.AppendLine(",@CancelDate,@Enable)"); sbTSQL.AppendLine(";select @@identity;"); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = mod.TWYear; cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = mod.MemberID; cmd.Parameters.Add("@MemberType", SqlDbType.NVarChar).Value = mod.MemberType; cmd.Parameters.Add("@ReceiptType", SqlDbType.NVarChar).Value = mod.ReceiptType; cmd.Parameters.Add("@Fee", SqlDbType.Int).Value = mod.Fee; cmd.Parameters.Add("@ReceivedFromAppend", SqlDbType.NVarChar).Value = mod.ReceivedFromAppend; cmd.Parameters.Add("@Remark", SqlDbType.NVarChar).Value = mod.Remark; cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser; cmd.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = mod.CreateDate; cmd.Parameters.Add("@CancelUser", SqlDbType.NVarChar).Value = SQLUtil.CheckDBValue(mod.CancelUser); cmd.Parameters.Add("@CancelDate", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.CancelDate); cmd.Parameters.Add("@Enable", SqlDbType.Bit).Value = mod.Enable; cmd.CommandText = sbTSQL.ToString(); object obj = SQLUtil.ExecuteScalar(cmd); int intID = 0; if (obj != null && int.TryParse(obj.ToString(), out intID)) { mod.ReceiptID = intID; } return(intID); }
/// <summary> /// 新增資料 /// </summary> public int Add(Models.MAwardWinner mod) { SqlCommand cmd = new SqlCommand("STP_AwardWinnerAdd"); cmd.CommandType = CommandType.StoredProcedure; 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("@WinnerID", SqlDbType.Int).Value = mod.WinnerID; 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("@WinnerTitle", SqlDbType.NVarChar).Value = SQLUtil.CheckDBValue(mod.WinnerTitle); //cmd.Parameters.Add("@Experience", SqlDbType.NVarChar).Value = SQLUtil.CheckDBValue(mod.Experience); //cmd.Parameters.Add("@Contribution", SqlDbType.NVarChar).Value = SQLUtil.CheckDBValue(mod.Contribution); //cmd.Parameters.Add("@Draft", SqlDbType.Bit).Value = SQLUtil.CheckDBValue(mod.Draft); cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser; cmd.Parameters.Add("@LastUpdateUser", SqlDbType.NVarChar).Value = mod.LastUpdateUser; object obj = SQLUtil.ExecuteScalar(cmd); int intID = 0; if (obj != null && int.TryParse(obj.ToString(), out intID)) { mod.AwardWinnerID = intID; } return(intID); }
/// <summary> /// 由UserID計算User筆數 /// </summary> public int CountByUserID(string strUserid) { SqlCommand cmd = new SqlCommand("STP_UserCountByUserID"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UserID", SqlDbType.NVarChar).Value = strUserid; return(Convert.ToInt32(SQLUtil.ExecuteScalar(cmd))); }
/// <summary> /// 計算用AwardID取得資料筆數 /// </summary> public int GetCountByAwardID(int AwardID) { SqlCommand cmd = new SqlCommand("STP_AwardWinnerCountByAwardID"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AwardID", SqlDbType.Int).Value = AwardID; return(Convert.ToInt32(SQLUtil.ExecuteScalar(cmd))); }
/// <summary> /// 新增資料 /// </summary> public int Add(Models.MPaper mod) { SqlCommand cmd = new SqlCommand(); StringBuilder sbTSQL = new StringBuilder(); sbTSQL.AppendLine("insert into [TB_Paper] ([PaperID],[TWYear],[PaperTitle],[PaperAuthor],[Company]"); sbTSQL.AppendLine(",[SummaryC],[SummaryE],[MemberType],[MemberID],[Tel1]"); sbTSQL.AppendLine(",[Tel2],[Ext],[Fax1],[Fax2],[Email]"); sbTSQL.AppendLine(",[UploadDate],[PublishType],[PaperDomainID],[Publish],[FileExtension]"); sbTSQL.AppendLine(",[Examine],[ExamineDate],[PaperNo])"); sbTSQL.AppendLine("values (@PaperID,@TWYear,@PaperTitle,@PaperAuthor,@Company"); sbTSQL.AppendLine(",@SummaryC,@SummaryE,@MemberType,@MemberID,@Tel1"); sbTSQL.AppendLine(",@Tel2,@Ext,@Fax1,@Fax2,@Email"); sbTSQL.AppendLine(",@UploadDate,@PublishType,@PaperDomainID,@Publish,@FileExtension"); sbTSQL.AppendLine(",@Examine,@ExamineDate,@PaperNo)"); sbTSQL.AppendLine(";select @@identity;"); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@PaperID", SqlDbType.Int).Value = mod.PaperID; cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = mod.TWYear; cmd.Parameters.Add("@PaperTitle", SqlDbType.NVarChar).Value = mod.PaperTitle; cmd.Parameters.Add("@PaperAuthor", SqlDbType.NVarChar).Value = mod.PaperAuthor; cmd.Parameters.Add("@Company", SqlDbType.NVarChar).Value = mod.Company; cmd.Parameters.Add("@SummaryC", SqlDbType.NVarChar).Value = mod.SummaryC; cmd.Parameters.Add("@SummaryE", SqlDbType.NVarChar).Value = mod.SummaryE; cmd.Parameters.Add("@MemberType", SqlDbType.NVarChar).Value = mod.MemberType; cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = mod.MemberID; cmd.Parameters.Add("@Tel1", SqlDbType.NVarChar).Value = mod.Tel1; cmd.Parameters.Add("@Tel2", SqlDbType.NVarChar).Value = mod.Tel2; cmd.Parameters.Add("@Ext", SqlDbType.NVarChar).Value = mod.Ext; cmd.Parameters.Add("@Fax1", SqlDbType.NVarChar).Value = mod.Fax1; cmd.Parameters.Add("@Fax2", SqlDbType.NVarChar).Value = mod.Fax2; cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = mod.Email; cmd.Parameters.Add("@UploadDate", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.UploadDate); cmd.Parameters.Add("@PublishType", SqlDbType.NVarChar).Value = mod.PublishType; cmd.Parameters.Add("@PaperDomainID", SqlDbType.NVarChar).Value = mod.PaperDomainID; cmd.Parameters.Add("@Publish", SqlDbType.Bit).Value = mod.Publish; cmd.Parameters.Add("@FileExtension", SqlDbType.NVarChar).Value = mod.FileExtension; cmd.Parameters.Add("@Examine", SqlDbType.NVarChar).Value = mod.Examine; cmd.Parameters.Add("@ExamineDate", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.ExamineDate); cmd.Parameters.Add("@PaperNo", SqlDbType.NVarChar).Value = mod.PaperNo; cmd.CommandText = sbTSQL.ToString(); object obj = SQLUtil.ExecuteScalar(cmd); int intID = 0; if (obj != null && int.TryParse(obj.ToString(), out intID)) { mod.PaperID = intID; } return(intID); }
/// <summary> /// 新增資料 /// </summary> public int Add(Models.MPaperSuggestion mod) { SqlCommand cmd = new SqlCommand("STP_PaperSuggestionAdd"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@PaperID", SqlDbType.Int).Value = mod.PaperID; cmd.Parameters.Add("@PaperSuggestion", SqlDbType.NVarChar).Value = mod.PaperSuggestion; object obj = SQLUtil.ExecuteScalar(cmd); int intID = 0; if (obj != null && int.TryParse(obj.ToString(), out intID)) { mod.PaperSuggestionID = intID; } return(intID); }
/// <summary> /// 是否繳過入會費 /// <summary> public int CheckMemberFeePay(string strMemberID, string strMemberType) { SqlCommand cmd = new SqlCommand("STP_FeeCheckMemberPay"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MemberType", SqlDbType.NVarChar).Value = strMemberType; cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = strMemberID; object obj = SQLUtil.ExecuteScalar(cmd); int intCount = 0; if (obj != null && int.TryParse(obj.ToString(), out intCount)) { intCount = Convert.ToInt32(obj.ToString()); } return(intCount); }
/// <summary> /// 新增資料 /// </summary> public int Add(Models.MOnSiteRegistration mod) { SqlCommand cmd = new SqlCommand(); StringBuilder sbTSQL = new StringBuilder(); sbTSQL.AppendLine("insert into [TB_OnSiteRegistration] ([TWYear],[MemberID],[MemberType],[RegisterName]"); sbTSQL.AppendLine(",[Company],[PayType],[Fee2],[Fee3],[Attend]"); sbTSQL.AppendLine(",[MealType],[CreateUser],[CreateDate],[UpdateUser],[UpdateDate],[FeeID])"); sbTSQL.AppendLine("values (@TWYear,@MemberID,@MemberType,@RegisterName"); sbTSQL.AppendLine(",@Company,@PayType,@Fee2,@Fee3,@Attend"); sbTSQL.AppendLine(",@MealType,@CreateUser,@CreateDate,@UpdateUser,@UpdateDate,@FeeID)"); sbTSQL.AppendLine(";select @@identity;"); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = mod.TWYear; cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = mod.MemberID; cmd.Parameters.Add("@MemberType", SqlDbType.NVarChar).Value = mod.MemberType; cmd.Parameters.Add("@RegisterName", SqlDbType.NVarChar).Value = mod.RegisterName; cmd.Parameters.Add("@Company", SqlDbType.NVarChar).Value = mod.Company; cmd.Parameters.Add("@PayType", SqlDbType.NVarChar).Value = mod.PayType; cmd.Parameters.Add("@Fee2", SqlDbType.Int).Value = mod.Fee2; cmd.Parameters.Add("@Fee3", SqlDbType.Int).Value = mod.Fee3; cmd.Parameters.Add("@Attend", SqlDbType.Bit).Value = mod.Attend; cmd.Parameters.Add("@MealType", SqlDbType.NVarChar).Value = mod.MealType; cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser; cmd.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = mod.CreateDate; cmd.Parameters.Add("@UpdateUser", SqlDbType.NVarChar).Value = mod.UpdateUser; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.UpdateDate); cmd.Parameters.Add("@FeeID", SqlDbType.Int).Value = SQLUtil.CheckDBValue(mod.FeeID); cmd.CommandText = sbTSQL.ToString(); object obj = SQLUtil.ExecuteScalar(cmd); int intID = 0; if (obj != null && int.TryParse(obj.ToString(), out intID)) { mod.OnSiteRegistrationID = intID; } return(intID); }
/// <summary> /// 新增資料 /// </summary> public int Add(Models.MFeeP mod) { SqlCommand cmd = new SqlCommand("STP_FeePAdd"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MemberPID", SqlDbType.NVarChar).Value = mod.MemberPID; cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = mod.TWYear; cmd.Parameters.Add("@PayType", SqlDbType.NVarChar).Value = mod.PayType; cmd.Parameters.Add("@Fee1", SqlDbType.Int).Value = mod.Fee1; cmd.Parameters.Add("@Fee2", SqlDbType.Int).Value = mod.Fee2; cmd.Parameters.Add("@Fee3", SqlDbType.Int).Value = mod.Fee3; cmd.Parameters.Add("@PayDate", SqlDbType.DateTime).Value = mod.PayDate; cmd.Parameters.Add("@OrderID", SqlDbType.Int).Value = SQLUtil.CheckDBValue(mod.OrderID); cmd.Parameters.Add("@Remark", SqlDbType.NVarChar).Value = mod.Remark; object obj = SQLUtil.ExecuteScalar(cmd); int intID = 0; if (obj != null && int.TryParse(obj.ToString(), out intID)) { mod.FeePID = intID; } return(intID); }
/// <summary> /// 新增資料 /// </summary> public int Add(Models.MRegister mod) { SqlCommand cmd = new SqlCommand(); StringBuilder sbTSQL = new StringBuilder(); sbTSQL.AppendLine("insert into [TB_Register] ([TWYear],[MemberID],[MemberType],[RegisterName]"); sbTSQL.AppendLine(",[TEL],[Email1],[Email2],[ZipCode],[City]"); sbTSQL.AppendLine(",[Area],[Address],[MealType],[RegisterDate],[UpdateDate])"); sbTSQL.AppendLine("values (@TWYear,@MemberID,@MemberType,@RegisterName"); sbTSQL.AppendLine(",@TEL,@Email1,@Email2,@ZipCode,@City"); sbTSQL.AppendLine(",@Area,@Address,@MealType,@RegisterDate,@UpdateDate)"); sbTSQL.AppendLine(";select @@identity;"); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = mod.TWYear; cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = mod.MemberID; cmd.Parameters.Add("@MemberType", SqlDbType.NVarChar).Value = mod.MemberType; cmd.Parameters.Add("@RegisterName", SqlDbType.NVarChar).Value = mod.RegisterName; cmd.Parameters.Add("@TEL", SqlDbType.NVarChar).Value = mod.TEL; cmd.Parameters.Add("@Email1", SqlDbType.NVarChar).Value = mod.Email1; cmd.Parameters.Add("@Email2", SqlDbType.NVarChar).Value = mod.Email2; 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("@MealType", SqlDbType.NVarChar).Value = mod.MealType; cmd.Parameters.Add("@RegisterDate", SqlDbType.DateTime).Value = mod.RegisterDate; cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = mod.UpdateDate; cmd.CommandText = sbTSQL.ToString(); object obj = SQLUtil.ExecuteScalar(cmd); int intID = 0; if (obj != null && int.TryParse(obj.ToString(), out intID)) { mod.RegisterID = intID; } return(intID); }
protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e) { try { CreateUserWizard1.UserName = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("UserName")).Text; user = Membership.GetUser(CreateUserWizard1.UserName); user.ChangePasswordQuestionAndAnswer(user.GetPassword(), "1", "1"); user.IsApproved = true; user.Comment = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("Corp")).Text; Roles.AddUserToRole(CreateUserWizard1.UserName, "user"); Membership.UpdateUser(user); p = (ProfileCommon)ProfileCommon.Create(CreateUserWizard1.UserName, true); p.UserProfile.Owner = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("Name")).Text; p.UserProfile.Name = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("Name")).Text; p.UserProfile.Tel = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("Tel")).Text; p.UserProfile.Corp = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("Corp")).Text; p.UserProfile.City = ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("cityList")).SelectedValue; p.UserProfile.Postcode = ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("zipList")).SelectedValue; p.UserProfile.Address = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("Address")).Text; p.UserProfile.Fax = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("Fax")).Text; p.UserProfile.Kind = ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("Kind")).SelectedValue; p.UserProfile.Type = "1"; p.UserProfile.Zipcht = ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("zipList")).SelectedValue + ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("cityList")).SelectedItem.Text + ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("zipList")).SelectedItem.Text; p.Save(); /* UserProfiles */ UserProfiles up = new UserProfiles(); up.Username = CreateUserWizard1.UserName; up.Owner = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("Name")).Text; up.Name = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("Name")).Text; up.Tel = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("Tel")).Text; up.Corp = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("Corp")).Text; up.City = ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("cityList")).SelectedValue; up.Postcode = ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("zipList")).SelectedValue; up.Address = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("Address")).Text; up.Fax = ((TextBox)UserTemplate.ContentTemplateContainer.FindControl("Fax")).Text; up.Kind = ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("Kind")).SelectedValue; up.Type = "1"; up.Zipcht = ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("zipList")).SelectedValue + ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("cityList")).SelectedItem.Text + ((DropDownList)UserTemplate.ContentTemplateContainer.FindControl("zipList")).SelectedItem.Text; String sqlUp = ""; sqlUp = sqlUp + " insert into UserProfiles ([address],[city],[corp],[fax] ,[kind],[name],[owner],[postcode],[tel],[type],[username],[zipcht]) "; sqlUp = sqlUp + " values (@address,@city,@corp,@fax ,@kind,@name,@owner,@postcode,@tel,@type,@username,@zipcht)"; //sqlUp = sqlUp + " insert into UserProfiles ([address],[city],[corp],[fax],[kind],[name],[owner],[postcode],[tel],[type],[username],[zipcht]) "; //sqlUp = sqlUp + " values (@address,@city,@corp,@fax,@kind,@name,@owner,@postcode,@tel,@type,@username,@zipcht) "; OleDbCommand cmdM = new OleDbCommand(sqlUp); cmdM.Parameters.Add("@address", OleDbType.VarChar).Value = up.Address; cmdM.Parameters.Add("@city", OleDbType.VarChar).Value = up.City; cmdM.Parameters.Add("@corp", OleDbType.VarChar).Value = up.Corp; cmdM.Parameters.Add("@fax", OleDbType.VarChar).Value = up.Fax; cmdM.Parameters.Add("@kind", OleDbType.VarChar).Value = up.Kind; cmdM.Parameters.Add("@name", OleDbType.VarChar).Value = up.Name; cmdM.Parameters.Add("@owner", OleDbType.VarChar).Value = up.Owner; cmdM.Parameters.Add("@postcode", OleDbType.VarChar).Value = up.Postcode; cmdM.Parameters.Add("@tel", OleDbType.VarChar).Value = up.Tel; cmdM.Parameters.Add("@type", OleDbType.VarChar).Value = up.Type; cmdM.Parameters.Add("@username", OleDbType.VarChar).Value = up.Username; cmdM.Parameters.Add("@zipcht", OleDbType.VarChar).Value = up.Zipcht; cmdM.CommandType = CommandType.Text; //SQLUtil.ExecuteSql(cmdM); object objUserProfile = SQLUtil.ExecuteScalar(cmdM); //mgr.Save(null, null, up); ((Label)CompleteWizardStep1.ContentTemplateContainer.FindControl("Msg")).Text = "學研機構會員新增完成。"; } catch (Exception err) { Membership.DeleteUser(CreateUserWizard1.UserName, true); ((Label)CompleteWizardStep1.ContentTemplateContainer.FindControl("Msg")).Text = "錯誤: " + err.ToString(); } }
public void Save(ReuseTech obj, IList matchList, UserProfiles up) { #region Save if (up != null) { String sqlUp = ""; sqlUp = sqlUp + " insert into UserProfiles ([address],[city],[corp],[fax] ,[kind],[name],[owner],[postcode],[tel],[type],[username],[zipcht]) "; sqlUp = sqlUp + " values (@address,@city,@corp,@fax ,@kind,@name,@owner,@postcode,@tel,@type,@username,@zipcht)"; OleDbCommand cmdM = new OleDbCommand(sqlUp); cmdM.Parameters.Add("@address", OleDbType.VarChar).Value = up.Address; cmdM.Parameters.Add("@city", OleDbType.VarChar).Value = up.City; cmdM.Parameters.Add("@corp", OleDbType.VarChar).Value = up.Corp; cmdM.Parameters.Add("@fax", OleDbType.VarChar).Value = up.Fax; cmdM.Parameters.Add("@kind", OleDbType.VarChar).Value = up.Kind; cmdM.Parameters.Add("@name", OleDbType.VarChar).Value = up.Name; cmdM.Parameters.Add("@owner", OleDbType.VarChar).Value = up.Owner; cmdM.Parameters.Add("@postcode", OleDbType.VarChar).Value = up.Postcode; cmdM.Parameters.Add("@tel", OleDbType.VarChar).Value = up.Tel; cmdM.Parameters.Add("@type", OleDbType.VarChar).Value = up.Type; cmdM.Parameters.Add("@username", OleDbType.VarChar).Value = up.Username; cmdM.Parameters.Add("@zipcht", OleDbType.VarChar).Value = up.Zipcht; cmdM.CommandType = CommandType.Text; //SQLUtil.ExecuteSql(cmdM); object objUserProfile = SQLUtil.ExecuteScalar(cmdM); int intID = 0; if (obj != null && int.TryParse(obj.ToString(), out intID)) { //mod.AccountsPayableID = intID; String sqlAspUser = ""; sqlAspUser = sqlAspUser + " insert into aspnet_Users ([userid],[username],[mobilealias],[isanonymous] ,[lastactivitydate]) "; sqlAspUser = sqlAspUser + " values ( @userid,@username,@mobilealias,@isanonymous,@lastactivitydate)"; OleDbCommand cmdAspUser = new OleDbCommand(sqlAspUser); cmdAspUser.Parameters.Add("@userid", OleDbType.VarChar).Value = up.Address; cmdAspUser.Parameters.Add("@username", OleDbType.VarChar).Value = up.Name; cmdAspUser.Parameters.Add("@mobilealias", OleDbType.VarChar).Value = ""; cmdAspUser.Parameters.Add("@isanonymous", OleDbType.Boolean).Value = false; cmdAspUser.Parameters.Add("@lastactivitydate", OleDbType.Date).Value = DateTime.Now; cmdAspUser.CommandType = CommandType.Text; SQLUtil.ExecuteSql(cmdAspUser); } } if (obj != null) { String sqlRT = ""; sqlRT = sqlRT + " insert into ReuseTech (isapproved,patent,researchitem,reusename,techadv,techdesc,techitem,techname,techother,type,username,wasteitem,wastename,wasteother,createdate) "; sqlRT = sqlRT + " values (@isapproved,@patent,@researchitem,@reusename,@techadv,@techdesc,@techitem,@techname,@techother,@type,@username,@wasteitem,@wastename,@wasteother,@createdate)"; 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; SQLUtil.ExecuteSql(cmdRT); //HibernateTemplate.SaveOrUpdate(obj); } if (matchList != null) { foreach (Match item in matchList) { if (obj.Type.Equals("1")) { item.Rid1 = obj.Id; // ReuseTech 編號 } else { item.Rid2 = obj.Id; // ReuseTech 編號 } String sqlM = ""; sqlM = sqlM + " insert into MatchList ([approveddate],[confirmdate1],[confirmdate2],[corp1],[corp2]"; sqlM = sqlM + " ,[createdate1],[createdate2],[deletedate1],[deletedate2],[isapproved1],[isapproved2]"; sqlM = sqlM + " ,[ischecked],[isconfirm1],[isconfirm2],[isdeleted],[isdeleted1],[isdeleted2],[isdroped1],[isdroped2],[matchdate],[name1],[name2]"; sqlM = sqlM + " ,[reusename1],[reusename2],[rid1],[rid2],[techadv],[techdesc],[techitem1],[techitem2],[techname1],[techname2]"; sqlM = sqlM + " ,[tel1],[tel2],[username1],[username2],[wasteitem1],[wasteitem2],[wastename1],[wastename2])"; sqlM = sqlM + " values (@approveddate,@confirmdate1,@confirmdate2,@corp1,@corp2"; sqlM = sqlM + " ,@createdate1,@createdate2,@deletedate1,@deletedate2,@isapproved1,@isapproved2"; sqlM = sqlM + " ,@ischecked,@isconfirm1,@isconfirm2,@isdeleted,@isdeleted1,@isdeleted2,@isdroped1,@isdroped2,@matchdate,@name1,@name2"; sqlM = sqlM + " ,@reusename1,@reusename2,@rid1,@rid2,@techadv,@techdesc,@techitem1,@techitem2,@techname1,@techname2"; sqlM = sqlM + " ,@tel1,@tel2,@username1,@username2,@wasteitem1,@wasteitem2,@wastename1,@wastename2 )"; OleDbCommand cmdM = new OleDbCommand(sqlM); cmdM.Parameters.Add("@approveddate", OleDbType.Date).Value = item.Approveddate; cmdM.Parameters.Add("@confirmdate1", OleDbType.Date).Value = item.Confirmdate1; cmdM.Parameters.Add("@confirmdate2", OleDbType.Date).Value = item.Confirmdate2; cmdM.Parameters.Add("@corp1", OleDbType.VarChar).Value = item.Isapproved1; cmdM.Parameters.Add("@corp2", OleDbType.VarChar).Value = item.Isapproved1; cmdM.Parameters.Add("@createdate1", OleDbType.Date).Value = item.Createdate1; cmdM.Parameters.Add("@createdate2", OleDbType.Date).Value = item.Createdate2; cmdM.Parameters.Add("@deletedate1", OleDbType.Date).Value = item.Deletedate1; cmdM.Parameters.Add("@deletedate2", OleDbType.Date).Value = item.Deletedate2; cmdM.Parameters.Add("@isapproved1", OleDbType.Boolean).Value = item.Isapproved1; cmdM.Parameters.Add("@isapproved2", OleDbType.Boolean).Value = item.Isapproved2; cmdM.Parameters.Add("@ischecked", OleDbType.VarChar).Value = item.Ischecked; cmdM.Parameters.Add("@isconfirm1", OleDbType.VarChar).Value = item.Isconfirm1; cmdM.Parameters.Add("@isconfirm2", OleDbType.VarChar).Value = item.Isconfirm2; cmdM.Parameters.Add("@isdeleted", OleDbType.Boolean).Value = item.Isdeleted; cmdM.Parameters.Add("@isdeleted1", OleDbType.Boolean).Value = item.Isdeleted1; cmdM.Parameters.Add("@isdeleted2", OleDbType.Boolean).Value = item.Isdeleted2; cmdM.Parameters.Add("@isdroped1", OleDbType.VarChar).Value = item.Isdroped1; cmdM.Parameters.Add("@isdroped2", OleDbType.VarChar).Value = item.Isdroped2; cmdM.Parameters.Add("@matchdate", OleDbType.Date).Value = item.Matchdate; cmdM.Parameters.Add("@name1", OleDbType.VarChar).Value = item.Name1; cmdM.Parameters.Add("@name2", OleDbType.VarChar).Value = item.Name2; cmdM.Parameters.Add("@reusename1", OleDbType.VarChar).Value = item.Reusename1; cmdM.Parameters.Add("@reusename2", OleDbType.VarChar).Value = item.Reusename2; cmdM.Parameters.Add("@rid1", OleDbType.Integer).Value = item.Rid1; cmdM.Parameters.Add("@rid2", OleDbType.Integer).Value = item.Rid2; cmdM.Parameters.Add("@techadv", OleDbType.VarChar).Value = item.Techadv; cmdM.Parameters.Add("@techdesc", OleDbType.VarChar).Value = item.Techdesc; cmdM.Parameters.Add("@techitem1", OleDbType.VarChar).Value = item.Techitem1; cmdM.Parameters.Add("@techitem2", OleDbType.VarChar).Value = item.Techitem2; cmdM.Parameters.Add("@techname1", OleDbType.VarChar).Value = item.Techname1; cmdM.Parameters.Add("@techname2", OleDbType.VarChar).Value = item.Techname2; cmdM.Parameters.Add("@tel1", OleDbType.VarChar).Value = item.Tel1; cmdM.Parameters.Add("@tel2", OleDbType.VarChar).Value = item.Tel2; cmdM.Parameters.Add("@username1", OleDbType.VarChar).Value = item.Username1; cmdM.Parameters.Add("@username2", OleDbType.VarChar).Value = item.Username2; cmdM.Parameters.Add("@wasteitem1", OleDbType.VarChar).Value = item.Wasteitem1; cmdM.Parameters.Add("@wasteitem2", OleDbType.VarChar).Value = item.Wasteitem2; cmdM.Parameters.Add("@wastename1", OleDbType.VarChar).Value = item.Wastename1; cmdM.Parameters.Add("@wastename2", OleDbType.VarChar).Value = item.Wastename2; SQLUtil.ExecuteSql(cmdM); //HibernateTemplate.Save(item); } } #endregion }