public TermEntity Download(int documentId)
{
try
{
this.connector.Database = DbNames.Database.BmbDigital;
this.connector.Procedure = "spr_digit_ler_campa_incen_termo";
this.connector.AddParameter("num_campa_incen_termo", documentId);
using (var reader = this.connector.ExecuteReader())
{
while (reader.Read())
{
var c = new TermEntity
{
Id = Convert.ToInt32(reader["num_campa_incen_termo"]),
Name = reader["nom_campa_incen_termo"].ToString(),
//CreationDate = reader["dat_publi"].ToDateTime(),
Extention = reader["tip_exten"].ToString(),
Contents = (byte[])reader["val_docum"],
//UserId = reader["cod_user"].ToString()
TotalBytes = Convert.ToInt64(reader["num_bytes"])
};
return(c);
}
}
return(null);
}
finally
{
this.connector.Dispose();
}
}
public List <TermEntity> ReadByCampaign(int campaignId)
{
try
{
var terms = new List <TermEntity>();
this.connector.Database = DbNames.Database.BmbDigital;
this.connector.Procedure = "spr_digit_ler_refat_campa_incen_termo_por_campa";
this.connector.AddParameter("num_campa_incen", campaignId);
using (var reader = this.connector.ExecuteReader())
{
while (reader.Read())
{
var t = new TermEntity
{
Id = Convert.ToInt32(reader["num_campa_incen_termo"]),
Name = reader["nom_campa_incen_termo"].ToString(),
//CreationDate = reader["dat_publi"].ToDateTime(),
Extention = reader["tip_exten"].ToString(),
Contents = (byte[])reader["val_docum"],
//UserId = reader["cod_user"].ToString()
TotalBytes = Convert.ToInt64(reader["num_bytes"])
};
terms.Add(t);
}
}
return(terms);
}
finally
{
this.connector.Dispose();
}
}
public TermEntity Register(int incentiveCampaignId, TermEntity term, string codUser)
{
try
{
this.connector.Procedure = "spr_digit_ins_campa_incen_termo";
this.connector.AddParameter("num_campa_incen", incentiveCampaignId);
this.connector.AddParameter("nom_campa_incen_termo", term.Name);
this.connector.AddParameter("dat_publi", DateTime.Now);
this.connector.AddParameter("tip_exten", term.Extention);
this.connector.AddParameter("val_docum", term.Contents);
this.connector.AddParameter("num_bytes", term.TotalBytes);
this.connector.AddParameter("cod_usu", codUser);
using (var reader = this.connector.ExecuteReader())
{
while (reader.Read())
{
term.Id = Convert.ToInt32(reader["num_campa_incen_termo"]);
return(term);
}
}
return(null);
}
catch (Exception ex)
{
throw;
}
finally
{
this.connector.Dispose();
}
}
public bool Register(int incentiveCampaignId, TermEntity term, string codUser)
{
try
{
var sql = "spr_digit_ins_campa_incen_termo";
using (var cmd = new SqlCommand(sql, connection))
{
cmd.Parameters.AddWithValue("@num_campa_incen", incentiveCampaignId);
cmd.Parameters.AddWithValue("@nom_campa_incen_termo]", term.Name);
cmd.Parameters.AddWithValue("@dat_publi]", term.PublishDate);
cmd.Parameters.AddWithValue("@tip_exten]", term.Extention);
cmd.Parameters.AddWithValue("@val_docum]", term.Contents);
cmd.Parameters.AddWithValue("@num_bytes]", term.TotalBytes);
cmd.Parameters.AddWithValue("@cod_user]", codUser);
var datareader = cmd.ExecuteReader();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteTermEntity(TermEntity termEntityToDelete)
{
using (var db = new PlutoContext())
{
db.Entry(termEntityToDelete).State = EntityState.Deleted;
db.SaveChanges();
}
}
public void UpdateTermEntity(TermEntity termEntityToUpdate)
{
using (var db = new PlutoContext())
{
db.Entry(termEntityToUpdate).State = EntityState.Modified;
db.SaveChanges();
}
}
private Term ConvertToModel(TermEntity termEntity)
{
var term = new Term(termEntity.Name, termEntity.IsActive,
termEntity.IsActive ? new Period((DateTime)termEntity.StartDate, (DateTime)termEntity.EndDate) : null);
term.Load(termEntity.Id, termEntity.IsClosed);
return(term);
}
public int AddTermEntity(TermEntity termEntity)
{
using (var db = new PlutoContext())
{
db.Terms.Add(termEntity);
db.SaveChanges();
}
return(termEntity.Id);
}
public bool Upload(int campaignId, TermEntity term)
{
var relatedCampaign = incentiveCampaignApl.GetById(campaignId);
if (relatedCampaign == null)
{
throw new Exception("Campaign.Does.Not.Exists");
}
return(termDb.Upload(campaignId, term));
}
public HttpResponseMessage InsertTerm(RequestModel request)
{
var result = WebHelper.GetResult(request);
if (result.Code == DoubleX.Infrastructure.Utility.EnumHelper.GetValue(EnumResultCode.操作成功))
{
var projectId = JsonHelper.GetValue(request.Obj, "ProjectId");
var projectGuid = Guid.Parse(projectId);
var termSrc = JsonHelper.GetValue(request.Obj, "TermSrc");
var termSrcLang = JsonHelper.GetValue(request.Obj, "TermSrcLang");
var termTgt = JsonHelper.GetValue(request.Obj, "TermTgt");
var termTgtLang = JsonHelper.GetValue(request.Obj, "TermTgtLang");
var flag = JsonHelper.GetValue(request.Obj, "UserId");
var list = termService.Query(item => item.ProjectId == projectGuid && item.TermSrc == termSrc && item.TermSrcLang == termSrcLang && item.TermTgtLang == termTgtLang);
if (list != null && list.Count > 0)
{
result.Message = "已具有相同术语！";
}
else
{
TermEntity term = new TermEntity()
{
Id = Guid.NewGuid(),
ProjectId = projectGuid,
CreateId = Guid.Parse(WebHelper.GetContext().Member.MemberId),
CreateDt = DateTime.Now,
CreateIP = BrowserHelper.GetClientIP(),
LastId = Guid.Parse(WebHelper.GetContext().Member.MemberId),
LastDt = DateTime.Now,
LastIP = BrowserHelper.GetClientIP(),
IsDelete = false,
TermSrc = termSrc,
TermSrcLang = termSrcLang,
TermTgt = termTgt,
TermTgtLang = termTgtLang,
PlatformCode = 0,
UserId = flag,
Type = 0,
Status = 0
};
termService.Insert(term);
result.Message = "新增术语成功！";
}
}
return(WebApiHelper.ToHttpResponseMessage(result));
}
public TermEntity Register(int incentiveCampaignId, TermEntity term, string codUser)
{
return(termDb.Register(incentiveCampaignId, term, codUser));
}
public bool Upload(int campaignId, TermEntity term)
{
throw new NotImplementedException();
}
