//public string InsertMyInfo(myInfo myInfo) //{ // StringBuilder sb = new StringBuilder(); // sb.Append("insert into commonSetting(jsonMyInfo) values('"); // sb.Append(GetEscapedString(JsonConvert.SerializeObject(myInfo),false)); // sb.Append("')"); // return sb.ToString(); //} //public string UpdateMyInfo(myInfo myInfo) //{ // StringBuilder sb = new StringBuilder(); // sb.Append("update commonSetting set "); // sb.Append("jsonMyInfo = '"); // sb.Append(GetEscapedString(JsonConvert.SerializeObject(myInfo),false)); // sb.Append("'"); // return sb.ToString(); //} //public string GetMyInfo() //{ // return "select jsonMyInfo from commonSetting"; //} //public string DeleteMyInfo() //{ // return "delete jsonMyInfo from commonSetting"; //} #endregion #region 세팅데이터 //public string selectSettingInfo() //{ // StringBuilder sb = new StringBuilder(); // sb.Append("select jsonSettingInfoData from commonSetting"); // return sb.ToString(); //} //public string insertSettingInfo(CommonSettinginfo param) //{ // if (param == null) // { // throw new NullReferenceException(); // } // string info = JsonConvert.SerializeObject(param); // info= GetEscapedString(info, false); // StringBuilder sb = new StringBuilder(); // sb.Append("insert into commonSetting(jsonSettingInfoData) "); // sb.Append("values('"); // sb.Append(info); // sb.Append("')"); // return sb.ToString(); //} //public string updateSettingInfo(CommonSettinginfo param) //{ // string jsonData = JsonConvert.SerializeObject(param); // jsonData = GetEscapedString(jsonData, false); // StringBuilder sb = new StringBuilder(); // sb.Append("update commonSetting set jsonSettingInfoData='"); // sb.Append(jsonData); // sb.Append("'"); // return sb.ToString(); //} //public string DeleteSettingInfo() //{ // return "delete jsonSettingInfoData from commonSetting"; //} #endregion #region 사용자정보 public string InsertUserInfo(string id, string password, string Auth, 사용자등급 userType) { try { id = GetEscapedString(id, false); password = GetEscapedString(password, false); Auth = GetEscapedString(Auth, false); if (password == null || id == null) { throw new ArgumentNullException(); } StringBuilder sb = new StringBuilder(); sb.Append("insert into Users values('"); sb.Append(id); sb.Append("','"); sb.Append(password); sb.Append("','"); sb.Append(Auth); sb.Append("',"); sb.Append(Convert.ToInt32(userType)); sb.Append(")"); return(sb.ToString()); } catch (Exception) { throw; } }
/// <summary> ///뷰단을 세팅 /// </summary> private void SetView() { //드롭다운리스트의 데이터 바운딩 ddlUserType.DataSource = Enum.GetNames(typeof(사용자등급)); ddl견적관리.DataSource = Enum.GetNames(typeof(사용자권한)); ddl계정관리.DataSource = Enum.GetNames(typeof(사용자권한)); ddl고객정보.DataSource = Enum.GetNames(typeof(사용자권한)); ddl나의정보관리.DataSource = Enum.GetNames(typeof(사용자권한)); ddl데이터관리.DataSource = Enum.GetNames(typeof(사용자권한)); ddl매입관리.DataSource = Enum.GetNames(typeof(사용자권한)); ddl상품정보.DataSource = Enum.GetNames(typeof(사용자권한)); ddl세금계산서관리.DataSource = Enum.GetNames(typeof(사용자권한)); ddl양식정보.DataSource = Enum.GetNames(typeof(사용자권한)); ddl에프터서비스관리.DataSource = Enum.GetNames(typeof(사용자권한)); ddl인사관리.DataSource = Enum.GetNames(typeof(사용자권한)); ddl일정정보.DataSource = Enum.GetNames(typeof(사용자권한)); ddl재고관리.DataSource = Enum.GetNames(typeof(사용자권한)); ddl판매관리.DataSource = Enum.GetNames(typeof(사용자권한)); ddl표준관리.DataSource = Enum.GetNames(typeof(사용자권한)); ddl회계관리.DataSource = Enum.GetNames(typeof(사용자권한)); //유저정보 목록 보여주기 lvUserList.Items.Clear(); this.userList = (IList <UserInfoProxyVO>) new SelectUser(null).GetData(); if (userList != null) { foreach (UserInfoProxyVO up in userList) { UsersVO uv = up.UsersVO; string id = uv.UserID; 사용자등급 userType = ((사용자등급)uv.UserType); string strUserType = Enum.GetName(typeof(사용자등급), userType); string[] strData = new string[] { id, strUserType }; lvUserList.Items.Add(new ListViewItem(strData)); } } }
public string UpdateUserInfo(string id, string password, string preID, string Auth, 사용자등급 userType) { if (preID == null) { throw new ArgumentNullException(); } if (id == null) { id = preID; } string dynamicPassword = password == null ? string.Empty : string.Format("',userPassword='******'"); sb.Append(id); sb.Append(dynamicPassword); sb.Append("',userAuth='"); sb.Append(Auth); sb.Append("',userType="); sb.Append(Convert.ToInt32(userType)); sb.Append(" where userID='"); sb.Append(preID); sb.Append("'"); return(sb.ToString()); }
public string UpdateUserInfo(string id, string password, string preID, string Auth, 사용자등급 userType) { if (preID==null) { throw new ArgumentNullException(); } if (id==null) { id = preID; } string dynamicPassword = password == null ? string.Empty : string.Format("',userPassword='******'"); sb.Append(id); sb.Append(dynamicPassword); sb.Append("',userAuth='"); sb.Append(Auth); sb.Append("',userType="); sb.Append(Convert.ToInt32(userType)); sb.Append(" where userID='"); sb.Append(preID); sb.Append("'"); return sb.ToString(); }
public string InsertUserInfo(string id, string password, string Auth, 사용자등급 userType) { try { id = GetEscapedString(id, false); password = GetEscapedString(password, false); Auth = GetEscapedString(Auth, false); if (password == null || id == null) { throw new ArgumentNullException(); } StringBuilder sb = new StringBuilder(); sb.Append("insert into Users values('"); sb.Append(id); sb.Append("','"); sb.Append(password); sb.Append("','"); sb.Append(Auth); sb.Append("',"); sb.Append(Convert.ToInt32(userType)); sb.Append(")"); return sb.ToString(); } catch (Exception) { throw; } }