////Reference UploadLeadBiz.cs
public static List <SearchUploadLeadResult> SearchUploadLeadData(SearchUploadLeadCondition suld)
{
KKSlmTrUploadLeadModel search = new KKSlmTrUploadLeadModel();
//string createDate = data.CreatedDate.Year != 1 ? data.CreatedDate.Year + data.CreatedDate.ToString("-MM-dd") : string.Empty;
//string assignDate = data.AssignedDate.Year != 1 ? data.AssignedDate.Year + data.AssignedDate.ToString("-MM-dd") : string.Empty;
return(search.SearchUploadLeadData(suld));
}
//Reference : SlmScr003Biz,RoleBiz
public List <SearchUploadLeadResult> SearchUploadLeadData(SearchUploadLeadCondition suld)
{
string sql = "";
sql = @" SELECT ul.[slm_UploadLeadId]
,ul.[slm_CampaignCode]
,ul.[slm_FileName]
,ul.[slm_LeadCount]
,ul.[slm_LeadAssignedCount]
,ul.[slm_Status]
,ul.[slm_AssignedDate]
,ul.[Is_Deleted]
,isnull(su.slm_PositionName +'-','')+isnull(su.slm_StaffNameTH,'') [slm_UpdatedBy]
,ul.[slm_UpdatedDate]
,isnull(sc.slm_PositionName +'-','')+isnull(sc.slm_StaffNameTH,'') [slm_CreatedBy]
,ul.[slm_CreatedDate] from kkslm_tr_upload_lead ul
left join kkslm_ms_staff su on ul.slm_UpdatedBy = su.slm_UserName
left join kkslm_ms_staff sc on ul.slm_CreatedBy = sc.slm_UserName
";
string whr = "";
whr += (whr == "" ? "" : " AND ") + @"ul.Is_Deleted is null or ul.Is_Deleted = 0 ";
if (suld.slm_FileName != "")
{
whr += (whr == "" ? "" : " AND ") + @"ul.slm_FileName like '%" + suld.slm_FileName + "%'";
}
if (suld.slm_Status != "0")
{
whr += (whr == "" ? "" : " AND ") + @"ul.slm_Status = '" + suld.slm_Status + "'";
}
if (suld.UploadedDateForm != "1-01-01")
{
whr += (whr == "" ? "" : " AND ") + @" CONVERT(DATE,ul.slm_UpdatedDate) >= '" + suld.UploadedDateForm + "'";
}
if (suld.UploadedDateTo != "1-01-01")
{
whr += (whr == "" ? "" : " AND ") + @" CONVERT(DATE,ul.slm_UpdatedDate) <= '" + suld.UploadedDateTo + "'";
}
sql += (whr == "" ? "" : " WHERE " + whr);
sql += " ORDER BY ul.slm_UpdatedDate";
return(slmdb.ExecuteStoreQuery <SearchUploadLeadResult>(sql).ToList());
}
private void DoSearchUploadLead(int pageIndex)
{
try
{
SearchUploadLeadCondition search = new SearchUploadLeadCondition();
search.slm_FileName = txtFileName.Text.Trim();
search.slm_Status = cmbStatus.SelectedItem.Value.Trim();
search.UploadedDateForm = tdmFormDatePopup.DateValue.Year.ToString() + tdmFormDatePopup.DateValue.ToString("-MM-dd");
search.UploadedDateTo = tdmToDatePopup.DateValue.Year.ToString() + tdmToDatePopup.DateValue.ToString("-MM-dd");
List <SearchUploadLeadResult> list = UploadLeadBiz.SearchUploadLeadData(search);
BindGridview(pcTop, list.ToArray(), pageIndex);
//upResult.Update();
}
catch (Exception ex)
{
throw ex;
}
}
