/// <summary>
/// 获得数据列表
/// </summary>
public List <LPWeb.Model.ServiceTypes> DataTableToList(DataTable dt)
{
List <LPWeb.Model.ServiceTypes> modelList = new List <LPWeb.Model.ServiceTypes>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
LPWeb.Model.ServiceTypes model;
for (int n = 0; n < rowsCount; n++)
{
model = new LPWeb.Model.ServiceTypes();
if (dt.Rows[n]["ServiceTypeId"].ToString() != "")
{
model.ServiceTypeId = int.Parse(dt.Rows[n]["ServiceTypeId"].ToString());
}
model.Name = dt.Rows[n]["Name"].ToString();
if (dt.Rows[n]["Enabled"].ToString() != "")
{
if ((dt.Rows[n]["Enabled"].ToString() == "1") || (dt.Rows[n]["Enabled"].ToString().ToLower() == "true"))
{
model.Enabled = true;
}
else
{
model.Enabled = false;
}
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LPWeb.Model.ServiceTypes model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LPWeb.Model.ServiceTypes model)
{
dal.Update(model);
}
private void BindLables()
{
if (iContactID == 0)
{
return;
}
int iContactBranchID = 0;
int iCompanyID = 0;
string raw_data = "";
string processed_data = " ";
try
{
Contacts bllContact = new Contacts();
LPWeb.Model.Contacts mContact = new LPWeb.Model.Contacts();
mContact = bllContact.GetModel(iContactID);
lbName.Text = mContact.LastName + ", " + mContact.FirstName;
lbEnabled.Text = mContact.Enabled?"Yes":"No";
if (mContact.CellPhone != null)
{
raw_data = mContact.CellPhone.Trim();
raw_data = System.Text.RegularExpressions.Regex.Replace(raw_data, @"[-() ]", String.Empty);
if (raw_data.Length > 10)
{
raw_data = raw_data.Substring(0, 10);
}
if (raw_data.Length == 10)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 4);
}
else if (raw_data.Length == 9)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 3);
}
else if (raw_data.Length == 8)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 2);
}
else if (raw_data.Length == 7)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 1);
}
else if (raw_data.Length == 6)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-";
}
else if (raw_data.Length == 5)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 2) + " -";
}
else if (raw_data.Length == 4)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 1) + " -";
}
else if (raw_data.Length == 3)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + " -";
}
else if (raw_data.Length == 2)
{
processed_data = "(" + raw_data.Substring(0, 2) + " ) " + " -";
}
else if (raw_data.Length == 1)
{
processed_data = "(" + raw_data.Substring(0, 1) + " ) " + " -";
}
else
{
processed_data = "( ) - ";
}
}
else
{
processed_data = "( ) - ";
}
lbCellPhone.Text = processed_data;
if (mContact.BusinessPhone != null)
{
raw_data = mContact.BusinessPhone.Trim();
raw_data = System.Text.RegularExpressions.Regex.Replace(raw_data, @"[-() ]", String.Empty);
if (raw_data.Length > 10)
{
raw_data = raw_data.Substring(0, 10);
}
if (raw_data.Length == 10)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 4);
}
else if (raw_data.Length == 9)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 3);
}
else if (raw_data.Length == 8)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 2);
}
else if (raw_data.Length == 7)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 1);
}
else if (raw_data.Length == 6)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-";
}
else if (raw_data.Length == 5)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 2) + " -";
}
else if (raw_data.Length == 4)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 1) + " -";
}
else if (raw_data.Length == 3)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + " -";
}
else if (raw_data.Length == 2)
{
processed_data = "(" + raw_data.Substring(0, 2) + " ) " + " -";
}
else if (raw_data.Length == 1)
{
processed_data = "(" + raw_data.Substring(0, 1) + " ) " + " -";
}
else
{
processed_data = "( ) - ";
}
}
else
{
processed_data = "( ) - ";
}
lbBussinessPhone.Text = processed_data;
raw_data = mContact.Fax;
if (mContact.Fax != null)
{
raw_data = mContact.Fax.Trim();
raw_data = System.Text.RegularExpressions.Regex.Replace(raw_data, @"[-() ]", String.Empty);
if (raw_data.Length > 10)
{
raw_data = raw_data.Substring(0, 10);
}
if (raw_data.Length == 10)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 4);
}
else if (raw_data.Length == 9)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 3);
}
else if (raw_data.Length == 8)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 2);
}
else if (raw_data.Length == 7)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 1);
}
else if (raw_data.Length == 6)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-";
}
else if (raw_data.Length == 5)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 2) + " -";
}
else if (raw_data.Length == 4)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 1) + " -";
}
else if (raw_data.Length == 3)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + " -";
}
else if (raw_data.Length == 2)
{
processed_data = "(" + raw_data.Substring(0, 2) + " ) " + " -";
}
else if (raw_data.Length == 1)
{
processed_data = "(" + raw_data.Substring(0, 1) + " ) " + " -";
}
else
{
processed_data = "( ) - ";
}
}
else
{
processed_data = "( ) - ";
}
lbFax.Text = processed_data;
lbEmail.Text = mContact.Email;
if (mContact.ContactCompanyId.HasValue)
{
iCompanyID = mContact.ContactCompanyId.Value;
}
if (mContact.ContactBranchId.HasValue)
{
iContactBranchID = mContact.ContactBranchId.Value;
}
}
catch (Exception ex)
{
}
try
{
ContactBranches bllCB = new ContactBranches();
LPWeb.Model.ContactBranches mCB = new LPWeb.Model.ContactBranches();
mCB = bllCB.GetModel(iContactBranchID);
lbBranch.Text = mCB.Name;
if (mCB.Phone != null)
{
raw_data = mCB.Phone.Trim();
raw_data = System.Text.RegularExpressions.Regex.Replace(raw_data, @"[-() ]", String.Empty);
if (raw_data.Length > 10)
{
raw_data = raw_data.Substring(0, 10);
}
if (raw_data.Length == 10)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 4);
}
else if (raw_data.Length == 9)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 3);
}
else if (raw_data.Length == 8)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 2);
}
else if (raw_data.Length == 7)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 1);
}
else if (raw_data.Length == 6)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-";
}
else if (raw_data.Length == 5)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 2) + " -";
}
else if (raw_data.Length == 4)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 1) + " -";
}
else if (raw_data.Length == 3)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + " -";
}
else if (raw_data.Length == 2)
{
processed_data = "(" + raw_data.Substring(0, 2) + " ) " + " -";
}
else if (raw_data.Length == 1)
{
processed_data = "(" + raw_data.Substring(0, 1) + " ) " + " -";
}
else
{
processed_data = "( ) - ";
}
}
else
{
processed_data = "( ) - ";
}
lbPhone.Text = processed_data;
if (mCB.Fax != null)
{
raw_data = mCB.Fax.Trim();
raw_data = System.Text.RegularExpressions.Regex.Replace(raw_data, @"[-() ]", String.Empty);
if (raw_data.Length > 10)
{
raw_data = raw_data.Substring(0, 10);
}
if (raw_data.Length == 10)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 4);
}
else if (raw_data.Length == 9)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 3);
}
else if (raw_data.Length == 8)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 2);
}
else if (raw_data.Length == 7)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-" + raw_data.Substring(6, 1);
}
else if (raw_data.Length == 6)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 3) + "-";
}
else if (raw_data.Length == 5)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 2) + " -";
}
else if (raw_data.Length == 4)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + raw_data.Substring(3, 1) + " -";
}
else if (raw_data.Length == 3)
{
processed_data = "(" + raw_data.Substring(0, 3) + ") " + " -";
}
else if (raw_data.Length == 2)
{
processed_data = "(" + raw_data.Substring(0, 2) + " ) " + " -";
}
else if (raw_data.Length == 1)
{
processed_data = "(" + raw_data.Substring(0, 1) + " ) " + " -";
}
else
{
processed_data = "( ) - ";
}
}
else
{
processed_data = "( ) - ";
}
lbFax1.Text = processed_data;
lbAddress.Text = mCB.Address;
lbCity.Text = mCB.City + " " + mCB.State + " " + mCB.Zip;
if (mCB.ContactCompanyId.HasValue && iCompanyID == 0)
{
iCompanyID = mCB.ContactCompanyId.Value;
}
}
catch (Exception ex)
{ }
int iServiceTypeID = 0;
try
{
ContactCompanies bllCC = new ContactCompanies();
LPWeb.Model.ContactCompanies mCC = new LPWeb.Model.ContactCompanies();
mCC = bllCC.GetModel(iCompanyID);
//lbServiceType.Text = mCC.ServiceTypes;
lbCompany.Text = mCC.Name;
iServiceTypeID = mCC.ServiceTypeId;
}
catch
{ }
try
{
ServiceTypes blST = new ServiceTypes();
LPWeb.Model.ServiceTypes mST = new LPWeb.Model.ServiceTypes();
mST = blST.GetModel(iServiceTypeID);
lbServiceType.Text = mST.Name;
}
catch
{ }
#region Referral Amount/Referral Funded/Wind Ratio
string sSql = "select dbo.lpfn_GetTotalReferral(" + this.iContactID + ", " + this.CurrUser.iUserID + ") as TotalReferral, "
+ "dbo.lpfn_GetTotalReferralFunded(" + this.iContactID + ", " + this.CurrUser.iUserID + ") as TotalReferralFunded, "
+ "dbo.lpfn_GetTotalReferral_FileIDs(" + this.iContactID + ", " + this.CurrUser.iUserID + ") as TotalReferralFileIDs, "
+ "isnull(dbo.lpfn_GetTotalReferralFunded(" + this.iContactID + ", " + this.CurrUser.iUserID + "),0)/dbo.lpfn_GetTotalReferral(" + this.iContactID + ", " + this.CurrUser.iUserID + ") as WinRatio";
DataTable ReferralAmountInfo = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql);
if (ReferralAmountInfo.Rows.Count > 0)
{
if (ReferralAmountInfo.Rows[0]["TotalReferral"] == DBNull.Value)
{
this.aTotalReferral.InnerText = string.Empty;
this.aTotalReferral.HRef = string.Empty;
}
else
{
this.aTotalReferral.InnerText = Convert.ToDecimal(ReferralAmountInfo.Rows[0]["TotalReferral"]).ToString("c0");
this.aTotalReferral.HRef = "javascript:window.parent.SetTab('PartnerContactDetailReferralstab.aspx',3);";
}
if (ReferralAmountInfo.Rows[0]["TotalReferralFunded"] == DBNull.Value)
{
this.lbTotalReferralFunded.Text = string.Empty;
}
else
{
this.lbTotalReferralFunded.Text = Convert.ToDecimal(ReferralAmountInfo.Rows[0]["TotalReferralFunded"]).ToString("c0");
}
if (ReferralAmountInfo.Rows[0]["WinRatio"] == DBNull.Value)
{
this.lbWinRatio.Text = string.Empty;
}
else
{
this.lbWinRatio.Text = Convert.ToDecimal(ReferralAmountInfo.Rows[0]["WinRatio"]).ToString("p0");
}
}
#endregion
}
