public void DownLoadCSVFile()
{
string out_msg = string.Empty;
string proc_name = xmlCommonUtil.PROCEDURE_TITLE;
SqlParameter[] sqlparams = xmlCommonUtil.SQLPARAMETERS;
DataSet ds = null;
try
{
ds = xmlCommonUtil.ReturnDataSet_Common(proc_name, sqlparams, false, out out_msg);
}
catch (Exception ex)
{
out_msg = xmlCommonUtil.returnErrorMSGXML("DownLoadCSVFile", ex);
}
if (!string.IsNullOrEmpty(out_msg))
{
xmlCommonUtil.ResponseWrite(out_msg);
return;
}
if (ds == null || ds.Tables.Count == 0)
{
xmlCommonUtil.ResponseWriteErrorMSG("DownLoadCSVFile 리턴 데이터에 오류가 있습니다.");
return;
}
this.MakeCSVFile(ds);
}
private DataSet Attachment_CRD(
CRUD crd,
string attachment_key,
string filename,
string fileformat,
long filesize,
out string msg)
{
string out_msg = string.Empty;
//
string proc_name = this.ATTACHMENT_R_PROC;
switch (crd)
{
case CRUD.C:
case CRUD.U:
case CRUD.D:
proc_name = this.ATTACHMENT_CUD_PROC;
break;
case CRUD.R:
proc_name = this.ATTACHMENT_R_PROC;
break;
}
//
List <SqlParameter> temp_param = new List <SqlParameter>();
temp_param.Add(new SqlParameter("@" + XMLCommonUtil.GUBUN_KEY_STRING, crd.ToString()));
temp_param.Add(new SqlParameter("@" + XMLCommonUtil.OPERATOR_IP_GUBUN, _httpContext.Request.ServerVariables["REMOTE_ADDR"]));
temp_param.Add(new SqlParameter("@" + XMLCommonUtil.OPERATOR_KEY_GUBUN, xmlCommonUtil.QueryString[XMLCommonUtil.OPERATOR_KEY_GUBUN]));
//*
bool include_organization_key = XMLCommonUtil.INCLUDE_ORGANIZATION_KEY;
if (include_organization_key)
{
temp_param.Add(new SqlParameter("@" + XMLCommonUtil.ORGANIZATION_KEY_GUBUN, xmlCommonUtil.QueryString[XMLCommonUtil.ORGANIZATION_KEY_GUBUN].ToString()));
}
//*/
switch (crd)
{
case CRUD.R:
case CRUD.D:
temp_param.Add(new SqlParameter("@" + ATTACHMENT_KEY_key, attachment_key));
break;
case CRUD.C:
temp_param.Add(new SqlParameter("@" + ATTACHMENT_GUBUN_key, this.ATTACHMENT_TYPE.ToString()));
temp_param.Add(new SqlParameter("@" + ATTACHMENT_DETAIL_CODE_key, this.ATTACHMENT_DETAIL_CODE));
temp_param.Add(new SqlParameter("@" + ATTACHMENT_FILENAME_key, filename));
temp_param.Add(new SqlParameter("@" + ATTACHMENT_FILEFORMAT_key, fileformat));
temp_param.Add(new SqlParameter("@" + ATTACHMENT_FILESIZE_key, filesize));
break;
}
SqlParameter[] sqlparams = temp_param.ToArray();
DataSet ds = null;
//
try
{
ds = xmlCommonUtil.ReturnDataSet_Common(proc_name, sqlparams, false, out out_msg);
}
catch (Exception ex)
{
//throw ex;
msg = xmlCommonUtil.returnErrorMSGXML("ReturnDataSet_Common", ex);
return(null);
}
msg = out_msg;
/*
* if (ds == null || ds.Tables.Count ==0 || ds.Tables[0].Rows.Count == 0)
* {
* return null;
* }
*
* DataTable dt = ds.Tables[0];
* //*/
return(ds);//dt.Rows[0];
}