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);
}
