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