public string exportToWord()
{
// Step 1. Read data from database
if (isStoreNameEmpty())
{
return("Store Name is empty");
}
if (hasParameterStore)
{
try
{
ConnectData cdata = new ConnectData();
// get connectString from Sacombank
cdata.ConnectString = System.Configuration.ConfigurationManager.ConnectionStrings["gMVVMConnectionString"].ConnectionString;
foreach (KeyValuePair <string, string> pair in this.storeParameterValue)
{
cdata.Paramerters.Add(pair.Key);
cdata.ParamertersValue.Add(pair.Value);
cdata.ParametersType.Add(SqlDbType.VarChar);
}
// get data from database to datatable
if (!cdata.Read_Store(StoreName, true))
{
return("Gọi Store thất bại");
}
//bat dau export
WordTemplateBase word = new WordTemplateBase()
{
TemplatePath = this.FilePath
};
word.Data = cdata.DataSource;
this.packageStream = word.ExcuteMailMergeSimple();
return(null);
}
catch (Exception ex)
{
if (ex.Message == "Passed invalid TemplatePath to Excel Template")
{
return("Chưa có mẫu báo cáo dạng excel.");
}
return(ex.Message);
}
}
return(null);
}
public string exportToWord()
{
// Step 1. Read data from database
if (isStoreNameEmpty())
return "Store Name is empty";
if (hasParameterStore)
{
try
{
ConnectData cdata = new ConnectData();
// get connectString from Sacombank
cdata.ConnectString = System.Configuration.ConfigurationManager.ConnectionStrings["gMVVMConnectionString"].ConnectionString;
foreach (KeyValuePair<string, string> pair in this.storeParameterValue)
{
cdata.Paramerters.Add(pair.Key);
cdata.ParamertersValue.Add(pair.Value);
cdata.ParametersType.Add(SqlDbType.VarChar);
}
// get data from database to datatable
if (!cdata.Read_Store(StoreName, true)) return "Gọi Store thất bại";
//bat dau export
WordTemplateBase word = new WordTemplateBase()
{
TemplatePath = this.FilePath
};
word.Data = cdata.DataSource;
this.packageStream = word.ExcuteMailMergeSimple();
return null;
}
catch (Exception ex)
{
if (ex.Message == "Passed invalid TemplatePath to Excel Template")
return "Chưa có mẫu báo cáo dạng excel.";
return ex.Message;
}
}
return null;
}
