public CRMTrackInfoToDb(CRMTrackInfo TrackInfo)
: base(s_metadata)
{
SetSqlInt64(0, TrackInfo.ID);
SetSqlInt64(1, TrackInfo.CRMID);
SetSqlString(2, TrackInfo.VisitPeople);
SetSqlString(3, TrackInfo.VisitTime);
SetSqlString(4, TrackInfo.VisitPlace);
SetSqlString(5, TrackInfo.VisitForm);
SetSqlString(6, TrackInfo.GiftsArticles);
SetSqlString(7, TrackInfo.VisitToCustomerEvaluation);
SetSqlString(8, TrackInfo.VisitingPersonnelFeedbackVisit);
SetSqlString(9, TrackInfo.ProjectCustomerCommunication);
SetSqlString(10, TrackInfo.CustomerSupportAndAssistance);
SetSqlString(11, TrackInfo.CreateTime);
SetSqlString(12, TrackInfo.UpdateTime);
SetSqlString(13, TrackInfo.Str1);
SetSqlString(14, TrackInfo.Str2);
SetSqlString(15, TrackInfo.Str3);
SetSqlString(16, TrackInfo.Str4);
SetSqlString(17, TrackInfo.Str5);
SetSqlString(18, TrackInfo.Str6);
SetSqlString(19, TrackInfo.Str7);
SetSqlString(20, TrackInfo.Str8);
}
public IEnumerable <CRMTrackInfo> GetCRMTrackInfo(CRMTrackInfo Info)
{
DbParam[] dbParams =
{
new DbParam("@SqlWhere", DbType.String, this.GetSqlWhere(Info), ParameterDirection.Input)
};
return(base.ExecuteDataTable("Proc_GetCRMTrackInfo", dbParams).ConvertToEntityCollection <CRMTrackInfo>());
}
public string GetSqlWhere(CRMTrackInfo info)
{
StringBuilder sb = new StringBuilder();
sb.Append("1=1 ");
if (info.ID != 0)
{
sb.Append(" and ID = '" + info.ID + "'");
}
if (info.CRMID != 0)
{
sb.Append(" and CRMID = '" + info.CRMID + "'");
}
return(sb.ToString());
}
public CRMTrackInfo Convert()
{
CRMTrackInfo crmInfo = new CRMTrackInfo()
{
ID = this.TempID,
CRMID = this.CRMID,
VisitPeople = this.VisitPeople,
VisitTime = this.VisitTime.ToString(),
VisitPlace = this.VisitPlace,
VisitForm = this.VisitForm,
GiftsArticles = this.GiftsArticles,
VisitToCustomerEvaluation = this.VisitToCustomerEvaluation,
VisitingPersonnelFeedbackVisit = this.VisitingPersonnelFeedbackVisit,
ProjectCustomerCommunication = this.ProjectCustomerCommunication,
CustomerSupportAndAssistance = this.CustomerSupportAndAssistance
};
return(crmInfo);
}
public CRMTrackInfo OperateCRMTrackInfo(CRMTrackInfo TrackInfo)
{
using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString))
{
var CRMTrackList = new List <CRMTrackInfoToDb>();
CRMTrackList.Add(new CRMTrackInfoToDb(TrackInfo));
SqlCommand cmd = new SqlCommand("Proc_OperateCRMTrackinfo", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CRMTrackSOURCE", CRMTrackList);
cmd.Parameters[0].SqlDbType = SqlDbType.Structured;
cmd.Parameters.AddWithValue("@outputID", 0);
cmd.Parameters[1].Direction = ParameterDirection.Output;
cmd.Parameters[1].SqlDbType = SqlDbType.BigInt;
conn.Open();
cmd.ExecuteNonQuery();
TrackInfo.ID = Convert.ToInt64(cmd.Parameters[1].Value);
return(TrackInfo);
}
}
