/// --------------------------------------------------------
public void LoadRefData()
{
BizContactType contactType = new BizContactType();
contactType.List();
selContactTypeID.DataValueField = "ContactTypeID";
selContactTypeID.DataTextField = "ContactTypeID";
selContactTypeID.DataSource = contactType;
selContactTypeID.DataBind();
DesignedNet.Framework.Web.Common.CreateSelectOneItem(selContactTypeID.Items);
BizContactStatus contactStatus = new BizContactStatus();
contactStatus.List();
selContactStatusID.DataValueField = "ContactStatusID";
selContactStatusID.DataTextField = "ContactStatusID";
selContactStatusID.DataSource = contactStatus;
selContactStatusID.DataBind();
DesignedNet.Framework.Web.Common.CreateSelectOneItem(selContactStatusID.Items);
BizCompany company = new BizCompany();
company.List();
selCompanyID.DataValueField = "CompanyID";
selCompanyID.DataTextField = "CompanyID";
selCompanyID.DataSource = company;
selCompanyID.DataBind();
DesignedNet.Framework.Web.Common.CreateSelectOneItem(selCompanyID.Items);
}
/// <summary>
/// Bizs the insert company.
/// </summary>
/// <param name="bizCompany">The biz company.</param>
/// <returns>System.String.</returns>
public string BizInsertCompany(BizCompany bizCompany)
{
return(BizCall(
new Action(() =>
{
crudFuntion.InsertCompany(bizCompany);
}
)
));
}
/// <summary>
/// Bizs the update company.
/// </summary>
/// <param name="bizCompany">The biz company.</param>
/// <returns>System.String.</returns>
public string BizUpdateCompany(BizCompany bizCompany)
{
return(BizCall(
new Action(() =>
{
crudFuntion.UpdateCompany(bizCompany);
}
)
));
}
/// <summary>
/// Datas the company to biz company.
/// </summary>
/// <param name="DataCompany">The data company.</param>
/// <returns>BizCompany.</returns>
public static BizCompany DataCompanyToBizCompany(this SYSGetCompany_Result DataCompany)
{
BizCompany bizCompany = new BizCompany
{
Id = DataCompany.Id,
CompanyName = DataCompany.CompanyName,
Active = DataCompany.Active,
};
return(bizCompany);
}
/// <summary>
/// Bizs the company to web company.
/// </summary>
/// <param name="DataCompany">The data company.</param>
/// <returns>WebCompany.</returns>
public static WebCompany BizCompanyToWebCompany(this BizCompany DataCompany)
{
WebCompany webCompany = new WebCompany
{
Id = DataCompany.Id,
CompanyName = DataCompany.CompanyName,
Active = DataCompany.Active,
};
return(webCompany);
}
/// <summary>
/// Webs the company to biz company.
/// </summary>
/// <param name="DataCompany">The data company.</param>
/// <returns>BizCompany.</returns>
public static BizCompany WebCompanyToBizCompany(this WebCompany DataCompany)
{
BizCompany bizCompany = new BizCompany
{
Id = DataCompany.Id,
CompanyName = DataCompany.CompanyName,
Active = DataCompany.Active,
};
return(bizCompany);
}
//COTYPE CMB BOX
public string cotype_Cmb(out List <DataCotypeCmb> reList, out string reMsg)
{
string reCode = "N";
DataSet ds = null;
BizCompany bizSys = null;
try
{
bizSys = new BizCompany();
try
{
ds = bizSys.cotype_Cmb();
reMsg = "[검색 성공]";
reCode = "Y";
}
catch (Exception ex)
{
reMsg = "[검색 실패]" + ex.ToString();
reCode = "N";
}
}
catch (Exception ex)
{
reMsg = "[검색 에러] :: " + ex.ToString();
reCode = "N";
}
List <DataCotypeCmb> data = new List <DataCotypeCmb>();
try
{
data = ListClass.ConvertDataTableToList <DataCotypeCmb>(ds.Tables[0]);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsSysCompanyTeam.svc (Function)::cotype_Cmb (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error");
reMsg += "/[List 에러]" + ex.ToString();
reCode = "N";
}
reList = data;
return(reCode);
}
//========================================================
//Page event handlers
//========================================================
/// --------------------------------------------------------
private void Page_Load(object sender, System.EventArgs e)
{
// do site security
DoSecurity();
// get id from querystring
_selectedCompanyID = DesignedNet.Framework.Web.Common.GetID(Request.QueryString, "CompanyID");
if (_selectedCompanyID < 1)
{
_selectedCompanyID = DesignedNet.Framework.Web.Common.GetID(ViewState, "CompanyID");
}
// populate list control
_companyList = new BizCompany();
_companyList.List();
list.DataSource = _companyList;
// decide page mode
_company = new BizCompany();
_company.Table = _companyList.Table;
if (_selectedCompanyID > 0)
{
// load selected
if (_company.Find(_selectedCompanyID))
{
edit.DataSource = _company;
view.DataSource = _company;
if (!Page.IsPostBack)
{
Render(Common.PageMode.View);
}
}
else // user not found
{
Render(Common.PageMode.Error, "The item selected was not found in the database!");
}
}
else
{
if (!Page.IsPostBack)
{
Render(Common.PageMode.New);
}
}
}
/// --------------------------------------------------------
public void LoadRefData()
{
BizCommentType commentType = new BizCommentType();
commentType.List();
selCommentTypeID.DataValueField = "CommentTypeID";
selCommentTypeID.DataTextField = "CommentTypeID";
selCommentTypeID.DataSource = commentType;
selCommentTypeID.DataBind();
DesignedNet.Framework.Web.Common.CreateSelectOneItem(selCommentTypeID.Items);
BizProject project = new BizProject();
project.List();
selProjectID.DataValueField = "ProjectID";
selProjectID.DataTextField = "ProjectID";
selProjectID.DataSource = project;
selProjectID.DataBind();
DesignedNet.Framework.Web.Common.CreateSelectOneItem(selProjectID.Items);
BizCompany company = new BizCompany();
company.List();
selCompanyID.DataValueField = "CompanyID";
selCompanyID.DataTextField = "CompanyID";
selCompanyID.DataSource = company;
selCompanyID.DataBind();
DesignedNet.Framework.Web.Common.CreateSelectOneItem(selCompanyID.Items);
BizContact contact = new BizContact();
contact.List();
selContactID.DataValueField = "ContactID";
selContactID.DataTextField = "ContactID";
selContactID.DataSource = contact;
selContactID.DataBind();
DesignedNet.Framework.Web.Common.CreateSelectOneItem(selContactID.Items);
}
public string mCompanySiteLog(string pCoCd, string pSiteCd, string pCoNm, string pConstCcd, string pCoTypeScd, string pStartDate, string pEndDate, string pUsingFlag, string pSortNo, string pMemo, string pInputId, out string reMsg, out string reData)
{
string reCode = "N";
reData = "";
BizCompany bizSys = null;
try
{
bizSys = new BizCompany();
int reCnt = bizSys.mCompanySiteLog(pCoCd, pSiteCd, pCoNm, pConstCcd, pCoTypeScd, pStartDate, pEndDate, pUsingFlag, pSortNo, pMemo, pInputId);
if (reCnt > 0)
{
reMsg = "[저장 성공]";
reCode = "Y";
reData = reCnt.ToString();
}
else
{
reMsg = "[저장 성공] - 정보 없음";
reCode = "Y";
}
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsSysCompanyTeam.svc (Function)::mCompanySiteLog (Detail)::" + "\r\n" + ex.ToString(), "Error");
reMsg = "[저장 에러] :: " + ex.ToString();
reCode = "N";
}
return(reCode);
}
public string mConpanyMainLog(string pCoCd, string pCoNm, string pBizNo, string pConstCcd, string pCoTypeScd, string pOwnerNm, string pTel, string pAddr, string pUsingCnt, string pInputId, out string reMsg, out string reData)
{
string reCode = "N";
reData = "";
BizCompany bizSys = null;
try
{
bizSys = new BizCompany();
int reCnt = bizSys.mConpanyMainLog(pCoCd, pCoNm, pBizNo, pConstCcd, pCoTypeScd, pOwnerNm, pTel, pAddr, pUsingCnt, pInputId);
if (reCnt > 0)
{
reMsg = "[저장 성공]";
reCode = "Y";
reData = reCnt.ToString();
}
else
{
reMsg = "[저장 성공] - 정보 없음";
reCode = "Y";
}
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsSysCompanyTeam.svc (Function)::mConpanyMainLog (Detail)::" + "\r\n" + ex.ToString(), "Error");
reMsg = "[저장 에러] :: " + ex.ToString();
reCode = "N";
}
return(reCode);
}
//INSERT WITH PROCEDURE
public string aCompanyPro(string pDbNm, string[] param, out string reData, out string reMsg)
{
string reCode = "N";
string reVal = "";
BizCompany bizSys = null;
try
{
bizSys = new BizCompany();
try
{
Hashtable hParam = new Hashtable();
hParam.Add("pSite_Cd", Convert.ToInt32(param[0]));
hParam.Add("pCo_Nm", param[1].ToString());
hParam.Add("pBiz_No", param[2].ToString());
hParam.Add("pConst_Ccd", Convert.ToInt32(param[3]));
hParam.Add("pCo_Type_Scd", param[4].ToString());
hParam.Add("pOwner_Nm", param[5].ToString());
hParam.Add("pTel", param[6].ToString());
hParam.Add("pAddr", param[7].ToString());
hParam.Add("pStart_Date", Convert.ToInt32(param[8]));
hParam.Add("pEnd_Date", Convert.ToInt32(param[9]));
hParam.Add("pMemo", param[10].ToString());
hParam.Add("pSort_No", Convert.ToInt32(param[11]));
hParam.Add("pInput_Id", Convert.ToInt32(param[12]));
hParam.Add("@rtnCo_Cd", "");
reVal = bizSys.aCompanyPro(pDbNm, hParam, out Hashtable outVal);
if (outVal != null)
{
foreach (DictionaryEntry dictionaryEntry in outVal)
{
string[] row = new string[] { dictionaryEntry.Key.ToString(), dictionaryEntry.Value.ToString(), "" };
//string rowCount = row.Length.ToString();
//string rowKey = row[0].ToString();
reVal = row[1].ToString();
}
}
reMsg = "[검색 성공]";
reCode = "Y";
}
catch (Exception ex)
{
reMsg = "[검색 실패]" + ex.ToString();
reCode = "N";
}
}
catch (Exception ex)
{
reMsg = "[검색 에러 - BizSystem 연결 실패] :: " + ex.ToString();
reCode = "N";
}
reData = reVal;
return(reCode);
}
