private IDataReader GetDataReaderOfAttachment()
{
var report = this.GetReport(this._attachmentTopic.ReportId);
if (report == null)
{
this.SetErrorStatus("The report does not find.");
return(null);
}
var connectOpt = new ConnectionOptions
{
DataSource = report.Rdbms.Server,
InitialCatalog = report.Rdbms.Catalog,
UserId = report.Rdbms.UserId,
Password = report.Rdbms.Password,
ReadOnly = report.Rdbms.ReadOnly
};
var provider = report.Rdbms.Provider;
var sqlStatement = this._attachmentTopic.SqlStatement;
var parameters = this._attachmentTopic.Parameter;
if (String.IsNullOrWhiteSpace(parameters))
{
return(StorageManager.CreateInstance(connectOpt, provider).GetDataReader(sqlStatement));
}
var parms = StorageParameter.ConvertStringToParameter(parameters);
return(StorageManager.CreateInstance(connectOpt, provider).GetDataReader(sqlStatement, parms));
}
public ActionResult UserSubscribe()
{
if (!TempData.ContainsKey(ReportId))
{
return(BlankView("There are not report or any fields to subscribe."));
}
var reportId = (Guid)TempData[ReportId];
var tableOrView = TempData[TableOrView] as string;
var sql = TempData[Sql] as string;
var sqlParameter = TempData[SqlParameter] as IDictionary <string, object>;
var parameters = StorageParameter.ConvertParameterToString(sqlParameter);
var subscribers = new List <SubscriberDto> {
new SubscriberDto {
Email = this.LoginUser.Email
}
};
var model = new AttachmentTopicDto
{
TopicName = tableOrView,
ReportId = reportId,
SqlStatement = CryptoFactory.AES.Encrypt(sql),
Parameter = CryptoFactory.AES.Encrypt(parameters),
Subscribers = subscribers
};
this.ViewBagTask();
return(PartialView(model));
}
// POST api/values
public string Post([FromBody] StorageParameter storageParameter)
{
using (var db = new BloggingContext())
{
try
{
var goodsNoList = storageParameter.GoodsNo.Split(',');
var uIdList = storageParameter.UID.Split(',');
var query = from b in db.GoodsStorages
where goodsNoList.Contains(b.goodsno) && uIdList.Contains(b.uid)
select b;
var memcards = query.ToList();
var msg = SuceessReturn(memcards);
return(msg);
}
catch (Exception e)
{
return(errorReturn());
}
}
}
