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