private void Page_Load(object sender, System.EventArgs e)
{
if (Request.QueryString["bnID"] != null)
{
if (!Page.IsPostBack)
{
//페이지타이틀
JinsLibrary.STATEMANAGE.Session.Self["PageName"] = "공지사항보기";
dbUtil = new DBLib();
this.bnID = Request.QueryString["bnID"];
this.bnG = Request.QueryString["bnG"];
//조회수 증가
dbUtil.ChangeFigure("t_BoardNotice", "viewCount", 1, "bNotice_id=" + bnID);
//바인딩
if (this.NoticeViewBind())
{
//리스트 네비게이션 재정의
URLQuery.Self.SetQueryString();
//WebUtil.CurrentResponse.Write(URLQuery.Self.GetQueryString() + "Load" );
this.btnList.NavigateUrl = "/CommonApps/BoardNotice/bnList.aspx?" + URLQuery.Self.GetQueryString();
//이전글 다음글 보기
this.GetPreNextData();
//DB닫기
dbUtil.SqlConnection.Close();
}
else
{
ClientAction.ShowMsgBack("해당 데이터가 없습니다.");
}
}
}
else
{
ClientAction.ShowMsgBack("정상적인 접근이 아닙니다");
}
}
/*
* //그래프그리기(공통으로 뽑음--장기적으로 이상없으면 지움)
* private System.Web.UI.WebControls.Image DrawGraph(int point)
* {
* System.Web.UI.WebControls.Image imgCntGraph;
* double widthPercent = 0;
* if(this.pollSum > 0)
* widthPercent = Math.Round(MathLib.GetPercent(point, this.pollSum), 1);
*
* imgCntGraph = new System.Web.UI.WebControls.Image();
* imgCntGraph.ImageUrl = @"/CommonApps/MemberPoll/Images/green.gif";
* imgCntGraph.Width = Unit.Percentage(widthPercent * 1.4);
* imgCntGraph.Height = 10;
* imgCntGraph.AlternateText = Unit.Percentage(widthPercent).ToString();
* imgCntGraph.ImageAlign = ImageAlign.AbsMiddle;
* imgCntGraph.Visible = true;
* return imgCntGraph;
* }
*/
#endregion
//투표
private void btnVote_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Page.Validate();
if (!Page.IsValid)
{
ClientAction.ShowMsgBack("정확히 입력하세요.");
}
dbUtil = new DBLib();
string whereClause = "poll_id =" + PostState.Self["poll_id"].ToString();
whereClause += " AND exNbr =" + rblExamples.SelectedValue;
if (dbUtil.ChangeFigure("t_PollEX", "pPoint", 1, whereClause) > 0)
{
Cookie.Self.SetCookie("voted", PostState.Self["poll_id"].ToString(), 1);
Cookie.Self.SetCookie("votedDay", System.DateTime.Today.ToString(), 1);
ClientAction.ShowMsgAndGoUrl("[" + rblExamples.SelectedValue + "." + rblExamples.SelectedItem.Text + "] 에 투표하였습니다.", Request.Url.ToString());
}
else
{
ClientAction.ShowInfoMsg("에러!!");
}
}
//회원데이터 삭제
public static void DeleteMember(string mode, string member_id)
{
dbUtil = new DBLib();
//(실제로 업데이트)
if (mode == "d")
{
string[] setNameValue = new string[2]
{
"leaveDT=GetDate()", "IPaddress = '" + WebUtil.CurrentRequest.UserHostAddress + "_" + Cookie.Self["sLoginID"] + "'"
};
dbUtil.Update_EN("t_MemberValue", setNameValue, "member_id = " + member_id);
}
else if (mode == "dd") //게시물 영구삭제(실제삭제)
{
MbrFilesMoveTo(member_id, dbUtil.Select_DR("avataImage", "t_MemberOption", "member_id=" + member_id));
dbUtil.Delete_EN("t_MemberJob", "member_id = " + member_id);
dbUtil.Delete_EN("t_MemberOption", "member_id = " + member_id);
dbUtil.Delete_EN("t_MemberValue", "member_id = " + member_id);
dbUtil.Delete_EN("t_Members", "member_id = " + member_id);
}
dbUtil.SqlConnection.Close();
URLQuery.Self.Remove("mode");
HttpContext.Current.Response.Redirect(whichList + "?" + URLQuery.Self.GetQueryString());
}
protected void rptPRFile_ItemCommand(object source, System.Web.UI.WebControls.RepeaterCommandEventArgs e)
{
if (e.CommandName == "select")
{
//dlFiles.EditItemIndex = -1;
//dlFiles.SelectedIndex = e.Item.ItemIndex;
//BindDataList();
Literal lit = (Literal)e.Item.Parent.Parent.FindControl("df_id");
string df_id = lit.Text;
string dfOrder = ((System.Web.UI.WebControls.Image)e.Item.FindControl("imgExtIcon")).AlternateText;
string dfName = e.CommandArgument.ToString();
string dfOriginName = ((LinkButton)e.Item.FindControl("dfOriginName")).Text; // Text??
//파일다운로드수 증가 -- 다운받은 후 증가해야 하는데.....
dbUtil = new DBLib();
dbUtil.ChangeFigure("t_DocFileAssets", "dfDLcount", 1, "df_id=" + df_id + " And dfOrder=" + dfOrder);
dbUtil.SqlConnection.Close();
//파일다운로드
fUtil = new JinsLibrary.FILE.FileLib();
fUtil.Open(SystemConfig.GetValue("DocUploadDir") + dfName);
fUtil.DownLoad(dfOriginName);
}
}
private bool LoadPollMain()
{
dbUtil = new DBLib();
string fieldNames, tableName, whereClause, orderBy;
fieldNames = "poll_id,pTopic,pBeginTime,pEndTime";
tableName = "t_PollMain";
whereClause = "DATEDIFF(day, pBeginTime, '" + DateTime.Now.ToShortDateString() + "') >=0";
whereClause += " AND DATEDIFF(day, pEndTime, '" + DateTime.Now.ToShortDateString() + "') <=0";
whereClause += " AND pDisplay = 1 AND IsStaff = 0";
whereClause += " AND poll_id = " + this.poll_id;
orderBy = "poll_id DESC";
//실제쿼리실행
drPoll = dbUtil.Select_DR(1, fieldNames, tableName, whereClause, orderBy);
//Response.End();
if (drPoll.HasRows)
{
drPoll.Read();
PostState.Self["poll_id"] = drPoll["poll_id"].ToString();
this.poll_id = Convert.ToInt32(drPoll["poll_id"]);
pTopic.Text = drPoll["pTopic"].ToString();
//기간세팅
period.Text = PollBaseLib.GetPeriod(drPoll["pBeginTime"], drPoll["pEndTime"]);
drPoll.Close();
return(true);
}
else
{
PostState.Self["poll_id"] = 0;
pTopic.Text = "현재 진행하고 있지 않습니다.";
return(false);
}
}
public bool ShouldCall(DBLib.Player player)
{
return true;
}
private void MemberViewBind()
{
_dbUtil = new DBLib();
string qryString = "Select member_id,loginID,loginPW,MbrName,MbrEmail,phone,cellularP,zipcode,address,findingID,findingA,SSN,newsLetter"
+ " FROM t_Member WHERE member_id=" + _mbID;
qryString += ";Select mLevel,howMuch,howMany,RFund,RFundAC,point,pointAC,unpaid,unpaidAC,rcmderID,joinDT,modifyDT,recentLogin,IPaddress,leaveDT"
+ " FROM t_MemberValue WHERE member_id=" + _mbID;
qryString += ";Select homepage,messenger,hobbies,carInfo,children,avataImage,monthlyPay,mark"
+ " FROM t_MemberOption WHERE member_id=" + _mbID;
qryString += ";Select company,jobType,officeP,zipcode,address"
+ " FROM t_MemberJob WHERE member_id=" + _mbID;
qryString += ";Select annGroup,itemFlag,annDate FROM t_Anniversary WHERE (annGroup BETWEEN 200 AND 220) AND item_id=" + _mbID;
SqlDataReader drMember;
drMember = _dbUtil.MyExecuteReader(qryString);
if (drMember.Read()) //기본정보
{
this.member_id.Text = _mbID;
ViewState["mbID"] = _mbID;
if (Convert.ToInt32(_mbID) > 0)
{
litFakeMbr.Text = "정상회원입니다.";
}
else
{
litFakeMbr.Text = "가짜회원입니다.";
}
this.member_id.Text = drMember["member_id"].ToString();
this.loginID.Text = drMember["loginID"].ToString();
this.loginPW.Text = drMember["loginPW"].ToString();
this.MbrName.Text = drMember["MbrName"].ToString();
this.phone.Text = drMember["phone"].ToString();
this.cellularP.Text = drMember["cellularP"].ToString();
this.hlEmail.Text = drMember["MbrEmail"].ToString();
string strSendonemail = this.MbrName.Text + " <" + this.hlEmail.Text + ">;";
this.hlEmail.NavigateUrl = "../Mine/Mail/MailForm.aspx?s=" + strSendonemail;
this.SSN.Text = drMember["SSN"].ToString();
this.mAddress.Text = "[" + drMember["zipcode"].ToString().Substring(0, 3) + "-" + drMember["zipcode"].ToString().Substring(3, 3) + "] ";
this.mAddress.Text += drMember["address"].ToString().Replace("|", " ");
if (Convert.ToBoolean(drMember["newsLetter"].ToString()))
{
this.newsLetter.Text = "신청";
}
else
{
this.newsLetter.Text = "비신청";
}
//Response.Write("newsLetter =" + drMember["newsLetter"].ToString());
//아이디/패스워드 잊어 버렸을 때 QnA.
SortedList mySL = JinsLibrary.XML.XmlLib.Self.GetResxList("/App_Data/resx/FindingMbrInfo.resx");
if (mySL.ContainsKey(Convert.ToInt16(drMember["findingID"])))
{
this.findingID.Text = mySL[Convert.ToInt16(drMember["findingID"])].ToString();
this.findingA.Text = drMember["findingA"].ToString();
//JinsLibrary.CONTROL.Util.DDLAddItem(ref ddl, mySL);
}
if (drMember.NextResult()) //평가치
{
drMember.Read();
this.mLevel.Text = MbrBaseLib.Self.GetStatusText((byte)drMember["mLevel"]);
this.howMuch.Text = MathLib.GetComma(drMember["howMuch"]);
this.howMany.Text = MathLib.GetComma(drMember["howMany"]);
this.RFund.Text = MathLib.GetComma(drMember["RFund"]);
this.RFundAC.Text = MathLib.GetComma(drMember["RFundAC"]);
this.point.Text = MathLib.GetComma(drMember["point"]);
this.pointAC.Text = MathLib.GetComma(drMember["pointAC"]);
this.unpaid.Text = MathLib.GetComma(drMember["unpaid"]);
this.unpaidAC.Text = MathLib.GetComma(drMember["unpaidAC"]);
this.rcmderID.Text = drMember["rcmderID"].ToString();
this.joinDT.Text = drMember["joinDT"].ToString();
this.modifyDT.Text = drMember["modifyDT"].ToString();
this.recentLogin.Text = drMember["recentLogin"].ToString();
this.IPaddress.Text = drMember["IPaddress"].ToString();
this.leaveDT.Text = drMember["leaveDT"].ToString();
if (this.leaveDT.Text != "")
{
this.mLevel.Text += " <b>[탈퇴회원]</b>";
}
}
if (drMember.NextResult()) //부가정보
{
if (drMember.Read())
{
if (drMember["avataImage"].ToString() != "")
{
this.avataImage.ImageUrl = SystemConfig.GetValue("MemberPicUploadDir") + Text.SetDefaultValue(drMember["avataImage"].ToString(), "MbrPic_default.gif");
this.avataImage.Style["cursor"] = "hand";
this.avataImage.Attributes["onClick"] = "javascript:ZoomWindowOpen('" + this.avataImage.ImageUrl + "','avaPic','');";
this.avataImage.ToolTip = "큰 이미지보기";
//이미지 리사이즈
JinsLibrary.IMAGE.ImageLib.Self.ImageResize(ref avataImage, 280, 300);
}
if (drMember["homepage"].ToString() != "")
{
this.hlHomepage.Text = "http://" + drMember["homepage"].ToString();
this.hlHomepage.NavigateUrl = "http://" + drMember["homepage"].ToString();
this.hlHomepage.Target = "_blank";
}
if (drMember["messenger"].ToString() != "|")
{
this.messenger.Text = drMember["messenger"].ToString().Replace("|", " / ");
}
this.hobbies.Text = drMember["hobbies"].ToString().Replace(";", "; ");
this.carInfo.Text = MbrBaseLib.Self.GetCarInfoText(drMember["carInfo"].ToString());
this.monthlyPay.Text = MbrBaseLib.Self.GetMonthlyPayText(drMember["monthlyPay"].ToString());
this.children.Text = drMember["children"].ToString();
this.mark.Text = HTML.ReplaceToHTML(drMember["mark"].ToString());
//부가정보보여주기
pnAdditionalInfo.Visible = true;
}
}
if (drMember.NextResult()) //회사정보
{
if (drMember.Read())
{
this.company.Text = drMember["company"].ToString();
this.jobType.Text = drMember["jobType"].ToString();
if (drMember["officeP"].ToString().Trim() != "--")
{
this.officeP.Text = drMember["officeP"].ToString();
}
if (drMember["address"].ToString() != "|")
{
this.oAddress.Text = "[" + drMember["zipcode"].ToString().Substring(0, 3) + "-" + drMember["zipcode"].ToString().Substring(3, 3) + "] ";
this.oAddress.Text += drMember["address"].ToString().Replace("|", " ");
}
//부가정보보여주기
pnAdditionalInfo.Visible = true;
}
}
if (drMember.NextResult()) //기념일 셋팅
{
while (drMember.Read())
{
switch (Convert.ToInt32(drMember["annGroup"]))
{
case 200: //생일
string anniversary = "";
if (drMember["annDate"].ToString() != "")
{
anniversary = Convert.ToDateTime(drMember["annDate"]).ToShortDateString() + " (" + drMember["itemFlag"].ToString() + ")";
}
this.litBirthDay.Text = anniversary;
break;
case 210: //결혼기념일
if (drMember["itemFlag"].ToString() == "미")
{
this.litWeddingDay.Text = "미혼";
}
else
if (drMember["annDate"].ToString() != "")
{
this.litWeddingDay.Text = Convert.ToDateTime(drMember["annDate"]).ToShortDateString();
}
break;
}
}
}
//DR,DB닫기
drMember.Close();
_dbUtil.SqlConnection.Close();
}
else
{
ClientAction.ShowMsgBack("해당 데이터가 없습니다.");
}
}
/// <summary>
/// This method confirms if user's selected products are valid for him
/// </summary>
/// <remarks>
/// By provided user Id, method uses DB stored procedure <note type="important">stp_GetUserInfo</note>
/// to get information
/// about the user and his selected products. And then confirm if all selected products are
/// valid for him.
/// </remarks>
/// <param name="id">The Id of the user, whose selected products must be confirmed</param>
/// <exception cref="Exception">
/// This is thrown if the UserID node in retXml parameter is null.
/// </exception>
/// <returns>A HttpResponseMessage with a HttpStatusCode and bundle confirmation message</returns>
public HttpResponseMessage GetBundleConfirm(int id)
{
try
{
string message = "Bundle CONFIRMED";
HttpStatusCode respCode = HttpStatusCode.OK;
XmlDocument retXml = new XmlDocument();
DBLib db = new DBLib();
db.AddProcedure("stp_GetUserInfo");
db.AddParameter("@UserID", SqlDbType.Int, id);
retXml = db.GetResultAsXmlDocument();
if (retXml.SelectSingleNode("Root/UserID") == null)
{
throw new Exception("User not found");
}
//Fill user data
int age = int.Parse(retXml.SelectSingleNode("Root/Age").InnerText);
int student = int.Parse(retXml.SelectSingleNode("Root/Student").InnerText);
int income = int.Parse(retXml.SelectSingleNode("Root/Income").InnerText);
//All products
Product[] products = new Product[]
{
new Product {
Id = 1, Name = "Current Account", Type = ProdType.Account, AgeFrom = 17, AgeTo = 999, Student = -1, Income = 1
},
new Product {
Id = 2, Name = "Current Account Plus", Type = ProdType.Account, AgeFrom = 17, AgeTo = 999, Student = -1, Income = 40001
},
new Product {
Id = 3, Name = "Junior Saver Account", Type = ProdType.Account, AgeFrom = 0, AgeTo = 17, Student = -1, Income = 0
},
new Product {
Id = 4, Name = "Student Account", Type = ProdType.Account, AgeFrom = 17, AgeTo = 999, Student = 1, Income = 0
},
new Product {
Id = 5, Name = "Debit Card", Type = ProdType.Card, AgeFrom = 0, AgeTo = 999, Student = -1, Income = 0
},
new Product {
Id = 6, Name = "Credit Card", Type = ProdType.Card, AgeFrom = 18, AgeTo = 999, Student = -1, Income = 12001
},
new Product {
Id = 7, Name = "Gold Credit Card", Type = ProdType.Card, AgeFrom = 18, AgeTo = 999, Student = -1, Income = 40001
}
};
//Filter only user products
var userProducts = products.Where(p => XDocument.Load(new XmlNodeReader(retXml)).Descendants("Id").Select(element => element.Value).ToArray().Contains(p.Id.ToString()));
//Check if at least one product selected
if (userProducts.Count() == 0)
{
message = "Zero products selected";
respCode = HttpStatusCode.BadRequest;
}
//Check if there are more than one acount product
if (userProducts.Count(p => p.Type == ProdType.Account) > 1)
{
message = "You can have only one Account type product";
respCode = HttpStatusCode.BadRequest;
}
else
{
//Check each product validity
foreach (var product in userProducts)
{
//Debit card
if (product.Id == 5)
{
//No Current Account, Current Account Plus or Student Account selected
if (userProducts.Count(p => new string[] { "1", "2", "3" }.Contains(p.Id.ToString())) == 0)
{
message = "No Current Account, Current Account Plus or Student Account selected";
respCode = HttpStatusCode.BadRequest;
break;
}
}
//Not debit card
else
{
if (!(income >= product.Income && age >= product.AgeFrom && age <= product.AgeTo && (product.Student == -1 || student == product.Student)))
{
message = "You are not valid for product - " + product.Name;
respCode = HttpStatusCode.BadRequest;
break;
}
}
}
}
var response = Request.CreateResponse <string>(respCode, message);
return(response);
}
catch (Exception e)
{
var response = Request.CreateResponse <string>(HttpStatusCode.NotFound, e.Message);
return(response);
}
}
public MbrBase()
{
dbUtil = new DBLib();
}
private void ViewPollResult()
{
//총득표수 셋팅
//this.GetPollSum();
this.pollSum = PollBaseLib.GetPollSum(this.poll_id);
dbUtil = new DBLib();
string fieldNames, tableName, whereClause, orderBy;
fieldNames = "exNbr,example,pPoint";
tableName = "t_PollEX";
whereClause = "poll_id =" + this.poll_id;
orderBy = "exNbr";
//실제쿼리실행
drPoll = dbUtil.Select_DR(fieldNames, tableName, whereClause, orderBy);
Table pTable = new Table();
TableRow tRow;
TableCell tCell;
pTable.Width = Unit.Percentage(100);
pTable.BorderWidth = 1;
pTable.BorderStyle = BorderStyle.Solid;
pTable.BorderColor = Color.LightBlue;
pTable.CellPadding = 1;
pTable.CellSpacing = 2;
tRow = new TableRow();
tRow.HorizontalAlign = HorizontalAlign.Center;
tRow.Height = 30;
tRow.BackColor = JinsLibrary.IMAGE.ImageLib.Self.ColorFromArgb("d2", "f1", "ff"); //Color.FromArgb(Convert.ToInt32("d2",16),Convert.ToInt32("f1",16) ,Convert.ToInt32("ff",16));
tCell = new TableCell();
tCell.CssClass = "header";
tCell.Text = "예문";
tRow.Cells.Add(tCell);
tCell = new TableCell();
tCell.CssClass = "header";
tCell.Width = 50;
tCell.Text = "득표수";
tRow.Cells.Add(tCell);
tCell = new TableCell();
tCell.CssClass = "header";
tCell.Text = "그래프";
tRow.Cells.Add(tCell);
pTable.Rows.Add(tRow);
while (drPoll.Read())
{
tRow = new TableRow();
tCell = new TableCell();
tCell.Text = " " + drPoll["exNbr"].ToString() + "." + drPoll["example"].ToString();
tRow.Cells.Add(tCell);
tCell = new TableCell();
tCell.BackColor = JinsLibrary.IMAGE.ImageLib.Self.ColorFromArgb("f4", "fc", "ff");
tCell.Text = drPoll["pPoint"].ToString() + " 표";
tCell.HorizontalAlign = HorizontalAlign.Center;
tRow.Cells.Add(tCell);
tCell = new TableCell();
System.Web.UI.WebControls.Image imgBar = PollBaseLib.DrawGraph(Convert.ToInt32(drPoll["pPoint"]), this.pollSum);
tCell.Controls.Add(imgBar);
tCell.Controls.Add(new LiteralControl(" " + imgBar.AlternateText));
tRow.Cells.Add(tCell);
pTable.Rows.Add(tRow);
}
tRow = new TableRow();
tRow.BackColor = JinsLibrary.IMAGE.ImageLib.Self.ColorFromArgb("d2", "f1", "ff");
tCell = new TableCell();
tRow.Height = 20;
tCell.ColumnSpan = 3;
tRow.HorizontalAlign = HorizontalAlign.Center;
tCell.Text = "[총득표수 : " + this.pollSum.ToString() + "표]";
tRow.Cells.Add(tCell);
pTable.Rows.Add(tRow);
drPoll.Close();
phViewResult.Controls.Add(pTable);
}
private Boolean MemberFormBind()
{
_dbUtil = new DBLib();
string qryString = "Select member_id,loginID,loginPW,MbrName,MbrEmail,phone,cellularP,zipcode,address,findingID,findingA,SSN,newsLetter"
+ " FROM t_Member WHERE member_id=" + _mbID;
qryString += ";Select mLevel,howMuch,howMany,RFund,RFundAC,point,pointAC,unpaid,unpaidAC,rcmderID,joinDT,recentLogin,IPaddress,leaveDT"
+ " FROM t_MemberValue WHERE member_id=" + _mbID;
qryString += ";Select homepage,messenger,hobbies,carInfo,children,avataImage,monthlyPay,mark"
+ " FROM t_MemberOption WHERE member_id=" + _mbID;
qryString += ";Select company,jobType,officeP,zipcode,address"
+ " FROM t_MemberJob WHERE member_id=" + _mbID;
qryString += ";Select annGroup,itemFlag,annDate FROM t_Anniversary WHERE (annGroup BETWEEN 200 AND 220) AND item_id=" + _mbID;
SqlDataReader drMember;
drMember = _dbUtil.MyExecuteReader(qryString);
if (drMember.Read()) //기본정보
{
string[] arrTemp;
this.member_id.Text = drMember["member_id"].ToString();
if (Convert.ToInt32(this.member_id.Text) > 0)
{
cbProMbr.Checked = false;
}
else
{
cbProMbr.Checked = true;
}
cbProMbr.Enabled = false;//수정안됨.
this.loginID.Text = drMember["loginID"].ToString();
loginID.ReadOnly = true;
loginID.BorderStyle = BorderStyle.None;
bnLoginID.Visible = false;
this.loginPW.Text = drMember["loginPW"].ToString();
this.MbrName.Text = drMember["MbrName"].ToString();
arrTemp = drMember["phone"].ToString().Split('-');
if (arrTemp.Length > 0)
{
this.phone1.Text = arrTemp[0];
this.phone2.Text = arrTemp[1];
this.phone3.Text = arrTemp[2];
arrTemp = null;
}
arrTemp = drMember["cellularP"].ToString().Split('-');
if (arrTemp.Length > 0)
{
Util.DDLFindByText(ref cellularP1, arrTemp[0]);
this.cellularP2.Text = arrTemp[1];
this.cellularP3.Text = arrTemp[2];
if (arrTemp[0] != "")
{
cellularP1.Items.RemoveAt(0);
}
arrTemp = null;
}
this.MbrEmail.Text = drMember["MbrEmail"].ToString();
arrTemp = drMember["SSN"].ToString().Split('-');
if (arrTemp.Length > 0)
{
this.SSN1.Text = arrTemp[0];
this.SSN2.Text = arrTemp[1];
arrTemp = null;
}
this.zipcode.Text = drMember["zipcode"].ToString();
arrTemp = drMember["address"].ToString().Split('|');
if (arrTemp.Length > 1)
{
this.mAddress1.Text = arrTemp[0];
this.mAddress2.Text = arrTemp[1];
arrTemp = null;
}
if (Convert.ToBoolean(drMember["newsLetter"]))
{
this.newsLetter.Checked = true;
}
else
{
this.newsLetter.Checked = false;
};
//아이디/패스워드 잊어 버렸을 때 QnA.
Util.DDLFindByValue(ref findingID, drMember["findingID"].ToString());
if (drMember["findingID"].ToString() != "")
{
findingID.Items.RemoveAt(0);
}
this.findingA.Text = drMember["findingA"].ToString();
if (drMember.NextResult()) //평가치
{
drMember.Read();
this.rcmderID.Text = drMember["rcmderID"].ToString();
rcmderID.ReadOnly = true;
rcmderID.BorderStyle = BorderStyle.None;
rcmderID.ToolTip = "수정할 수 없습니다.";
bnRcmderID.Visible = false;
Util.DDLFindByValue(ref ddlMLevel, drMember["mLevel"].ToString());
/*
* this.howMuch.Text = MathLib.GetComma(drMember["howMuch"]);
* this.howMany.Text = MathLib.GetComma(drMember["howMany"]);
* this.RFund.Text = MathLib.GetComma(drMember["RFund"]);
* this.RFundAC.Text = MathLib.GetComma(drMember["RFundAC"]);
* this.point.Text = MathLib.GetComma(drMember["point"]);
* this.pointAC.Text = MathLib.GetComma(drMember["pointAC"]);
* this.unpaid.Text = MathLib.GetComma(drMember["unpaid"]);
* this.unpaidAC.Text = MathLib.GetComma(drMember["unpaidAC"]);
* this.joinDT.Text = drMember["joinDT"].ToString();
* this.recentLogin.Text = drMember["recentLogin"].ToString();
* this.IPaddress.Text = drMember["IPaddress"].ToString();
* this.leaveDT.Text = drMember["leaveDT"].ToString();
*/
}
if (drMember.NextResult()) //부가정보
{
if (drMember.Read())
{
//파일 보존 체크박스처리
if (drMember["avataImage"].ToString() != "")
{
cbDeleteAI.Visible = true;
cbDeleteAI.ToolTip = drMember["avataImage"].ToString();
this.avataImage.ImageUrl = SystemConfig.GetValue("MemberPicUploadDir") + drMember["avataImage"].ToString();
this.avataImage.Style["cursor"] = "hand";
this.avataImage.Attributes["OnClick"] = "javascript:ZoomWindowOpen('" + this.avataImage.ImageUrl + "','avaPic','');";
//이미지 리사이즈
JinsLibrary.IMAGE.ImageLib.Self.ImageResize(ref avataImage, 260, 300);
}
this.homepage.Text = drMember["homepage"].ToString();
arrTemp = drMember["messenger"].ToString().Split('|');
if (arrTemp.Length > 1)
{
this.MsgName.Text = arrTemp[0];
this.MsgID.Text = arrTemp[1];
}
Util.CBLFindByText(ref hobbies, drMember["hobbies"].ToString().Split(';'));
Util.DDLFindByValue(ref monthlyPay, drMember["monthlyPay"].ToString());
if (drMember["monthlyPay"].ToString() != "")
{
monthlyPay.Items.RemoveAt(0);
}
Util.DDLFindByValue(ref carInfo, drMember["carInfo"].ToString());
if (drMember["carInfo"].ToString() != "")
{
carInfo.Items.RemoveAt(0);
}
this.children.Text = drMember["children"].ToString();
this.mark.Text = drMember["mark"].ToString();
}
}
if (drMember.NextResult()) //회사정보
{
if (drMember.Read())
{
this.company.Text = drMember["company"].ToString();
Util.DDLFindByText(ref jobType, drMember["jobType"].ToString());
if (drMember["jobType"].ToString() != "")
{
jobType.Items.RemoveAt(0);
}
arrTemp = drMember["officeP"].ToString().Split('-');
if (arrTemp.Length > 0)
{
//Util.DDLFindByText(ref cellularP1, arrTemp[0].ToString());
this.officeP1.Text = arrTemp[0];
this.officeP2.Text = arrTemp[1];
this.officeP3.Text = arrTemp[2];
arrTemp = null;
}
this.oZipcode.Text = drMember["zipcode"].ToString();
arrTemp = drMember["address"].ToString().Split('|');
if (arrTemp.Length > 1)
{
this.oAddress1.Text = arrTemp[0];
this.oAddress2.Text = arrTemp[1];
arrTemp = null;
}
}
}
if (drMember.NextResult()) //기념일 셋팅
{
while (drMember.Read())
{
//Response.Write( drMember["itemFlag"].ToString());
switch (Convert.ToInt32(drMember["annGroup"]))
{
case 200: //생일
Util.RBLFindByValue(ref rblSLBirth, drMember["itemFlag"].ToString());
if (drMember["annDate"].ToString() != "")
{
this.tbBirthDay.Text = Convert.ToDateTime(drMember["annDate"]).ToShortDateString();
}
break;
case 210: //결혼기념일(양력없음) -->기혼 미혼 셋팅
Util.RBLFindByValue(ref rblMarried, drMember["itemFlag"].ToString());
if (rblMarried.SelectedValue == "기")
{
if (drMember["annDate"].ToString() != "")
{
this.tbWeddingDay.Text = Convert.ToDateTime(drMember["annDate"]).ToShortDateString();
}
}
break;
}
}
}
//DR,DB닫기
drMember.Close();
_dbUtil.SqlConnection.Close();
return(true);
}
else
{
return(false);
}
}
public BoardBase()
{
dbUtil = new DBLib();
}
public bool ShouldCall(DBLib.Player player)
{
return player.OwnTurn && !player.IsBankrupted;
}
private Boolean StaffFormBind()
{
string qryString = "Select staff_id,sLoginID,sLoginPW,position,staffNbr,sName,DeptName,sClass,subJobs,phone,cellularP,ExtNbr,sEmail,SSN,zipcode,address"
+ ",homepage,mark,sLevel,sBusinessPic,sAvataImage,sData,joinDT"
+ " FROM t_Staff"
+ " WHERE staff_id=" + _sfID;
qryString += ";Select annGroup,itemFlag,annDate FROM t_Anniversary WHERE annGroup<100 AND item_id=" + _sfID;
SqlDataReader drStaff;
DBLib dbUtil = new DBLib();
drStaff = dbUtil.MyExecuteReader(qryString);
if (drStaff.Read())
{
string[] arrTemp;
//this.staff_id.Text = sfID;
this.sLoginID.Text = drStaff["sLoginID"].ToString();
this.sLoginPW.Text = drStaff["sLoginPW"].ToString();
position.Text = PtnBaseLib.Self.GetPartnerCompany(Convert.ToInt16(Cookie.Self["position"]));
this.staffNbr.Text = drStaff["staffNbr"].ToString();
this.sName.Text = drStaff["sName"].ToString();
this.DeptName.SelectedValue = drStaff["DeptName"].ToString();
this.sClass.SelectedValue = TableConfig.GetKey("Class_root", drStaff["sClass"].ToString());
this.subJobs.Text = drStaff["subJobs"].ToString();
arrTemp = drStaff["phone"].ToString().Split('-');
if (arrTemp.Length > 0)
{
this.phone1.Text = arrTemp[0];
this.phone2.Text = arrTemp[1];
this.phone3.Text = arrTemp[2];
arrTemp = null;
}
arrTemp = drStaff["cellularP"].ToString().Split('-');
if (arrTemp.Length > 0)
{
this.cellularP1.Text = arrTemp[0];
this.cellularP2.Text = arrTemp[1];
this.cellularP3.Text = arrTemp[2];
arrTemp = null;
}
this.ExtNbr.Text = drStaff["ExtNbr"].ToString();
this.sEmail.Text = drStaff["sEmail"].ToString();
arrTemp = drStaff["SSN"].ToString().Split('-');
if (arrTemp.Length > 0)
{
this.SSN1.Text = arrTemp[0];
this.SSN2.Text = arrTemp[1];
arrTemp = null;
}
this.zipcode.Text = drStaff["zipcode"].ToString();
arrTemp = drStaff["address"].ToString().Split('|');
if (arrTemp.Length > 1)
{
this.address1.Text = arrTemp[0];
this.address2.Text = arrTemp[1];
arrTemp = null;
}
this.homepage.Text = drStaff["homepage"].ToString();
this.mark.Text = drStaff["mark"].ToString();
this.sLevel.Text = drStaff["sLevel"].ToString();
//뷰스테이트로 파일 경로 저장 (체크박스 툴팁이용)
//PostState.Self["sBusinessPic"] = drStaff["sBusinessPic"].ToString();
//PostState.Self["sAvataImage"] = drStaff["sAvataImage"].ToString();
//PostState.Self["sData"] = drStaff["sData"].ToString();
this.sBusinessPic.ImageUrl = SystemConfig.GetValue("StaffUploadDir") + Text.SetDefaultValue(drStaff["sBusinessPic"].ToString(), "MyPic_default.gif");
this.sBusinessPic.Style["cursor"] = "hand";
this.sBusinessPic.Attributes["OnClick"] = "javascript:ZoomWindowOpen('" + this.sBusinessPic.ImageUrl + "','bizPic','');";
//이미지 리사이즈
JinsLibrary.IMAGE.ImageLib.Self.ImageResize(ref sBusinessPic, 150, 200);
this.sAvataImage.ImageUrl = @"../../zUpload/stfData/" + Text.SetDefaultValue(drStaff["sAvataImage"].ToString(), "MyPic_default.gif");
this.joinDT.Text = drStaff["joinDT"].ToString();
//파일 보존 체크박스처리
if (drStaff["sBusinessPic"].ToString() != "")
{
cbKeepBP.Visible = true;
cbKeepBP.Checked = true;
cbKeepBP.ToolTip = drStaff["sBusinessPic"].ToString();
}
if (drStaff["sAvataImage"].ToString() != "")
{
cbKeepAI.Visible = true;
cbKeepAI.Checked = true;
cbKeepAI.ToolTip = drStaff["sAvataImage"].ToString();
}
if (drStaff["sData"].ToString() != "")
{
cbKeepData.Visible = true;
cbKeepData.Checked = true;
cbKeepData.ToolTip = drStaff["sData"].ToString();
}
//기념일 셋팅
if (drStaff.NextResult())
{
string annDate;
while (drStaff.Read())
{
if (drStaff["annDate"].ToString() != "")
{
annDate = Convert.ToDateTime(drStaff["annDate"]).ToShortDateString();
}
else
{
annDate = "";
}
//Response.Write("----> " + drStaff["annDate"].ToString());
switch (Convert.ToInt32(drStaff["annGroup"]))
{
case 10: //생일
Util.RBLFindByValue(ref rblSLBirth, drStaff["itemFlag"].ToString());
this.tbBirthDay.Text = annDate; //Convert.ToDateTime(drStaff["annDate"]).ToShortDateString();
break;
case 20: //결혼기념일
Util.RBLFindByValue(ref rblMarried, drStaff["itemFlag"].ToString());
//this.rblMarried.SelectedValue = drStaff["itemFlag"].ToString(); //되냉
if (rblMarried.SelectedValue == "미")
{
ClientAction.WriteJavascript(this, "pnWA", "pnWA.style.display='none';");
}
else
if (drStaff["annDate"].ToString() != "")
{
this.tbWeddingDay.Text = annDate; //Convert.ToDateTime(drCard["annDate"]).ToShortDateString();
}
break;
}
}
}
//기획/관리부가 아닐때 수정못하게...
if (Convert.ToInt16(Cookie.Self["sLevel"]) < 30)
{
this.staffNbr.Enabled = false;
this.sClass.Enabled = false;
this.DeptName.Enabled = false;
this.joinDT.Enabled = false;
this.dSelectorJoinDay.Visible = false;
}
drStaff.Close();
//DB닫기
dbUtil.SqlConnection.Close();
return(true);
}
else
{
return(false);
}
}
public void Init()
{
DBLib.Register(DB);
}
static void Main(string[] args)
{
DBLib.AddPerson("Micke", "Engström", 1965);
}
private void CellViewBind()
{
_dbUtil = new DBLib();
string qryString = "Select gCode_id,gName,modelNbr,custPrice,newPrice,transPrice,joinPrice,USimmPrice,Mfger,keywords,specSummary,gOrder,status,fruitRate,postStart,postEnd,point,reserveFund,registerDT,updateDT,register,IPaddress"
+ " FROM t_GoodsCell WHERE gCode_id=" + GdsCellBaseLib.Self.gCode_id;
qryString += ";Select fileName,fileDESC"
+ " FROM t_GdsCellFiles WHERE gCode_id=" + GdsCellBaseLib.Self.gCode_id + " AND fileName LIKE 'S2%'";
qryString += ";Select scOptions, currStock "
+ " FROM t_CellStockCurrent WHERE gCode_id=" + GdsCellBaseLib.Self.gCode_id + " AND StkEnable = 1"
+ " ORDER BY scOrder DESC";
SqlDataReader drGoods = _dbUtil.MyExecuteReader(qryString);
if (drGoods.Read()) //기본정보
{
//this.fvCell.Controls[gCode_id]//
this.gCode_id.Text = drGoods["gCode_id"].ToString();
this.modelNbr.Text = drGoods["modelNbr"].ToString();
this.gName.Text = drGoods["gName"].ToString();
Title = String.Format("서비스정보 > 휴대폰정보 > {0}({1})", gName.Text, modelNbr.Text);
this.keywords.Text = drGoods["keywords"].ToString();
this.custPrice.Text = MathLib.GetComma(drGoods["custPrice"]);
this.newPrice.Text = MathLib.GetComma(drGoods["newPrice"]);
this.transPrice.Text = MathLib.GetComma(drGoods["transPrice"]);
this.joinPrice.Text = MathLib.GetComma(drGoods["joinPrice"]);
this.USimmPrice.Text = MathLib.GetComma(drGoods["USimmPrice"]);
this.Mfger.Text = drGoods["Mfger"].ToString();
//this.fruitRate.Text = MathLib.GetComma(drGoods["fruitRate"]);
//this.gOrder.Text = MathLib.GetComma(drGoods["gOrder"]);
this.point.Text = MathLib.GetComma(drGoods["point"]);
this.reserveFund.Text = MathLib.GetComma(drGoods["reserveFund"]);
//this.registerDT.Text = drGoods["registerDT"].ToString();
//this.updateDT.Text = drGoods["updateDT"].ToString();
//this.register.Text = drGoods["register"].ToString();
this.specSummary.Text = drGoods["specSummary"].ToString();
this.status.Text = GdsCellBaseLib.Self.GetStatusText(drGoods["status"]);
if (drGoods["status"].ToString() == "10")
{
hlAskPrice.Visible = true;
hlAskPrice.NavigateUrl = "/CustomerServices/QnA/QnA_Master.aspx?qgrp=quota&qgi=" + Server.UrlEncode(modelNbr.Text);
}
hlAskGoods.NavigateUrl = "/CustomerServices/QnA/QnA_Master.aspx?qnaCX=form&qgrp=gds&qgi=" + Server.UrlEncode(modelNbr.Text);
//Response.Write(drGoods["status"].ToString());
//게시기간
string postEnd = drGoods["postEnd"].ToString(); //게시종료일
this.litDisplayTerm.Text = drGoods["postStart"].ToString() + " ~ ";
if (postEnd != "")
{
this.litDisplayTerm.Text += postEnd;
}
else
{
this.litDisplayTerm.Text += "영구게시";
}
//특정상품셋팅
if (GdsCellBaseLib.Self.IsPopularGoods(this.gCode_id.Text))
{
this.GoodsClass.Text = "인기상품, ";
imgPopular.ImageUrl = "/Shop/Images/popular.gif";
imgPopular.Visible = true;
}
SortedList slSG = GdsCellBaseLib.Self.GetSpecificGcID(this.gCode_id.Text);
for (int i = 0; i < slSG.Count; i++)
{
//Response.Write(String.Format("\t{0}:\t{1}", slSG.GetKey(i), slSG.GetByIndex(i)));
this.GoodsClass.Text += slSG.GetByIndex(i) + ", ";
if (slSG.GetKey(i).ToString() == "1")
{
imgRecommand.Visible = true;
}
else if (slSG.GetKey(i).ToString() == "3")
{
imgBest.Visible = true;
}
else if (slSG.GetKey(i).ToString() == "5")
{
imgSpecial.Visible = true;
}
}
if (GoodsClass.Text.Length > 2)
{
this.GoodsClass.Text = GoodsClass.Text.Substring(0, GoodsClass.Text.Length - 2);
}
//상품데이터 폴더
_GdsUploadDir = SystemConfig.GetValue("GdsUploadDir") + "GC" + this.gCode_id.Text + "/";
this.hlLargeImages.NavigateUrl = "javascript:GoLargeImageView('" + GdsCellBaseLib.Self.gCode_id + "');";
//htmlPage페이지확인
string htmlPage = "";
//if (drGoods["htmlPage"].ToString() != "")
// htmlPage = drGoods["htmlPage"].ToString();
//else
htmlPage = _GdsUploadDir + "Detail_" + gCode_id.Text + ".html";
//Detail.html확인
if (FileLib.Self.FileExist(htmlPage))
{
pnDetailedHTML.Visible = true;
//WebUtil.CurrentResponse.Write("htmlPage = " + htmlPage);
this.litHTML.Text = FileLib.Self.LoadHtmlPage(Application["BaseHref"].ToString(), htmlPage);
//this.litHTML.Text = GdsCellBaseLib.Self.LoadHtmlPage(Application["BaseHref"].ToString(), htmlPage);
}
//else if (drGoods["htmlPage"].ToString() != "")
//{
// pnDetailedHTML.Visible = true;
// this.litHTML.Text = "파일경로에러";
//}
//string strSendonemail = this.MbrName.Text + " <" + this.hlEmail.Text +">;";
//this.hlEmail.NavigateUrl = "../Mine/Mail/MailForm.aspx?s=" + strSendonemail;
if (drGoods.NextResult()) //이미지파일정보
{
if (drGoods.HasRows)
{
this.hlLargeImages.Visible = true;
this.dlGdsImages.DataSource = drGoods;
this.dlGdsImages.DataBind(); //바인딩하기 전에 drGds.Read();하지 말것.
}
}
if (drGoods.NextResult()) //스탁정보
{
while (drGoods.Read())
{
this.currStock.Text += drGoods["scOptions"].ToString() + " => " + drGoods["currStock"].ToString() + "<br> ";
}
if (this.currStock.Text == "")
{
this.currStock.Text = "재고관리대상아님";
}
}
//DR,DB닫기
drGoods.Close();
_dbUtil.SqlConnection.Close();
}
else
{
CompanyItems_CIMasterPage_wide master = this.Master; //MainMasterPage master = (MainMasterPage)this.Master;
master.FindControl("ucClientMessage").Visible = true;
master.LitMsgText = "The Goods Don't Exist!!";
master.LitDetailsText = "요구하신 상품의 정보가 존재하지 않습니다.";
master.HlBackVisible = true;
tblCellView.Visible = false;
}
}
