public static int Insert(PartnerEntity partnerEntity)
{
if (partnerEntity.PartnerDBEntity.Count == 0)
{
return 0;
}
if (partnerEntity.LogMessages == null)
{
return 0;
}
if (CheckInsert(partnerEntity) > 0)
{
return 2;
}
PartnerDBEntity dbParm = (partnerEntity.PartnerDBEntity.Count > 0) ? partnerEntity.PartnerDBEntity[0] : new PartnerDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("InsertPartnerLink");
cmd.SetParameterValue("@PartnerID", dbParm.PartnerID);
cmd.SetParameterValue("@PartnerLink", dbParm.PartnerLink);
cmd.SetParameterValue("@PartnerTitle", dbParm.PartnerTitle);
cmd.SetParameterValue("@Cost", String.IsNullOrEmpty(dbParm.PartnerCost) ? "0" : dbParm.PartnerCost);
cmd.SetParameterValue("@Remark", dbParm.Remark);
cmd.SetParameterValue("@UserID", partnerEntity.LogMessages.Username);
return cmd.ExecuteNonQuery();
}
public static PartnerEntity ChartSelect(PartnerEntity partnerEntity)
{
PartnerDBEntity dbParm = (partnerEntity.PartnerDBEntity.Count > 0) ? partnerEntity.PartnerDBEntity[0] : new PartnerDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("GetPartnerLinkChartList");
cmd.SetParameterValue("@SysID", dbParm.SysID);
if (String.IsNullOrEmpty(dbParm.StartDTime))
{
cmd.SetParameterValue("@StartDTime", DBNull.Value);
}
else
{
cmd.SetParameterValue("@StartDTime", dbParm.StartDTime);
}
if (String.IsNullOrEmpty(dbParm.EndDTime))
{
cmd.SetParameterValue("@EndDTime", DBNull.Value);
}
else
{
cmd.SetParameterValue("@EndDTime", dbParm.EndDTime);
}
partnerEntity.QueryResult = cmd.ExecuteDataSet();
return partnerEntity;
}
public static int CheckInsert(PartnerEntity partnerEntity)
{
PartnerDBEntity dbParm = (partnerEntity.PartnerDBEntity.Count > 0) ? partnerEntity.PartnerDBEntity[0] : new PartnerDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("ChkInsertPartnerLink");
cmd.SetParameterValue("@PartnerID", dbParm.PartnerID);
cmd.SetParameterValue("@PartnerLink", dbParm.PartnerLink);
DataSet dsResult = cmd.ExecuteDataSet();
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
return 1;
}
return 0;
}
public static int Update(PartnerEntity partnerEntity)
{
partnerEntity.LogMessages.MsgType = MessageType.INFO;
partnerEntity.LogMessages.Content = _nameSpaceClass + "Update";
LoggerHelper.LogWriter(partnerEntity.LogMessages);
try
{
return PartnerDA.Update(partnerEntity);
}
catch (Exception ex)
{
partnerEntity.LogMessages.MsgType = MessageType.ERROR;
partnerEntity.LogMessages.Content = _nameSpaceClass + "Update Error: " + ex.Message;
LoggerHelper.LogWriter(partnerEntity.LogMessages);
throw ex;
}
}