protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["HouseID"] != null)
{
HouseID = Request.QueryString["HouseID"];
string sql = string.Format(@"SELECT e.em_name as btName,ee.em_name as pkName,cc.Cus_id,h.shi_id,C.Remarks,
c.HID,case cc.PubliceType when '0' then '私客' else '公客' end as isGongKe,
c.OperatorID,c.BringCustomerID,c.exe_Date
FROM c_BringCustomer C
LEFT JOIN c_Customer cc on cc.CustomerID = C.CID
LEFT JOIN h_houseinfor h on h.HouseID = C.HID
LEFT JOIN e_Employee e on e.EmployeeID = C.BeltmanID
LEFT JOIN e_Employee ee on ee.EmployeeID = C.EscortEmployeeID1
where C.HID ={0}
and (cc.PubliceType=1
or (cc.PubliceType=0 {1})
)
order by C.exe_date desc",
HouseID,
"and " + GetRolePermissionEmployeeIds("查看带看", "c.OperatorID"));
DK.DataSource = c_BringCustomer.Meta.Query(sql).Tables[0];
DK.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["HouseID"] != null)
{
HouseID = Request.QueryString["HouseID"];
string sql = string.Format(@"select ID,ee.EmployeeID,ee.em_name as name1,ee1.em_name as name2,Money,ImgPic,hh.exe_date,he.Name state,HouseID,hh.Remark from h_HouseTimeLimitMsg hh
left join e_Employee ee on hh.EmployeeID=ee.EmployeeID
left join e_Employee ee1 on hh.ZRempID=ee1.EmployeeID
left join h_EntrustType he on hh.HouseState=he.EntrustTypeID
where HouseID={0}",
HouseID);
DK.DataSource = h_HouseTimeLimitMsg.Meta.Query(sql).Tables[0];
DK.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["HouseID"] != null)
{
HouseID = Request.QueryString["HouseID"];
DK.DataSource = c_BringCustomer.Meta.Query(@"SELECT e.em_name btName,cc.Cus_id,h.shi_id,i.Integral,C.*
FROM c_BringCustomer C
LEFT JOIN c_Customer cc on cc.CustomerID = C.CID
LEFT JOIN h_houseinfor h on h.HouseID=C.HID
LEFT JOIN e_Employee e on e.EmployeeID = C.BeltmanID
left join I_IntegralLog i on i.KeyValue=C.BringCustomerID
where C.HID=" + HouseID + @"
and i.TableName='c_BringCustomer'
order by C.exe_date desc").Tables[0];
DK.DataBind();
}
}
}
/// <summary>
/// Validates VAT number
/// </summary>
/// <returns>Corrected VAT number in VatNumber object</returns>
public static VatNumber Validate(string vat, EUCountry euCountry)
{
string countryCode = euCountry.ToString().ToUpper();
vat = vat.ToUpper();
CountryBase countryBase;
switch (euCountry)
{
case EUCountry.AT:
countryBase = new AT();
break;
case EUCountry.BE:
countryBase = new BE();
break;
case EUCountry.BG:
countryBase = new BG();
break;
case EUCountry.CY:
countryBase = new CY();
break;
case EUCountry.CZ:
countryBase = new CZ();
break;
case EUCountry.DE:
countryBase = new DE();
break;
case EUCountry.DK:
countryBase = new DK();
break;
case EUCountry.EE:
countryBase = new EE();
break;
case EUCountry.EL:
countryBase = new EL();
break;
case EUCountry.ES:
countryBase = new ES();
break;
case EUCountry.FI:
countryBase = new FI();
break;
case EUCountry.FR:
countryBase = new FR();
break;
case EUCountry.GB:
countryBase = new GB();
break;
case EUCountry.HR:
countryBase = new HR();
break;
case EUCountry.HU:
countryBase = new HU();
break;
case EUCountry.IE:
countryBase = new IE();
break;
case EUCountry.IT:
countryBase = new IT();
break;
case EUCountry.LT:
countryBase = new LT();
break;
case EUCountry.LU:
countryBase = new LU();
break;
case EUCountry.LV:
countryBase = new LV();
break;
case EUCountry.MT:
countryBase = new MT();
break;
case EUCountry.NL:
countryBase = new NL();
break;
case EUCountry.PL:
countryBase = new PL();
break;
case EUCountry.PT:
countryBase = new PT();
break;
case EUCountry.RO:
countryBase = new RO();
break;
case EUCountry.SE:
countryBase = new SE();
break;
case EUCountry.SI:
countryBase = new SI();
break;
case EUCountry.SK:
countryBase = new SK();
break;
default:
throw new InvalidCountryException();
}
if (countryBase.StripLetters)
{
return(new VatNumber(euCountry, countryBase.Validate(Strip(vat))));
}
return(new VatNumber(euCountry, countryBase.Validate(StripNoLetters(vat, countryCode))));
}
