/// <summary>
/// 修改
/// </summary>
private void Update()
{
PartnerEntity entity = new PartnerEntity(this.PartnerID);
if (fuPicture.PostedFile.ContentLength > 0)
{
Stream fileStream = fuPicture.PostedFile.InputStream;
byte[] FileContent = new byte[fileStream.Length];
fileStream.Read(FileContent, 0, FileContent.Length);
fileStream.Close();
byte[] LittlePicture = FileContent;
entity.Image = LittlePicture;
}
entity.Name = txtName.Text.Trim();
entity.URL = txtURL.Text.Trim();
if (txtSort.Text.Trim() == "")
{
entity.sort = 0;
}
else
{
entity.sort = NDConvert.ToInt32(txtSort.Text.Trim());
}
new PartnerRule().Update(entity);
}
/// <summary>
/// 保存
/// </summary>
private void Save()
{
PartnerEntity entity = new PartnerEntity();
Stream fileStream = fuPicture.PostedFile.InputStream;
byte[] FileContent = new byte[fileStream.Length];
fileStream.Read(FileContent, 0, FileContent.Length);
fileStream.Close();
byte[] LittlePicture = FileContent;
entity.ID = Guid.NewGuid().ToString();
entity.Name = txtName.Text.Trim();
entity.URL = txtURL.Text.Trim();
if (txtSort.Text.Trim() == "")
{
entity.sort = 0;
}
else
{
entity.sort = NDConvert.ToInt32(txtSort.Text.Trim());
}
entity.Status = (int)CommonEnum.PartnerStatus.Online;
if (FileContent.Length > 0)
{
entity.Image = FileContent;
}
new PartnerRule().Add(entity);
}
public ActionResult SavePartner(PartnerEntity partner)
{
bool isSaved = false;
DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter(User.Identity.Name);
using (adapter)
{
adapter.StartTransaction(System.Data.IsolationLevel.Serializable, "SavePartner");
PartnerEntity partner4Save;
if (partner.PartnerId == 0)
{
partner.IsActive = true;
partner4Save = partner;
partner4Save.FirmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
}
else
{
partner4Save = PartnerEntity.FetchPartner(adapter, null, partner.PartnerId);
partner4Save.UpdateDataFromOtherObject(partner, null, null);
}
isSaved = adapter.SaveEntity(partner4Save);
adapter.Commit();
}
dynamic response = new { IsSaved = isSaved };
return(CreateJsonResponse(response));
}
public ActionResult UpdatePartnerInfo(PartnerEntity partner)
{
using (IDbContextTransaction tran = _context.Database.BeginTransaction())
{
try
{
if (Utility.UpdatePartner(_context, partner))
{
tran.Commit();
}
PartnerEntity entity = Utility.GetPartnerInfo(_context, partner.userId);
return(Ok(new Result
{
Status = 200,
Message = string.Empty,
Data = entity
}));
}
catch (Exception ex)
{
tran.Rollback();
}
}
return(Ok(new Result
{
Status = 404,
Message = string.Empty,
Data = null
}));
}
/// <summary>
/// 数据行操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowIndex = NDConvert.ToInt32(e.CommandArgument);
string partnerID = grid.DataKeys[rowIndex]["ID"].ToString();
switch (e.CommandName)
{
case "Status":
PartnerEntity entity = new PartnerEntity(partnerID);
if (entity.Status == (int)CommonEnum.PartnerStatus.Offline)
{
entity.Status = (int)CommonEnum.PartnerStatus.Online;
}
else
{
entity.Status = (int)CommonEnum.PartnerStatus.Offline;
}
new PartnerRule().Update(entity);
PageHelper.ShowMessage("状态更改成功！");
BindGridView();
break;
case "View":
PageHelper.WriteScript("window.open('ImagePhoto.aspx?ID=" + partnerID + "');");
break;
}
}
public string CompleteCustomer_Married_NoChild_NoPet_Correct(IWebDriver driver)
{
customerEntity = repository.GetCustomer("Married");
partnerEntity = repository.GetPartner("Correct");
summary.AccessToStep1(driver);
customer.IntroduceFirstName(driver, customerEntity.FirstName);
customer.IntroduceLastName(driver, customerEntity.LastName);
customer.IntroduceBirthday(driver, customerEntity.Day, customerEntity.Month, customerEntity.Year);
customer.IntroduceMatitalStatus(driver, customerEntity.MaritalStatus);
customer.IntroducePostCode(driver, customerEntity.PostCode);
customer.IntroduceNumber(driver, customerEntity.Address1);
customer.IntroduceStreet(driver, customerEntity.Address2);
customer.IntroduceVillage(driver, customerEntity.Town);
customer.IntroducePhone(driver, customerEntity.Telephone);
customer.ClickOnNext(driver);
partner.IntroduceFirstName(driver, partnerEntity.FirstName);
partner.IntroduceLastName(driver, partnerEntity.LastName);
partner.IntroduceBirthday(driver, partnerEntity.Day, partnerEntity.Month, partnerEntity.Year);
partner.IntroducePostCode(driver, partnerEntity.PostCode);
partner.IntroduceNumber(driver, partnerEntity.Address1);
partner.IntroduceStreet(driver, partnerEntity.Address2);
partner.IntroduceVillage(driver, partnerEntity.Town);
partner.IntroduceCity(driver, partnerEntity.City);
partner.ClickOnNext(driver);
childrenExisting.ClickOnNo(driver);
petsExisting.ClickOnNo(driver);
return(driver.Url);
}
public long EditUser(UserModel model)
{
Contract.Assert(model.UserId.HasValue);
var user = this.Manager.Load(model.UserId.Value);
var role = this.RoleManager.Load(model.RoleId);
PartnerEntity partner = null;
if (model.PartnerId.HasValue)
{
partner = this.PartnerManager.Load(model.PartnerId.Value);
}
user.Name = model.Name;
user.Email = model.Email;
user.UserPasswordCredential.Login = model.Login;
user.Role = role;
user.Partner = partner;
using (var tx = new Transaction())
{
this.Manager.Update(user);
tx.Complete();
}
return(user.Id);
}
public ActionResult GetPartner(long partnerId)
{
using (DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter())
{
PartnerEntity partner = PartnerEntity.FetchPartner(adapter, null, partnerId);
return(CreateJsonResponse(partner));
}
}
/// <summary>
/// 加载数据
/// </summary>
private void LoadData()
{
PartnerEntity entity = new PartnerEntity(this.PartnerID);
txtName.Text = entity.Name;
txtURL.Text = entity.URL;
txtSort.Text = entity.sort.ToString();
}
/// <summary>
/// Adds a new partner to the database.
/// </summary>
/// <param name="partner">The Id property is automatically generated.</param>
/// <returns></returns>
public static bool Add(PartnerEntity partner)
{
if (partner == null)
{
return(false);
}
return(DatabaseConnection.Add <PartnerEntity>(partner));
}
/// <summary>
/// Modifies a partner in the database.
/// </summary>
/// <param name="partner">The Id property cannot be modified.</param>
/// <returns></returns>
public static bool Modify(PartnerEntity partner)
{
if (partner == null)
{
return(false);
}
return(DatabaseConnection.Modify <PartnerEntity>(partner, p => p.Id == partner.Id));
}
public static PartnerEntity CreateTestPartner(this BusinessIntegrationTestBase testBase)
{
var p = new PartnerEntity {
Name = ShortStringGenerator.GetRandomValue()
};
return(p);
}
public string CompleteCustomer_Married_Child_Pet_Correct(IWebDriver driver)
{
customerEntity = repository.GetCustomer("Married");
partnerEntity = repository.GetPartner("Correct");
childrenEntity = repository.GetChildren("Correct");
petEntity = repository.GetPet("Correct");
summary.AccessToStep1(driver);
customer.IntroduceFirstName(driver, customerEntity.FirstName);
customer.IntroduceLastName(driver, customerEntity.LastName);
customer.IntroduceBirthday(driver, customerEntity.Day, customerEntity.Month, customerEntity.Year);
customer.IntroduceMatitalStatus(driver, customerEntity.MaritalStatus);
customer.IntroducePostCode(driver, customerEntity.PostCode);
customer.IntroduceNumber(driver, customerEntity.Address1);
customer.IntroduceStreet(driver, customerEntity.Address2);
customer.IntroduceVillage(driver, customerEntity.Town);
customer.IntroducePhone(driver, customerEntity.Telephone);
customer.ClickOnNext(driver);
partner.IntroduceFirstName(driver, partnerEntity.FirstName);
partner.IntroduceLastName(driver, partnerEntity.LastName);
partner.IntroduceBirthday(driver, partnerEntity.Day, partnerEntity.Month, partnerEntity.Year);
partner.IntroducePostCode(driver, partnerEntity.PostCode);
partner.IntroduceNumber(driver, partnerEntity.Address1);
partner.IntroduceStreet(driver, partnerEntity.Address2);
partner.IntroduceVillage(driver, partnerEntity.Town);
partner.ClickOnNext(driver);
childrenExisting.ClickOnYes(driver);
children.AddChild(driver);
children.IntroduceFirstName(driver, childrenEntity.FirstName);
children.IntroduceLastName(driver, childrenEntity.LastName);
children.IntroduceBirthday(driver, childrenEntity.Day, childrenEntity.Month, childrenEntity.Year);
children.IntroduceRelationship(driver, childrenEntity.Relation);
children.IntroducePostcode(driver, childrenEntity.PostCode);
children.IntroduceNumber(driver, childrenEntity.Number);
children.IntroduceStreet(driver, childrenEntity.Street);
children.IntroduceTown(driver, childrenEntity.Town);
children.IntroduceCity(driver, childrenEntity.City);
children.ClickOnSaveChild(driver);
children.ClickOnNext(driver);
petsExisting.ClickOnYes(driver);
pets.AddPet(driver);
pets.IntroduceName(driver, petEntity.Name);
pets.IntroduceType(driver, petEntity.Type);
pets.ClickOnSavePet(driver);
pets.ClickOnNext(driver);
return(driver.Url);
}
/// <summary>
/// Removes a partner from the database with the same Id.
/// </summary>
/// <param name="partner">The Id property selects the partner.</param>
/// <returns></returns>
public static bool Remove(PartnerEntity partner)
{
if ((partner == null) ||
(TransactionProvider.IsExistHead(p => p.PartnerId == partner.Id)))
{
return(false);
}
return(DatabaseConnection.Remove <PartnerEntity>(p => p.Id == partner.Id));
}
public ActionResult GetPartnerCollection()
{
using (DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter())
{
long firmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
IEnumerable <PartnerEntity> partnerCollection = PartnerEntity.FetchActivePartnerCollection(adapter, firmaId).OrderBy(p => p.Naziv);
return(CreateJsonResponse(partnerCollection));
}
}
protected override void SetDataSource(DataAccessAdapterBase adapter,
RelationPredicateBucket bucket,
int pageNumber,
int pageSize,
string sortField,
bool isSortAscending)
{
this.DataSource = PartnerEntity.FetchPartnerCollectionForPaging(adapter, bucket, null, pageNumber, pageSize, sortField, isSortAscending);
this.NoOfRecords = PartnerEntity.GetNumberOfEntities(adapter, bucket);
}
public long CreatePartner(PartnerModel model)
{
var partner = new PartnerEntity {
Name = model.Name, Disabled = model.Disabled
};
this.Manager.Create(partner);
return(partner.Id);
}
public ActionResult GetPartnerInfo([FromRoute] decimal userId)
{
PartnerEntity entity = Utility.GetPartnerInfo(_context, userId);
return(Ok(new Result
{
Status = 200,
Message = string.Empty,
Data = entity
}));
}
public async Task <PartnerEntity> UpdateAsync(PartnerEntity request)
{
using (var cnx = _context.conexao())
{
string _query = $@"Update Partner set name = '{request.Name}', document = '{request.Document}', situation = '{request.Situation}', status = {request.Status.GetHashCode()}, partnerCode = '{request.PartnerCode}'
where partnerId = '{request.PartnerId}'";
var result = await cnx.QueryAsync <PartnerEntity>(_query);
return(new PartnerEntity(request.PartnerId, request.Name, request.Document, request.Situation, request.Status, request.PartnerCode));
}
}
private static PartnerBattleObject CreatePartnerBattleObject(PartnerEntity partner)
{
return(new PartnerBattleObject
{
Id = partner.Id,
SystemName = partner.SystemName,
DisplayName = partner.DisplayName,
Mind = TeamDao.Instance.SelectByPrimaryKey(1).Level * 10,
CurrentHp = 1,
Skill1 = SkillDao.Instance.SelectByPrimaryKey(partner.Skill1),
CharacterType = CharacterType.Partner
});
}
public void Update(PartnerEntity entity, SqliteDatabase mdb = null)
{
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE partner SET ")
.Append("id = ")
.Append(entity.Id)
.Append(",")
.Append("system_name = ")
.Append("'")
.Append(entity.SystemName)
.Append("'")
.Append(",")
.Append("display_name = ")
.Append("'")
.Append(entity.DisplayName)
.Append("'")
.Append(",")
.Append("lang = ")
.Append("'")
.Append(entity.Lang)
.Append("'")
.Append(",")
.Append("skill1 = ")
.Append(entity.Skill1)
.Append(" WHERE id = ")
.Append(entity.Id)
.Append(";");
if (mdb == null)
{
DbManager.Instance.ExecuteNonQuery(sb.ToString());
}
else
{
DbManager.Instance.ExecuteNonQuery(sb.ToString(), mdb);
}
}
private PartnerEntity CreateEntity(DataRow row)
{
PartnerEntity entity = new PartnerEntity();
entity.Id = DaoSupport.GetIntValue(row, "id");
entity.SystemName = DaoSupport.GetStringValue(row, "system_name");
entity.DisplayName = DaoSupport.GetStringValue(row, "display_name");
entity.Lang = DaoSupport.GetStringValue(row, "lang");
entity.Skill1 = DaoSupport.GetIntValue(row, "skill1");
return(entity);
}
public async Task <PartnerDTO> CreatePartnerAsync(CreatePartnerDTO createPartnerDTO)
{
var partner = new PartnerEntity
{
Name = createPartnerDTO.Name,
Description = createPartnerDTO.Description
};
await _DBContext.Partners.AddAsync(partner);
await _DBContext.SaveChangesAsync();
var PartnerDTO = _mapper.Map <PartnerDTO>(partner);
return(PartnerDTO);
}
public async Task <PartnerEntity> CreateAsync(PartnerEntity request)
{
using (var cnx = _context.conexao())
{
// Montando string de script que irá ser executada pela conexão
string _query = $@"insert into Partner(partnerId, name, document, situation, status, partnerCode)
values ('{request.PartnerId}',
'{request.Name}',
'{request.Document}',
{request.Situation},
{request.Status.GetHashCode()},
'{request.PartnerCode}')";
// Obtendo o resultado mapeado para PartnerEntity da conexão
var result = await cnx.QueryAsync <PartnerEntity>(_query);
// Retorno
return(new PartnerEntity(request.PartnerId, request.Name, request.Document, request.Situation, request.Status, request.PartnerCode));
}
}
public void Insert(PartnerEntity entity, SqliteDatabase mdb = null)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO partner VALUES (")
.Append(entity.Id)
.Append(",")
.Append("'")
.Append(entity.SystemName)
.Append("'")
.Append(",")
.Append("'")
.Append(entity.DisplayName)
.Append("'")
.Append(",")
.Append("'")
.Append(entity.Lang)
.Append("'")
.Append(",")
.Append(entity.Skill1)
.Append(");");
if (mdb == null)
{
DbManager.Instance.ExecuteNonQuery(sb.ToString());
}
else
{
DbManager.Instance.ExecuteNonQuery(sb.ToString(), mdb);
}
}
/// <summary>
/// 初始化页面
/// </summary>
private void InitPage()
{
try
{
if (this.PartnerID != string.Empty)
{
PartnerEntity entity = new PartnerEntity(this.PartnerID);
if (entity.Image.Length > 0)
{
Response.AddHeader("Content-Disposition", "filename=img" + this.PartnerID + ".jpg");
Response.ContentType = "image/*";
Response.BinaryWrite(entity.Image);
Response.End();
}
}
}
catch
{
}
}
/// <summary>
///
/// </summary>
/// <param name="request"></param>
public async Task <DefaultDataResponse> CreateAsync(PartnerPostRequest request)
{
var validator = new PartnerPostRequestValidator();
var validationResult = validator.Validate(request);
var existPartner = await partnerRepository.GetByDocument(request.Document);
if (existPartner != null)
{
return(ErrorResponse <MiniErpErrors>(MiniErpErrors.Partner_Post_400_Document_Cannot_Be_Duplicate.ToString()));
}
if (!validationResult.IsValid)
{
return(ErrorResponse <MiniErpErrors>(validationResult.Errors.ToErrorCodeList()));
}
var partner = new PartnerEntity(request);
var result = await partnerRepository.CreateAsync(partner);
return(SuccessResponse(result));
}
public long CreateUser(UserModel model)
{
PartnerEntity partner = null;
if (model.PartnerId.HasValue)
{
partner = this.PartnerManager.Load(model.PartnerId.Value);
}
var role = this.RoleManager.Load(model.RoleId);
var user = new UserEntity
{
Name = model.Name,
Email = model.Email,
Partner = partner,
Role = role
};
this.Manager.Create(user, model.Login, model.Password);
return(user.Id);
}
/// <summary>
/// 设置风格
/// </summary>
/// <param name="partner"></param>
protected virtual void SetPartnerStyle(PartnerEntity partner)
{
if (partner == null)
{
return;
}
var query = new QueryInfo();
query.SetCacheTime(DateTime.MaxValue).From <StyleEntity>();
var infos = this.GetEntities <StyleEntity>(query);
if (infos != null)
{
if (partner.MobileStyle != null)
{
partner.MobileStyle = infos.FirstOrDefault(it => it.Id == partner.MobileStyle.Id);
}
if (partner.WebsiteStyle != null)
{
partner.WebsiteStyle = infos.FirstOrDefault(it => it.Id == partner.WebsiteStyle.Id);
}
}
}
public static bool ModifyPartner(PartnerEntity partner)
{
return(PartnerProvider.Modify(partner));
}
