示例#1
0
        protected void txtRegNo_ButtonClick(object source, DevExpress.Web.ASPxEditors.ButtonEditClickEventArgs e)
        {
            string sql = "SELECT Distinct cv.EngineNo AS [Engine No], cv.RegNo AS [Reg No], cv.ChassisNo AS [Chassis No],";

            sql += " c.CusDesc + ' ' + c.FatherHusName AS Customer FROM  CustomerVehicle cv INNER JOIN ";
            sql += " Customer c ON cv.CusCode = c.CusCode AND cv.DealerCode=c.DealerCode ";
            sql += " where cv.DealerCode IN ('AAAAA','" + Session["DealerCode"].ToString() + "') ";



            DataTable dt = new DataTable();

            dt = myFunc.GetData(sql);
        }
示例#2
0
 protected void cmbProdCode_ButtonClick(object source, DevExpress.Web.ASPxEditors.ButtonEditClickEventArgs e)
 {
 }