private voMIP_FILE_STORE getFileStore(string fileIdx)
{
Database db = new Database();
FileManager fileManager = new FileManager();
voMIP_FILE_STORE _DM_FILE_STORE = null;
try
{
db.DBConnect();
_DM_FILE_STORE = fileManager.getFileByKey(fileIdx, db.getOcnn());
}
catch (Exception ex)
{
//throw ex;
}
finally
{
db.getOcnn().Close();
db.DBDisconnect();
}
return(_DM_FILE_STORE);
}
/// <summary>
/// 查詢商品資訊
/// </summary>
/// <param name="proId"></param>
private void queryProductData(string HAPPY_ID)
{
Database db = new Database();
DataTable dt = new DataTable();
int nRet = -1;
/*Query Data */
//string strSQL = "SELECT * FROM MIP_PRODUCT WHERE PRO_ID = " + proId;
string strSQL = "select HAPPY_ID, CSTATUS, FILE_KIND, APPLY_TARGET, CKEY1, CKEY2, CKEY3, TITLE, URL, F_IDX, F_NAME, CORDER, LDATE, LUSER ,selectall, ISTESTER from MIP_Happy WHERE HAPPY_ID = @HAPPY_ID";
try
{
//db.DBConnect();
/*連線DB*/
//nRet = db.ExecQuerySQLCommand(strSQL, ref dt);
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@HAPPY_ID", HAPPY_ID)
};
dt = Database.GetDataTable(strSQL, parameter);
foreach (DataRow row in dt.Rows)
{
strProId = row["HAPPY_ID"].ToString();
str_radType = row["CKEY1"].ToString();
str_dlDataType = row["CKEY2"].ToString();
str_dlDataClass = row["CKEY3"].ToString();
str_txtTitle = row["TITLE"].ToString();
str_txtUrl = row["URL"].ToString();
str_txtOrder = row["CORDER"].ToString();
str_radStatus = row["CSTATUS"].ToString();
strDmIdx = row["F_IDX"].ToString();
strSelectAll = row["selectall"].ToString();
strIstester = row["ISTESTER"].ToString();
//檔案索引
strDmIdx = row["F_IDX"].ToString();
sHidDmIdx.Value = MDS.Utility.NUtility.checkString(strDmIdx);
voMIP_FILE_STORE _DM_FILE_STORE = getFileStore(strDmIdx);
if (_DM_FILE_STORE != null && _DM_FILE_STORE.FILE_ORI_NAME != null)
{
if (str_dlDataType == "B2010")
{
_hypLinkIdx.Text = "檔名:" + MDS.Utility.NUtility.HtmlEncode(MDS.Utility.NUtility.checkString(_DM_FILE_STORE.FILE_ORI_NAME.Trim()));
_hypLinkIdx.NavigateUrl = Page.ResolveUrl("~/MDSAPI/FileProvider.ashx?FILE_INDEX=" + strDmIdx);
}
else
{
HyperLink1.Text = "檔名:" + MDS.Utility.NUtility.HtmlEncode(MDS.Utility.NUtility.checkString(_DM_FILE_STORE.FILE_ORI_NAME.Trim()));
HyperLink1.NavigateUrl = Page.ResolveUrl("~/MDSAPI/FileProvider.ashx?FILE_INDEX=" + strDmIdx);
}
}
}
selectDataType();
selectDataClass();
setData();
}
catch (Exception ex)
{
Debug.Write("YL0050M Exception :" + ex.Message);
throw ex;
}
}
