public static void CreateNewAdvise(AdviseEntity adviseEntity) { if (adviseEntity != null) { AdviseInfo resultInfo = TranslateAdviseInfo(adviseEntity); new AdviseRepository().CreateNewAdvise(resultInfo); } }
public AdviseInfo GetAdviseInfoByID(long adviseId) { AdviseInfo result = new AdviseInfo(); DataCommand command = new DataCommand(ConnectionString, GetDbCommand(AdviseStatement.GetAdviseInfoByID, "Text")); command.AddInputParameter("@AdviseID", DbType.Int64, adviseId); result = command.ExecuteEntity <AdviseInfo>(); return(result); }
public static void ModifyAdvise(AdviseEntity adviseEntity) { if (adviseEntity != null) { AdviseInfo resultInfo = TranslateAdviseInfo(adviseEntity); resultInfo.ModifyDate = DateTime.Now; new AdviseRepository().ModifyAdvise(resultInfo); } }
public int ModifyAdviseDealInfo(AdviseInfo adviseInfo) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(AdviseStatement.DealAdviseInfo, "Text")); command.AddInputParameter("@AdviseID", DbType.Int64, adviseInfo.AdviseID); command.AddInputParameter("@DealStatus", DbType.Int32, adviseInfo.DealStatus); command.AddInputParameter("@DealSummary", DbType.String, adviseInfo.DealSummary); command.AddInputParameter("@Operator", DbType.Int64, adviseInfo.Operator); command.AddInputParameter("@ModifyDate", DbType.DateTime, adviseInfo.ModifyDate); return(command.ExecuteNonQuery()); }
public static int ModifyDealInfo(AdviseEntity adviseEntity) { int result = 0; if (adviseEntity != null) { AdviseInfo resultInfo = TranslateAdviseInfo(adviseEntity); resultInfo.ModifyDate = DateTime.Now; result = new AdviseRepository().ModifyAdviseDealInfo(resultInfo); } return(result); }
public int CreateNewAdvise(AdviseInfo adviseInfo) { DataCommand command = new DataCommand(ConnectionString, GetDbCommand(AdviseStatement.CreateNewtAdviseInfo, "Text")); command.AddInputParameter("@AdviseTitle", DbType.String, adviseInfo.AdviseTitle); command.AddInputParameter("@Summary", DbType.String, adviseInfo.Summary); command.AddInputParameter("@CustomerID", DbType.Int64, adviseInfo.CustomerID); command.AddInputParameter("@CustomerName", DbType.String, adviseInfo.CustomerName); command.AddInputParameter("@CustomerMobile", DbType.String, adviseInfo.CustomerMobile); command.AddInputParameter("@DealStatus", DbType.Int32, adviseInfo.DealStatus); command.AddInputParameter("@DealSummary", DbType.String, adviseInfo.DealSummary); command.AddInputParameter("@Operator", DbType.Int64, adviseInfo.Operator); command.AddInputParameter("@CreateDate", DbType.DateTime, adviseInfo.CreateDate); command.AddInputParameter("@ModifyDate", DbType.DateTime, adviseInfo.ModifyDate); return(command.ExecuteNonQuery()); }
private static AdviseEntity TranslateAdviseEntity(AdviseInfo adviseInfo) { AdviseEntity adviseEntity = new AdviseEntity(); if (adviseInfo != null) { adviseEntity.AdviseID = adviseInfo.AdviseID; adviseEntity.AdviseTitle = adviseInfo.AdviseTitle; adviseEntity.Summary = adviseInfo.Summary; adviseEntity.CustomerID = adviseInfo.CustomerID; adviseEntity.CustomerName = adviseInfo.CustomerName; adviseEntity.CustomerMobile = adviseInfo.CustomerMobile; adviseEntity.DealStatus = adviseInfo.DealStatus; adviseEntity.DealSummary = adviseInfo.DealSummary; adviseEntity.Operator = adviseInfo.Operator; adviseEntity.ModifyDate = adviseInfo.ModifyDate; } return(adviseEntity); }