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);
}
